> > Oracle MCQs > Managing The Undo Tablespace MCQs

Managing The Undo Tablespace MCQ

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

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

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

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

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

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

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

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

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

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