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

來(lái)源：考試資料網(wǎng)

1 Identify the two tablespaces whose data files are so critical that only a closed recovery is possible.（）

2 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？（）

點(diǎn)擊查看答案

3 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？（）

點(diǎn)擊查看答案

4 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？（）

點(diǎn)擊查看答案

5 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？（）

點(diǎn)擊查看答案

广告位招租联系QQ:5245112（WX同号）