1Z0-042多項選擇題每日一練(2020.03.29)

多項選擇題
Identify the two tablespaces whose data files are so critical that only a closed recovery is possible.（）
A.SYSAUX
B.TOOLS
C.UNDO
D.INDEX
E.SYSTEM
F.USERS
G.TEMP
單項選擇題
Your Supportcenter.cn database is in ARCHIVELOG mode. The data file that belongs to the SYSTEM tablespace has become corrupted. Up to what point can you recover the database？（）
A.Until last commit
B.Until the time you perform recovery
C.Until the time the date file got corrupted
D.Until the point where the last transaction begun
E.You cannot recover the SYSTEMtablespaceand must re-create the database.
單項選擇題
You have a production instance running on your server. UNDO_RETENTION is not long enough to satisfy read-consistency requirements. How do you change the UNDO_RETENTION value？（）
A.A
B.B
C.C
D.D
單項選擇題
You work as a database administrator for Certkiller .com. Users in the Certkiller .com PROD database complain about the slow response of transactions. While investigating the reason you find that the transactions are waiting for the undo segments to be available， and undo retention has been set to zero. What would you do to overcome this problem？（）
A.Increase the undo return
B.Create more undo segments
C.Create another undotablespace
D.Increase the size of the undotablespace
單項選擇題
View the Exhibit to see the output of queries on DATABASEPROPERTIES and DBAUSERS.You observe that the current default permanent tablespace of the database is running out of space and you decide to change it to NEWDEFTBSP. You create a new user， USER04， after changing the default permanent tablespace of the database. What would be the new user’s default tablespace？（）
A.DEFTBSP
B.SYSTEM
C.NEWDEFTBSP
D.USERS and NEWDEFTBSP both
E.USERS