053(五十五）

271、Examine the output of the query that you executed to list the objects in the recycle bin:

You verified that no table named SALES_TAB exists in the schema. 
Then you executed the following command to purge the objects in the recycle bin:
SQL> PURGE TABLE sales_tab;
What would be the outcome of this command?
A. All three tables in the recycle bin are purged
B. Only the table with the oldest DROPSCN is purged
C. The command returns an error because multiple entries with the same name exist in the recycle bin
D. Only the table with the latest DROPSCN is purged

Answer: B


SQL> select original_name,droptime,dropscn from user_recyclebin;
 
ORIGINAL_NAME                    DROPTIME               DROPSCN
-------------------------------- ------------------- ----------
TEMP_ZJA_AREA                    2016-04-15:18:15:51 1220713283
TEMP_ZJA_ORG                     2016-04-16:10:48:29 1220748462
TEST1                            2016-04-29:16:32:30 1220944938
TEST1                            2016-04-29:16:32:37 1220944938
TEST1                            2016-04-29:16:32:43 1220944938
 
SQL> purge table test1;
 
Done
 
SQL> select original_name,droptime,dropscn from user_recyclebin;
 
ORIGINAL_NAME                    DROPTIME               DROPSCN
-------------------------------- ------------------- ----------
TEMP_ZJA_AREA                    2016-04-15:18:15:51 1220713283
TEMP_ZJA_ORG                     2016-04-16:10:48:29 1220748462
TEST1                            2016-04-29:16:32:37 1220944938
TEST1                            2016-04-29:16:32:43 1220944938

View Code

 

272、

272.You issue the following RMAN command to set a retention policy on a database: 
RMAN>CONFIGURE RETENTION POLICY TO REDUNDANCY 2;
What will be the outcome of issuing this command?
A. After two days, a backup will be marked obsolete
B. After two days, a backup will be deleted from the media
C. If the RMAN repository has records of two or more recent backups of a file, then older backups will be deleted from the media.
D. If the RMAN repository has records of two or more recent backups of a file, then older backups will be marked obsolete.

Answer: D

View Code

 

273、

273.Which statements are true regarding the system-defined moving window baseline in Oracle Database 11g? (Choose all that apply.)
A. It does not allow you to change the moving window size.
B. Adaptive threshold functionalities use it by default to compute statistics.
C. It is created by default with the window size being equal to the AWR retention time.
D. It is created when the first snapshot is collected by the Automatic Workload Repository (AWR).

Answer: BC

View Code

 

274、

274.The SQL Tuning Advisor has been configured with default configurations in your database instance. 
Which recommendation is automatically implemented without the DBA's intervention after the SQL Tuning Advisor is run as part of the AUTOTASK framework?
A. statistics recommendations
B. SQL profile recommendations
C. index-related recommendations
D. restructuring of SQL recommendations

Answer: B

View Code

 

275、

275.You have enabled resumable space allocation in your database by setting the RESUMABLE_TIMEOUT parameter set to a nonzero value.
Which three statements about resumable space allocation are true? (Choose three.)
A. Even with resumable space allocation enabled for your database, you can disable resumable space allocation for a single session.
B. A resumable statement is suspended only if an out of space error occurs.
C. When a resumable statement is suspended, the transaction that contains the statement is also suspended.
D. A resumable statement can only be suspended and resumed once during the execution of the statement.
E. You can query the V$SESSION_WAIT dynamic performance view to identify the statements that are suspended for a session.

Answer: ACE 

View Code

 

转载于:https://www.cnblogs.com/huanhuanang/p/5445481.html