1z0-063 Exam Question 1
Examine the commands:
SQL> ALTER SESSION SET RECYCLEBIN = ON;
Session altered.
SQL> DROP TABLE emp; --(First EMP table)
Total dropped.
SQL> CREATE TABLE emp(id NUMBER CONSTRAINT emp_id_idx PRIMARY KEY, name VARCHAR2 (15), salary NUMBER(7,2)); Table created.
You then execute multiple INSERTstatements to insert rows into EMPtable and drop the table again:
SQL> DROP TABLE emp; -- (Second EMP table)
Table dropped.
SQL> FLASHBACK TABLE emp TO BEFORE DROP;
Which statement is true about the FLASHBACK command?
SQL> ALTER SESSION SET RECYCLEBIN = ON;
Session altered.
SQL> DROP TABLE emp; --(First EMP table)
Total dropped.
SQL> CREATE TABLE emp(id NUMBER CONSTRAINT emp_id_idx PRIMARY KEY, name VARCHAR2 (15), salary NUMBER(7,2)); Table created.
You then execute multiple INSERTstatements to insert rows into EMPtable and drop the table again:
SQL> DROP TABLE emp; -- (Second EMP table)
Table dropped.
SQL> FLASHBACK TABLE emp TO BEFORE DROP;
Which statement is true about the FLASHBACK command?
1z0-063 Exam Question 2
Your database is running in archivelog modeand Automatic Undo Management is enabled. Which two tasks should you perform before enabling Flashback Database?
1z0-063 Exam Question 3
You want to create a duplicate database DUP_DB from your production database PRODon the same host. The PRODdatabase uses Automatic Storage Management (ASM) for storage. Regular backups are taken using RMAN connected to a recovery catalog.
You create an auxiliary instance and want to execute the command:
What is a prerequisite for the successful execution of this command?
You create an auxiliary instance and want to execute the command:
What is a prerequisite for the successful execution of this command?
1z0-063 Exam Question 4
Your multitenant container database (CDB) CDB1 has two pluggable databases, PDB1 and PDB2. The local net service name CDB1 connects to the root database, and the service names PDB1 and PDB2 connect to the pluggable databases (PDBs), PDB1 and PDB2, respectively.
Examine the commands to change the value of the PDB modifiable initialization parameter:
$> sqlplus sys/oracle_4U@pdb1 AS SYSDBA
SQL> ALTER SYSTEM SET optimizer_use_sql_plan_baselines=FALSE SCOPE=BOTH; SQL>CONN sys/oracle_4U@pdb2 AS SYSDBA
SQL>ALTER SYSTEM SET optimizer_use_sql_plan_baselines= TRUE SCOPE = BOTH; SQL> CONN sys/oracle _4U@cdbl AS SYSDBA
SQL.>ALTER SYSTEM SET optimizer_use_sql_plan_baseline=TRUE SCOPE=BOTH;
Which statement is true about the OPTIMIZER_USE_SQL_PLAN_BASELINES parameter?
Examine the commands to change the value of the PDB modifiable initialization parameter:
$> sqlplus sys/oracle_4U@pdb1 AS SYSDBA
SQL> ALTER SYSTEM SET optimizer_use_sql_plan_baselines=FALSE SCOPE=BOTH; SQL>CONN sys/oracle_4U@pdb2 AS SYSDBA
SQL>ALTER SYSTEM SET optimizer_use_sql_plan_baselines= TRUE SCOPE = BOTH; SQL> CONN sys/oracle _4U@cdbl AS SYSDBA
SQL.>ALTER SYSTEM SET optimizer_use_sql_plan_baseline=TRUE SCOPE=BOTH;
Which statement is true about the OPTIMIZER_USE_SQL_PLAN_BASELINES parameter?
1z0-063 Exam Question 5
Which two statements are true about tablespaces in multitenant container databases (CDBs)? (Choose
two.)
two.)