1z0-063 Exam Question 181
Examine this command:
SQL> CREATE DATABASE cdb1
DEFAULT TABLESPACE users
DEFAULT TEMPORARY TABLESPACE temp
UNDO TABLESPACE undotbs1
ENABLE PLUGGABLE DATABASE
SEED
SYSTEM DATAFILES SIZE 125M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED
SYSAUX DATAFILES SIZE 100M;
Which two requirements must be met to ensure that CDB1 is created? (Choose two.)
SQL> CREATE DATABASE cdb1
DEFAULT TABLESPACE users
DEFAULT TEMPORARY TABLESPACE temp
UNDO TABLESPACE undotbs1
ENABLE PLUGGABLE DATABASE
SEED
SYSTEM DATAFILES SIZE 125M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED
SYSAUX DATAFILES SIZE 100M;
Which two requirements must be met to ensure that CDB1 is created? (Choose two.)
1z0-063 Exam Question 182
Your database instance is started using an SPFILE. You are connected to CDB$ROOT, as a DBA.
You issue:
SQL> ALTER SYSTEM SET STATISTICS_LEVEL=ALL SCOPE=BOTH;
Which two statements are true about the STATISTICS_LEVEL parameter? (Choose two.)
You issue:
SQL> ALTER SYSTEM SET STATISTICS_LEVEL=ALL SCOPE=BOTH;
Which two statements are true about the STATISTICS_LEVEL parameter? (Choose two.)
1z0-063 Exam Question 183
Your database has a table CUSTOMERSthat contains the columns CUST_NAME, AMT_DUE, and OLD_STATUS.
Examine the commands executed and their output:
Why is it that only one update is listed by the Flashback Version Query?
Examine the commands executed and their output:
Why is it that only one update is listed by the Flashback Version Query?
1z0-063 Exam Question 184
You create a table with the period for clause to enable the use of the Temporal Validity feature of Oracle
Database 12c.
Examine the table definition:
create table employees
( empno number, salary number,
deptid number, name varchar2(100),
period for employee_time);
Which three statements are true concerning the use of the Valid Time Temporal feature for the
EMPLOYEES table? (Choose three.)
Database 12c.
Examine the table definition:
create table employees
( empno number, salary number,
deptid number, name varchar2(100),
period for employee_time);
Which three statements are true concerning the use of the Valid Time Temporal feature for the
EMPLOYEES table? (Choose three.)
1z0-063 Exam Question 185
Which three conditions must be true for unused block compression to be used automatically while performing backups by using RMAN? (Choose three.)