20th
Oct
Oct

Oracle MCQ
- Admin
- 20th Oct, 2020
- 418 Followers
Latest MCQ Tests
Pratice HR Questions
Oracle MCQ Quiz
1) What does DLL stands for ?
2) What is the extension of Oracle SQL*Plus file?
3) The System Global Area (SGA) is a group of ____, known as SGA components, that contain data and control information for one Oracle Database instance.
4) Which one is the new feature of Oracle Database 12c?
5) All of the following can only be used with numeric data types except:
Download Free : Oracle MCQ PDF
6) What is the use of an index?
7) The redo log buffer and Shared pool are elements of ___.
8) A Stored Procedure is a ____.
9) Oracle allows you to define procedures that are implicitly executed when an INSERT, UPDATE, or DELETE statement is issued against the associated table. These procedures are called ____.
10) What type of failure occurs when Oracle fails due to an operating system or computer hardware failure?
11) Which one is the advange of oracle over other RDBMS?
12) Which of the following statements contains an error?
13) What do you mean by tuple is a RDBMS?
14) Select statement is used to insert records in a database table.
15) Money is defined in Oracle with the Currency data type.
16) Constraints cannot be exported through EXPORT command.
17) ____ is the latest innovations in Oracle.
18) Which one of the following SQL phrase is not supported by Oracle?
19) What is the use of Library cache?
20) When using SQL*Plus, Oracle commands, column names, table names and all other database elements:
21) Which prefixes are available to Oracle triggers?
22) The primary key is selected from the:
23) Which of the following is not true of SQL views?
24) Insert and Update is a ____.
25) The ____________ contains a set of tables and views that Oracle uses as a reference to the database.
26) Create, alter and drop are a _____.
27) SQL is a set-based _____ language that provides an interface to an RDBMS such as Oracle Database.
28) Which task of the Database Administrator is available for cloning on Oracle home and on a database?
29) In Oracle, view is a virtual table that does not physically exist. view is created by a ____ one or more tables.
30) Which of the following is the fastest query method for a table?
31) Where is the data dictionary kept?
32) Which process is an instance made of oracle?
33) SQL is a computer language for ______ data stored in a relational database.
34) What is SQL*FORMS ?
35) In creating a procedure, you may get a message if you have compile errors. Which of the following is true?
36) SQL stands for ______.
37) How do you select all the records from a table named "EMP" where the value of the column "Last_Name" is "KING"?
38) A disadvantage of using Oracle is its cost.
39) Oracle database design is also called ____.
40) Oracle Database is an ___.
Leave A Comment :
Valid name is required.
Valid name is required.
Valid email id is required.