1z0-043章节练习(2019.05.03)

You are the Database Administrator （DBA） of your company. You execute the following statement on an Oracle 10g instance：  
SQL> ALTER SYSTEM SWITCH LOGFILE；  
Which two tasks are performed when the statement is executed？ （）

The backup retention policy is configured as RECOVERY WINDOW 2. You executed the following command in Recovery Manager （RMAN） against your database： 
RMAN> REPORT OBSOLETE; 
What would you see in the output？（）

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

View the Exhibit and examine the Flashback Database architecture. 
Identify the missing component （shown with a "？"） in the Flashback Database architecture.（）

The warning level threshold value for a tablespace， DATA1， is set to 60% and the critical level threshold value is set to 80%. The tablespace， DATA1， is infrequently used and is not a part of the production environment. You issued the following command：       
SQL> EXECUTE  
DBMS_SERVER_ALERT.SET_THRESHOLD       
（dbms_server_alert.tablespace_pct_full，       
dbms_server_alert.operator_ge，80，       
dbms_server_alert.operator_ge，90，       
1，1，NULL，  
dbms_server_alert.object_type_tablespace，’DATA’）；  
What will be the result of the command？（）