> > Oracle MCQs > Managing The Undo Tablespace MCQs

Managing The Undo Tablespace MCQ

1. Data files of which tablespaces can be recovered by performing an open recovery?

All

TEMP

Index

Answer

Correct Answer: All

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

2. Identify the common Dynamic Performance views which are accessible in NOMOUNT stage?

V$PARAMETER, V$OPTION, V$SGA

None

V$CONTROLFILE, V$DATABASE

V$THREAT, V$LOGFILE, V$DATAFILE

Answer

Correct Answer: V$PARAMETER, V$OPTION, V$SGA

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

3. You require the Oracle server to manage the undo segments and space among various active sessions automatically. You created an undo tablespace, UNDO_TBS1, in your database. Which two additional steps would you perform to achieve this?

Create an initial undo segment in the undo tablespace

Set the UNDO_TABLESPACE parameter to UNDO_TBS1

Set the UNDO_TABLESPACE parameter to UNDO_TBS1 And Set the UNDO_MANAGEMENT initialization parameter to AUTO

Set the UNDO_MANAGEMENT initialization parameter to AUTO

Answer

Correct Answer: Set the UNDO_TABLESPACE parameter to UNDO_TBS1 And Set the UNDO_MANAGEMENT initialization parameter to AUTO

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

4. The Database Resource Manager directive UNDO_POOL allows DBAs to limit the amount of undo space consumed by a group of users?

True

False

Answer

Correct Answer: True

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

5. Which three pieces of information are considered while deciding the size of the undo tablespace in your database?

The size of the redo log files

The value of the UNDO_RETENTION parameter

The size of an undo block And Undo blocks generated per second And The value of the UNDO_RETENTION parameter

The size of an undo block

Undo blocks generated per second

Answer

Correct Answer: The size of an undo block And Undo blocks generated per second And The value of the UNDO_RETENTION parameter

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

6. In the following which is the default permanent tablespace?

None

Users

TEMP

UNDOTBS1

Answer

Correct Answer: Users

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

7. The switch operation waits for transactions in the old undo tablespace to commit?

True

False

Answer

Correct Answer: False

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

8. Which two statements about Flashback Query are true?

It helps in row-level recovery from user errors And It fails when undo data pertaining to the transaction is overwritten

It helps in row-level recovery from user errors

It fails when undo data pertaining to the transaction is overwritten

It can be performed to recover ALTER TABLE statements

Answer

Correct Answer: It helps in row-level recovery from user errors And It fails when undo data pertaining to the transaction is overwritten

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

9. Which two operations can be flashed back using the Flashback technology?

DROP USER SACHIN; And DROP TABLE STUDENTS;

DROP TABLESPACE USERS;

DROP TABLE STUDENTS;

DROP USER SACHIN;

Answer

Correct Answer: DROP USER SACHIN; And DROP TABLE STUDENTS;

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

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

Correct Answer: V$UNDOSTAT

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

Oracle MCQs | Topic-wise

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