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. SNAPSHOT is used for DBA?

Answer

Table space

Answer

System server

Answer

Dynamic data replication

Question 2

2. What is the use of Library cache?

Answer

Used to store shared SQL

Answer

Contains User information, such as user privileges

Answer

Log of changes made to the database

Answer

All of the Mentioned

Question 3

3. 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

The Oracle segment is shutdown that they are trying to access

Answer

The Oracle instance is shutdown that they are trying to access

Answer

The Oracle namespace is shutdown that they are trying to access

Answer

None of the above

Question 4

4. We can create SNAPSHOTLOG for DBA?

Answer

Neither A nor

Answer

Complex snapshots

Answer

Simple snapshots

Answer

Both A & B

Question 5

5. What is the use of extent in Oracle?

Answer

Stores user data within the database

Answer

Stores rollback information used when data must be rolled back

Answer

Minimize the amount of wasted (empty) storage

Answer

None of the Mentioned

Question 6

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

Answer

All of the Mentioned

Answer

Object Segment

Answer

Data Segment

Answer

Permanent Segment

Question 7

7. What does DLL stands for ?

Answer

Dynamic Link Library

Answer

Dynamic Load Library

Answer

Dynamic Language Library

Answer

None of the above

Question 8

8. 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 9

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

Answer

Object Segment

Answer

All of the Mentioned

Answer

Temporary Segment

Answer

Data Segment

Question 10

10. A data block is?

Answer

The place where all deleted records are persisted

Answer

The smallest logical storage unit for a database object

Answer

All of the above

Answer

The largest logical storage unit ever available for any database block

Question 11

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

Answer

PGA and Buffer cache

Answer

Buffer cache

Question 12

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

Answer

Database related background processes

Answer

All of the Mentioned

Answer

Tablespaces

Question 13

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

Question 14

14. Constraints cannot be exported through EXPORT command

Question 15

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

Answer

Session area

Answer

Private SQL area

Answer

Stack space

Question 16

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

Answer

ORACLE_HOME

Answer

ORACLE_SERVER

Answer

ORACLE_BASE

Answer

ORACLE_ROOT

Question 17

17. Which processes is an instance made of Oracle?

Answer

Memory processes

Answer

All of the Mentioned

Answer

Oracle background processes

Answer

Data processes

Question 18

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

Answer

Library cache

Answer

Data dictionary

Question 19

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

Answer

To implement business rules centrally

Answer

To reduce network traffic

Answer

None of the above

Answer

For application sharing

Question 20

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

Answer

A partition

Answer

A table space

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