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. What is the use of extent in Oracle?

Answer

Minimize the amount of wasted (empty) storage

Answer

None of the Mentioned

Answer

Stores user data within the database

Answer

Stores rollback information used when data must be rolled back

Question 2

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

Answer

ORACLE_HOME

Answer

ORACLE_BASE

Answer

ORACLE_ROOT

Answer

ORACLE_SERVER

Question 3

3. We can create SNAPSHOTLOG for DBA?

Answer

Simple snapshots

Answer

Neither A nor

Answer

Complex snapshots

Answer

Both A & B

Question 4

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

Question 5

5. Which processes is an instance made of Oracle?

Answer

Memory processes

Answer

All of the Mentioned

Answer

Oracle background processes

Answer

Data processes

Question 6

6. Constraints cannot be exported through EXPORT command

Question 7

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

Answer

For application sharing

Answer

None of the above

Answer

To implement business rules centrally

Answer

To reduce network traffic

Question 8

8. What is the use of an index?

Answer

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

Answer

Retrieve data more quickly and efficiently

Answer

All of them

Answer

Simplify the user’s perception of data access

Question 9

9. What is the use of Library cache?

Answer

All of the Mentioned

Answer

Contains User information, such as user privileges

Answer

Used to store shared SQL

Answer

Log of changes made to the database

Question 10

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

Answer

All of the Mentioned

Answer

Object Segment

Answer

Data Segment

Answer

Temporary Segment

Question 11

11. A data block is?

Answer

The largest logical storage unit ever available for any database block

Answer

All of the above

Answer

The smallest logical storage unit for a database object

Answer

The place where all deleted records are persisted

Question 12

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

Answer

Library cache

Answer

Data dictionary

Question 13

13. SNAPSHOT is used for DBA?

Answer

System server

Answer

Dynamic data replication

Answer

Table space

Question 14

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

Answer

Buffer cache

Answer

PGA and Buffer cache

Question 15

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

Answer

A table space

Answer

A partition

Question 16

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

Answer

Stack space

Answer

Session area

Answer

Private SQL area

Question 17

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

Answer

Database related background processes

Answer

Tablespaces

Answer

All of the Mentioned

Question 18

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

Answer

Permanent Segment

Answer

All of the Mentioned

Answer

Data Segment

Answer

Object Segment

Question 19

19. What does DLL stands for ?

Answer

Dynamic Language Library

Answer

None of the above

Answer

Dynamic Load Library

Answer

Dynamic Link Library

Question 20

20. 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 segment is shutdown that they are trying to access

Answer

The Oracle instance is shutdown that they are trying to access

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:

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:

Related Content

Maan Ali

Leave a Reply Cancel reply