1z0-043多項(xiàng)選擇題每日一練(2019.03.21)

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

1 In your database， all the tablespaces are locally managed. You started Recovery Manager （RMAN） using recovery catalog and restored the control file by using the following command：
RMAN> RESTORE CONTROLFILE；
Which two operations do you need to perform after restoring the control file from backup？（）

點(diǎn)擊查看答案

2 The loss of which two types of files may require a recovery with the RESETLOGS option？（）

點(diǎn)擊查看答案

3 You set the undo pool resource plan directive for the consumer group named DSS_USERS that is assigned to the DAY_SHIFT plan. The database users， SCOTT and BLAKE， belong to the DSS_USERS resource group. The user， SCOTT， initiates a database session and executes a batch operation that inserts millions of rows into the HISTORY table. Which two options are true if the total undo space allocated to the DSS_USERS group exceeds the value specified in the undo pool resource plan directive？（）

點(diǎn)擊查看答案

4 You are working in a dedicated server environment. Your database is running in the automatic Program Global Area （PGA） memory management mode.
Which two statements are correct in this scenario？（）

點(diǎn)擊查看答案

5 You have created a resource plan， PROD_DB_PLAN， with the following consumer groups with the respective plan directives：
Consumer group SALES with CPU_P1 as 60 and DEGREE_OF_PARALLELISM as 4.
Consumer group MARKET with CPU_P1 as 20.
Consumer group DEV with CPU_P1 as 20.
Consumer group OTHERS with CPU_P1 as 0 and CPU_P2 as 100.
Which two statements are correct in this scenario？（）

點(diǎn)擊查看答案

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