Oracle MCQs (Chapterwise Multiple Choice Questions)

The indoubt transaction locks data that is required by other transactions. This situation occurs when the ORA-01591 error message interferes with user transactions.

True

False

Answer & Explanation

Correct Answer: True

Note: This Question is unanswered, help us to find answer for this one

In which partition this form of composite partitioning is well suited for historical data, but lets you further group the rows of data based on unordered or unrelated column values?

Range-Hash Partition And Range-List Partition

None

Range-Hash Partition

Range-List Partition

Answer & Explanation

Correct Answer: Range-List Partition

Note: This Question is unanswered, help us to find answer for this one

In viewing information about undo which view is useful for monitoring the effects of transaction execution on undo space in the current instance?

DBA_UNDO_EXTENTS

V$ROLLSTAT

V$TRANSACTION

V$UNDOSTAT

Answer & Explanation

Correct Answer: V$UNDOSTAT

Note: This Question is unanswered, help us to find answer for this one

In Viewing Tablespace Information which view gives Information for all extents in all locally managed temporary tablespaces?

V$TEMP_SPACE_HEADER

V$TEMP_EXTENT_MAP

V$TEMPSEG_USAGE

V$TEMP_EXTENT_POOL

Answer & Explanation

Correct Answer: V$TEMP_EXTENT_MAP

Note: This Question is unanswered, help us to find answer for this one

Your database is running in the ARCHIVELOG mode. You placed a tablespace, tbs_1, offline with the immediate option. Which statement is correct in this scenario?

The operation would fail if tbs_1 were the default tablespace for the database

The operation would fail if tbs_1 were a read/write tablespace

The operation would fail if tbs_1 were a read-only tablespace

If the above operation were successful, media recovery would be required to bring the Tablespace online

Answer & Explanation

Correct Answer: If the above operation were successful, media recovery would be required to bring the Tablespace online

Note: This Question is unanswered, help us to find answer for this one

Which mode protects a database from instance failure but not from media failure?

ARCHIVELOG MODE

NOARCHIVELOG MODE

ARCHIVELOG MODE And NOARCHIVELOG MODE

None

Answer & Explanation

Correct Answer: NOARCHIVELOG MODE

Note: This Question is unanswered, help us to find answer for this one

Transporting tablespaces with XMLTypes has the following additional limitations?

All

Advanced Queues And Floating-Point Numbers

SYSTEM Tablespace Objects

Opaque Types

Answer & Explanation

Correct Answer: All

Note: This Question is unanswered, help us to find answer for this one

Controlling Trace Output Generated by the Archivelog Process in which trace value 64 is?

Tracks asynchronous LGWR activity

Supported in a future release

Track FAL (fetch archived log) server related activities

Track ARCn process state activity

Answer & Explanation

Correct Answer: Track ARCn process state activity

Note: This Question is unanswered, help us to find answer for this one

The rules for creating range-partitioned global indexes are similar to those for creating range-partitioned tables?

True

False

Answer & Explanation

Correct Answer: True

Note: This Question is unanswered, help us to find answer for this one

Which two statements are true about the roles in the Oracle database?

A role can be granted to itself

Roles can be granted to other roles

A role can contain both system and object privileges

Roles can be granted to other roles And A role can contain both system and object privileges

Answer & Explanation

Correct Answer: Roles can be granted to other roles And A role can contain both system and object privileges

Note: This Question is unanswered, help us to find answer for this one

Oracle Quick Quiz

Poor Results!

You need a lot of improvement.

Just don't give up!

Correct Answers: 0/10

Start Practicing with our MCQs given below.

MCQ on Basic Oracle	MCQ on Managing Archived Redo Logs
MCQ on Managing Clusters	MCQ on Managing Control Files
MCQ on Managing Data-files And Temp-files	MCQ on Managing Hash Clusters
MCQ on Managing Indexes	MCQ on Managing Oracle Database Processes
MCQ on Managing Oracle Distributed Transactions	MCQ on Managing Partitioned Tables And Indexes
MCQ on Managing Space For Schema Objects	MCQ on Managing Tables
MCQ on Managing Tablespaces	MCQ on Managing The Redo Log
MCQ on Managing The Undo Tablespace	MCQ on Managing Views, Sequences, And Synonyms
MCQ on Oracle Distributed Transactions Concepts	MCQ on Oracle WebLogic
General Oracle MCQs