CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default

CONFIGURE BACKUP OPTIMIZATION  OFF; # default

CONFIGURE CONTROLFILE AUTOBACKUP  OFF; # default

CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO COPY; 

CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default 

Examine the command： 

RMAN> BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT; 

Which 2 are true?

1.RETENTION NOGUARANTEE

2.UNDO_RETENTION is 12 minutes

User SCOTT get this error after a query on the SALES table has run for more than 15 minutes： ORA-01555： snapshot too old

Which three factors taken separately or in some combination might be the cause? 

Which two tools or utilities would you use to achieve this?

The SH user receives the following error while inserting data into the SALES table： ERROR at line 1：ORA-01653： unable to extend table SH.SALES by 128 in tablespace SMD. 

Which three actions can be taken to enable the user to insert data?

RMAN> DELETE OBSOLETE;

Which three statements are true in this scenario? 

SQL> ALTER SYSTEM SET ENABLE_DDL_LOGGING=TRUE;

Which two statements are true in this scenario?

THe default location for the archived redo log files is the FRA.

Which two files are removed automatically if space is required in the FRA as per the retention policy?

$$> expdp hr/hr DIRECTORY=dumpdir DUMPFILE=emp1.dmp VIEWS_AS_TABLE=emp_dept

On the target database, you execute the data pump import command：

$$> impdp hr/hr DIRECTORY=dumpdir DUMPFILE=emp1.dmp VIEWS_AS_TABLE=emp_dept 

Which three statement are true?

$$> expdp hr/hr DIRECTORY=dumpdir DUMPFILE=emp1.dmp VIEWS_AS_TABLE=emp_dept

On the target database, you run this command：

$$> impdp hr/hr DIRECTORY=dumpdir DUMPFILE=emp1.dmp VIEWS_AS_TABLE=emp_dept 

Which two statements are true?