Managing The Undo Tablespace MCQs
Managing The Undo Tablespace MCQs
Our team has conducted extensive research to compile a set of Managing The Undo Tablespace MCQs. We encourage you to test your Managing The Undo Tablespace knowledge by answering these multiple-choice questions provided below.
Simply scroll down to begin!
1: In viewing information about undo which view is useful for monitoring the effects of transaction execution on undo space in the current instance?
A. DBA_UNDO_EXTENTS
B. V$ROLLSTAT
C. V$TRANSACTION
D. V$UNDOSTAT
2: Which two operations can be flashed back using the Flashback technology?
A. DROP USER SACHIN; And DROP TABLE STUDENTS;
B. DROP TABLESPACE USERS;
C. DROP TABLE STUDENTS;
D. DROP USER SACHIN;
3: Which two statements about Flashback Query are true?
A. It helps in row-level recovery from user errors And It fails when undo data pertaining to the transaction is overwritten
B. It helps in row-level recovery from user errors
C. It fails when undo data pertaining to the transaction is overwritten
D. It can be performed to recover ALTER TABLE statements
4: The switch operation waits for transactions in the old undo tablespace to commit?
A. True
B. False
5: In the following which is the default permanent tablespace?
A. None
B. Users
C. TEMP
D. UNDOTBS1
6: Which three pieces of information are considered while deciding the size of the undo tablespace in your database?
A. The size of the redo log files
B. The value of the UNDO_RETENTION parameter
C. The size of an undo block And Undo blocks generated per second And The value of the UNDO_RETENTION parameter
D. The size of an undo block
E. Undo blocks generated per second
7: The Database Resource Manager directive UNDO_POOL allows DBAs to limit the amount of undo space consumed by a group of users?
A. True
B. False
8: 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?
A. Create an initial undo segment in the undo tablespace
B. Set the UNDO_TABLESPACE parameter to UNDO_TBS1
C. Set the UNDO_TABLESPACE parameter to UNDO_TBS1 And Set the UNDO_MANAGEMENT initialization parameter to AUTO
D. Set the UNDO_MANAGEMENT initialization parameter to AUTO
9: Identify the common Dynamic Performance views which are accessible in NOMOUNT stage?
A. V$PARAMETER, V$OPTION, V$SGA
B. None
C. V$CONTROLFILE, V$DATABASE
D. V$THREAT, V$LOGFILE, V$DATAFILE
10: Data files of which tablespaces can be recovered by performing an open recovery?
A. All
B. TEMP
C. V
D. Index
List of Managing The Undo Tabl...
Available in:
Managing The Undo Tablespace MCQs
