Oracle Mcqs Test Online

Q: How can I prepare for Oracle Mcqs Test Online?

You can prepare for Oracle Mcqs Test Online by attempting the free online quizzes at Gotest.com.pk. We provide instant results, performance reports, and detailed explanations for every question.

Question 1

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

Answer

Data dictionary

Answer

Library cache

Question 2

2. We can create SNAPSHOTLOG for DBA?

Answer

Both A & B

Answer

Simple snapshots

Answer

Neither A nor

Answer

Complex snapshots

Question 3

3. What is the use of extent in Oracle?

Answer

Stores user data within the database

Answer

None of the Mentioned

Answer

Minimize the amount of wasted (empty) storage

Answer

Stores rollback information used when data must be rolled back

Question 4

4. Which processes is an instance made of Oracle?

Answer

Oracle background processes

Answer

Memory processes

Answer

Data processes

Answer

All of the Mentioned

Question 5

5. Which of the following is not an reason for the fact that most of the processing is done at the server ?

Answer

To reduce network traffic

Answer

To implement business rules centrally

Answer

None of the above

Answer

For application sharing

Question 6

6. SNAPSHOT is used for DBA?

Answer

Table space

Answer

System server

Answer

Dynamic data replication

Question 7

7. Which of the following segment is destroyed when the SQL statement is finished?

Answer

Temporary Segment

Answer

Object Segment

Answer

All of the Mentioned

Answer

Data Segment

Question 8

8. What is the probable cause for getting the following error stack?

ERROR: ORA-01034: ORACLE not available
ORA-07318: smsget: open error when opening sgadef.dbf file.
HP-UX Error: 2: No such file or directory

Answer

None of the above

Answer

The Oracle namespace is shutdown that they are trying to access

Answer

The Oracle instance is shutdown that they are trying to access

Answer

The Oracle segment is shutdown that they are trying to access

Question 9

9. A CONTROL BLOCK can sometimes refer to a BASETABLE ?

Question 10

10. Which of the following components comprise an Oracle architecture?

Answer

All of the Mentioned

Answer

Database related background processes

Answer

Tablespaces

Question 11

11. In Oracle, which of below are types of segments?

Answer

Object Segment

Answer

Data Segment

Answer

Permanent Segment

Answer

All of the Mentioned

Question 12

12. What does DLL stands for ?

Answer

Dynamic Language Library

Answer

Dynamic Load Library

Answer

None of the above

Answer

Dynamic Link Library

Question 13

13. ____________ is an area on disk which comprises of one or more disk files?

Answer

A partition

Answer

A table space

Question 14

14. The redo log buffer and Shared pool are elements of?

Answer

PGA and Buffer cache

Answer

Buffer cache

Question 15

15. A data block is?

Answer

The smallest logical storage unit for a database object

Answer

The place where all deleted records are persisted

Answer

All of the above

Answer

The largest logical storage unit ever available for any database block

Question 16

16. Which area of PGA stores binding variables and run-time buffers information?

Answer

Session area

Answer

Private SQL area

Answer

Stack space

Question 17

17. What is the use of an index?

Answer

Retrieve data more quickly and efficiently

Answer

Simplify the user’s perception of data access

Answer

All of them

Answer

Related data requires much less I/O overhead if accessed simultaneously

Question 18

18. What is the use of Library cache?

Answer

Log of changes made to the database

Answer

Contains User information, such as user privileges

Answer

Used to store shared SQL

Answer

All of the Mentioned

Question 19

19. Which of the following is the root directory for oracle?

Answer

ORACLE_HOME

Answer

ORACLE_SERVER

Answer

ORACLE_ROOT

Answer

ORACLE_BASE

Question 20

20. Constraints cannot be exported through EXPORT command

Question 21

Loading...

Total Questions:	20
Time Allowed:	10 Minutes
Total Marks:	20
How to Attempt Test:	Please choose the right Option in MCQ-type question.
Test Helpful For:	Computer Test Competitive exam Forces test Fpsc Entry test Recruitment test

Oracle Mcqs Test Online

Oracle Mcqs Test

Oracle Mcqs Test Practice Online

Study Plan for Oracle Mcqs Test Online

How to Use GoTest for Preparation:

More Related Resources

Maan Ali

Leave a Reply Cancel reply

Oracle Mcqs Test

Oracle Mcqs Test Practice Online

Study Plan for Oracle Mcqs Test Online

How to Use GoTest for Preparation:

More Related Resources

Latest Updates

Maan Ali

Leave a Reply Cancel reply