05th
May

Oracle MCQ

Admin
05th May, 2021
523 Followers

Latest MCQ Tests

Pratice HR Questions

Oracle MCQ Quiz

Following are mostly asked Oracle MCQ test that are designed for professionals like you to crack you interviews. You can take this Oracle online test before appearing to you real interview. This Oracle quiz there are around 30+ multiple choice questions on Oracle with four options.

1) Oracle Database is an ___.

A. RDBMS

B. Query
C. laguage
D. sql

2) SQL is a set-based _____ language that provides an interface to an RDBMS such as Oracle Database.

A. declarative

B. optionl
C. programming
D. scripting

3) SQL stands for ______.

A. Structureral query language
B. Structured query language

C. Structureral query language
D. Script query language

4) Which of the following statements contains an error?

A. SELECT empid FROM emp;
B. SELECT empid WHERE empid = 56949 AND lastname = ‘SMITH’;

C. SELECT * FROM emp WHERE empid = 493945;
D. SELECT empid FROM emp WHERE empid= 493945;

5) SQL is a computer language for ______ data stored in a relational database.

A. storing, manipulating and retrieving

B. creating webpage
C. programming code
D. None of the above

Download Free : Oracle MCQ PDF

6) How do you select all the records from a table named "EMP" where the value of the column "Last_Name" is "KING"?

A. SELECT [all] FROM EMP WHERE Last_Name LIKE 'KING'
B. SELECT [all] FROM EMP WHERE Last_Name ='KING'
C. SELECT * FROM EMP WHERE Last_Name LIKE 'KING'
D. SELECT * FROM EMP WHERE Last_Name ='KING'

7) What do you mean by tuple is a RDBMS?

A. Row of a table.

B. Two dimensional table
C. Key of a table.
D. Column of a table.

8) The primary key is selected from the:

A. Composite keys.
B. Foreign keys.
C. Determinants.
D. Candidate keys.

9) Which process is an instance made of oracle?

A. Memory processes
B. Data processes
C. Oracle background processes

D. All are Correct

10) Oracle database design is also called ____.

A. Database Instance
B. Database Schema

C. Database Abstraction
D. None of the above

Read Best: Oracle Interview Questions

11) Where is the data dictionary kept?

A. Stack Space
B. SYSTEM tablespace

C. Data file
D. None of the above

12) Insert and Update is a ____.

A. DDL
B. DML

C. HTML
D. None of the above

13) Create, alter and drop are a _____.

A. DDL

B. DML
C. DQL
D. DCL

14) What is the extension of Oracle SQL*Plus file?

A. .pls
B. .ora
C. .txt
D. .sql

15) Which of the following is the fastest query method for a table?

A. Fetch by columnid
B. Fetch by indexid
C. Fetch by rowid

D. Fetch by tableid

Download Free: Oracle Interview Questions PDF

16) All of the following can only be used with numeric data types except:

A. AVG
B. STDDEV
C. SUM
D. COUNT

17) Which task of the Database Administrator is available for cloning on Oracle home and on a database?

A. Download and Install Patches d.
B. Roll Out to Additional Hosts

C. Back Up the Fully Functional Database
D. Tune Database Performance

18) Constraints cannot be exported through EXPORT command.

A. True
B. False

19) What does DLL stands for ?

A. Dynamic Language Library
B. Dynamic Link Library

C. Dynamic Load Library
D. None of the above

20) 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 ____.

A. database triggers

B. table
C. row
D. language

21) What is SQL*FORMS ?

A. SQL*FORMS is a 4GL tool for developing & executing Oracle based interactive applications.

B. SQL*FORMS is a 3GL tool for connecting to the Database.
C. SQL*FORMS is a reporting tool
D. None of the above.

22) The System Global Area (SGA) is a group of ____, known as SGA components, that contain data and control information for one Oracle Database instance.

A. shared memory structures

B. partial memory structures
C. database
D. None of the above

23) A Stored Procedure is a ____.

A. Sequence of SQL or PL/SQL statements to perform specific function
B. Stored in compiled form in the database
C. Can be called from all client environmets
D. All are Correct

24) In Oracle, view is a virtual table that does not physically exist. view is created by a ____ one or more tables.

A. query joining

B. DDL
C. DML
D. None of the above.

25) What is the use of Library cache?

A. Contains User information, such as user privileges
B. Used to store shared SQL

C. Log of changes made to the database
D. All of the Mentioned

26) What is the use of an index?

A. Retrieve data more quickly and efficiently

B. Related data requires much less I/O overhead if accessed simultaneously
C. Simplify the user’s perception of data access
D. All of the Mentioned

27) The ____________ contains a set of tables and views that Oracle uses as a reference to the database.

A. PGA
B. Library cache
C. SGA
D. Data dictionary

28) The redo log buffer and Shared pool are elements of ___.

A. PGA
B. SGA

C. PGA and Buffer cache
D. Buffer cache

29) What type of failure occurs when Oracle fails due to an operating system or computer hardware failure?

A. Application failure
B. Rollback failure
C. Instance Failure

D. Media Failure

30) Which prefixes are available to Oracle triggers?

A. :new only
B. :old only
C. Both :new and :old

D. Neither :new nor :old

31) In creating a procedure, you may get a message if you have compile errors. Which of the following is true?

A. SQL*Plus will automatically show the errors to you.
B. The line numbers reported match the line numbers you see in your text editor.
C. To see the errors, enter SHOW ERRORS in SQL*Plus.

D. If there are no syntax errors, you will receive the message "NO ERRORS."

32) Money is defined in Oracle with the Currency data type.

A. True
B. False

33) Select statement is used to insert records in a database table.

A. False

B. True

34) When using SQL*Plus, Oracle commands, column names, table names and all other database elements:

A. are case insensitive.

B. must always be in upper case.
C. are case sensitive.
D. must always be in lower case.

35) Which one of the following SQL phrase is not supported by Oracle?

A. ON UPDATE CASCADE

B. DROP SEQUENCE [SequenceName]
C. ON DELETE CASCADE
D. CREATE SEQUENCE [SequenceName]

36) Which of the following is not true of SQL views?

A. Oracle views can by queried.
B. The SQL-92 standard does not allow the use of the ORDER BY clause in view definitions.
C. Oracle views cannot use the ORDER BY clause in view definitions.