Oracle Oracle Certifications 1Z0-063 Questions & Answers

• Question 171:

  Your Oracle 12c multitenant container database (CDB) contains multiple pluggable databases (PDBs).

  In PDB HR_PDB, common user C##ADMIN and local user B_ADMIN have only the CONNECT privilege.

  You create a common role C##ROLE1 with the CREATE ANY TABLE and SELECT ANY TABLE

  privileges.

  You then execute the commands:

  SQL> GRANT c##role1 TO c##admin CONTAINER=ALL>;

  SQL> CONN sys/oracle@HR_PDB as sysdba

  SQL> GRANT c##role1 TO b_admin CONTAINER=CURRENT;

  Which three statements are true? (Choose three.)

  A. C##ADMIN can create and select any table in HR_PDB.

  B. B_ADMIN can create and select any table only in HR_PDB.

  C. A local role can be granted to c##role1 in a PDB

  D. C##ADMIN can create and select any table, and grant the C##ROLE1 role to users only in the root container.

  E. Role c##role1 will always have the same privileges in each PDB.

  F. B_ADMIN can create and select any table in both the root container and HR_PDB.

  Correct Answer: ACE

• Question 172:

  In which two locations does the USER_DATA TABLESPACE clause create a tablespace? (Choose two.)

  A. a PDB

  B. CDB$ROOT

  C. PDB$SEED

  D. a non-CDB

  E. an Application Root

  Correct Answer: AD

• Question 173:

  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.)

  A. The ENABLE_PLUGGABLE_DATABASE parameter must be set to TRUE.

  B. The PDB_FILE_NAME_CONVERT parameter must be configured.

  C. The FILE_NAME_CONVERT clause must be added to the command.

  D. The USER_DATA TABLESPACE clause must be added to the command.

  E. The DB_CREATE_FILE_DEST parameter must be configured.

  Correct Answer: AC

• Question 174:

  Which two parameters must be set to configure the fast recovery area? (Choose two.)

  A. DB_CREATE_FILE_DEST

  B. DB_RECOVERY_FILE_DEST

  C. DB_RECOVERY_FILE_DEST_SIZE

  D. LOG_ARCHIVE_DEST

  E. at least two locations using DB_CREATE _ONLINE_LOG_DEST_n

  F. DB_FLASHBACK_RETENTION_TARGET

  Correct Answer: BC

  Reference: https://docs.oracle.com/database/121/ADMQS/GUID-D6A541BF-A878-4B45-AFAC1E921554731E.htm

• Question 175:

  Which two are benefits of unified auditing in full mode? (Choose two.)

  A. The audit trail is in a single format.

  B. All audit data is written to both the traditional locations and to the unified location.

  C. The audit trail is read-only.

  D. Pre 12c audit data is written to the traditional locations and new 12c audit data is written to the unified location.

  E. The audit trail uses less space.

  Correct Answer: AC

• Question 176:

  Examine this parameter in a database's PFILE:

  DB_CREATE_FILE_DEST = '/u01/app/oracle/oradata/'

  You execute this command: Which three are true after successful database creation? (Choose three.)

  

  A. Local Undo is enabled.

  B. The files created for both the root and seed databases use Oracle Managed Files (OMF).

  C. PDB$SEED is open read-only.

  D. PDB$SEED is mounted.

  E. USERS will be the default tablespace for PDB$SEED.

  F. CDB$ROOT is open read/write.

  Correct Answer: ABD

• Question 177:

  Examine this query:

  SELECT cust_name, amt_due

  FROM customers

  AS OF TIMESTAMP (SYSTIMESTAMP - INTERVAL '6' MINUTE)

  WHERE cust_no = 'AYR2011';

  Which two requirements guarantee that the query will execute successfully? (Choose two.)

  A. Row movement must be enabled for CUSTOMERS.

  B. Automatic Undo Management must be configured.

  C. FLASHBACK must be ON for the database.

  D. Undo retention guarantee must be enabled.

  E. The database must be in ARCHIVELOG mode.

  F. Supplemental logging must be enabled.

  Correct Answer: BC

  Reference https://docs.oracle.com/cd/B12037_01/appdev.101/b10795/adfns_fl.htm

• Question 178:

  Examine this command:

  

  Which two statements are true after successful execution? (Choose two.)

  A. PDB2 will be open read-only.

  B. PDB2 will be in MOUNT state.

  C. A metadata description of PDB2 is stored in an XML file in `/disk2/oracle/pdb2/'.

  D. A metadata description of PDB2 is stored in the system tablespace of PDB1.

  E. PDB2 will use shared UNDO.

  Correct Answer: BD

• Question 179:

  You execute the RMAN commands:

  RMAN> CONFIGURE DEFAULT DEVICE TYPE TO disk;

  RMAN> CONFIGURE DEVICE TYPE disk PARALLELISM 2;

  RMAN> CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT `/disk1/%U';

  RMAN> CONFIGURE CHANNEL 2 DEVICE TYPE DISK FORMAT `/disk2/%U';

  RMAN> BACKUP DATABASE;

  Which statement is true about the backup set created by the BACKUP command?

  A. The default channel is allocated and the backup set is created in only one destination.

  B. Two channels are allocated and a copy of the backup set is taken in the location specified by CHANNEL 2.

  C. Two channels are allocated and backup pieces for the backup set are created in both the specified destinations.

  D. Two channels are allocated and two copies of the backup set are taken in parallel in both locations.

  Correct Answer: C

• Question 180:

  Examine the RMAN commands:

  RMAN> CONNECT TARGET "sbu@prod AS SYSBACKUP"; RMAN> CONNECT AUXILIARY "sbu@dup_db AS SYSBACKUP";

  RMAN> DUPLICATE TARGET DATABASE TO dup_db FROM ACTIVE DATABASE PASSWORD FILE SECTION SIZE 400M;

  Which statement is true about the DUPLICATE command?

  A. It fails because there is no connection to a recovery catalog.

  B. It succeeds only if the target database is in MOUNT state.

  C. It succeeds and creates multisection backup sets that are used for active database duplication.

  D. It fails because no parallel channels are allocated for the auxiliary database.

  Correct Answer: C