Express (EM Express)?

SQL> CREATE USER user02  identified by us123 QUOTA 10M ON users; User created.

SQL> GRANT create session, sysdba To user02; Grant succeeded. You plan to execute the commands：

SQL> CONN user02/us123 AS SYSDBA

SQL> CREATE TABLE mytab (id number, 1name varchar2 (20) ); Which two statements are true?

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?

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?

To free space, you execute this command： 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?

SQL> ALTER SYSTEM SET ENABLE_DDL_LOGGING=TRUE; Which two statements are true?

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?