1Z0-053多项选择题每日一练(2019.03.21)

A. The target database must be in NOARCHIVELOG mode.
B. No backup is required of the database before you perform a TSPITR.
C. You must have all archived redo logs generated since the last backup up to the point to which you want to restore the transport set.
D. If you rename a tablespace， you can not perform a TSPITR to any point in time before that rename operation occurred.
E. If you have tables in tablespace_1 that have associated constraints in tablespace_2，then you must transport both tablespaces.

A. Database must be running in archivelog mode.
B. Automatic undo management must be enabled.
C. Undo retention guarantee must be enabled.
D. The tablespace on which the Flashback Data Archive is created must be managed with Automatic Segment Space Management (ASSM).

A. Stored scripts in the recovery catalog
B. Backups that can be deleted from disk
C. Backup sets and images copies that are obsolete
D. Backups that do not have the AVAILABLE status in the RMAN repository

A. The plans can be manually loaded to the SQL plan baseline.
B. The plans in the SQL plan baseline are verified and accepted plans.
C. The plans generated for every SQL statement are stored in the SQL plan baseline by default. 
D. The plan baselines are stored temporarily in the memory as long as the database instance is running.
E. For the SQL plan baselines to be accessible to the optimizer， the SYSAUX tablespace must be online.

A. You can use RMAN stored scripts
B. Recovery is faster if data is stored in catalog in addition to the control file
C. You can store backup information of all registered databases in one place
D. Database backups are automatically deleted when they are older than the specified time period