Oracle Oracle Certifications 1Z0-063 Questions & Answers

• Question 211:

  One of your container databases (CDBs) has five pluggable databases (PDBs).

  COMMON_USER_PREFIX is C##.

  These commands executed successfully while connected as SYS to CDB$ROOT:

  SQL> CREATE USER c##dba_admin IDENTIFIED BY orcl123;

  SQL> CREATE ROLE c##role1 CONTAINER=ALL;

  SQL> GRANT CREATE VIEW TO c##role1 CONTAINER=ALL;

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

  SQL> GRANT c##role1 to system CONTAINER=ALL;

  Which three are true? (Choose three.)

  A. The C##DBA_ADMIN user is able to create views in any PDB as a result of being granted the C##ROLE1 role.

  B. The C##DBA_ADMIN user is a local user in CDB$ROOT and PDB$SEED.

  C. The c##role1 role will always have the same privileges in all current and future PDBs.

  D. The C##DBA_ADMIN user is a local user in CDB$ROOT.

  E. SYSTEM is able to create views in any PDB as a result of being a DBA user.

  F. SYSTEM is able to create views in any PDB as a result of being granted the C##ROLE1 role.

  Correct Answer: ACF

• Question 212:

  Which three statements are true about Flashback Data Archive? (Choose three.)

  A. Flashback Data Archive prevents flashback queries from getting a snapshot-too-old error.

  B. A table enabled for Flashback Data Archive cannot be dropped unless Flashback Data Archive is disabled or disassociated first.

  C. To enable Flashback Data Archive for a table, it is mandatory to have a default Flashback Data Archive for a database.

  D. While enabling Flashback Data Archive for a table, if no name is provided for Flashback Data Archive, it is enabled using the default Flashback Data Archive.

  E. To use Flashback Data Archive, users must have unlimited quota on the Flashback Data Archive tablespace.

  Correct Answer: BCD

• Question 213:

  Which three types of backups can be performed for a database running in NOARCHIVELOG mode? (Choose three.)

  A. consistent whole database backup

  B. backup of noncritical tablespaces without shutting down the instance

  C. backup of the database without shutting down the instance

  D. backup of only those blocks that have changed since the last backup while database is mounted

  E. backup of only the used blocks in a critical tablespace (SYSTEM or SYSAUX) while the database is open

  Correct Answer: ACD

  Reference https://docs.oracle.com/cd/B28359_01/server.111/b28310/archredo002.htm#ADMIN11330

• Question 214:

  Which activity is audited by default and recorded in the operating system audit trail irrespective of whether or not database auditing is enabled?

  A. configuration of unified auditing mode

  B. execution of SQL statements by users connected with the SYSDBA privilege

  C. usage of the AUDIT statement

  D. creation of a fine grained audit policy

  Correct Answer: C

• Question 215:

  You want to create a database with a block size other than the default 8 KB by using the Database Configuration Assistant (DBCA).

  Which option should you use?

  A. A custom database template

  B. A Data Warehouse database template

  C. Automatic Storage Management (ASM) for storage of data files

  D. A file system for storage of data files

  Correct Answer: A

• Question 216:

  What is the benefit of running the catctl.pl script during an upgrade of a pre-12c database to an Oracle 12c database?

  A. It generates a log file containing the fixes that can be made to the source database.

  B. It recompiles all invalid PLSQL and Java code.

  C. It provides parallel upgrade options to finish the upgrade process with a reduced down time.

  D. It provides a summary of the upgrade results.

  E. It generates fixup scripts to be run on the source database before upgrade.

  Correct Answer: C

• Question 217:

  The HR user updates the salary of one of the employees in the EMPLOYEES table, but does not commit the transaction.

  Which type of lock would this scenario lead to?

  A. Exclusive table-level lock on the EMPLOYEES table

  B. Row-exclusive lock on the row being updated

  C. Null lock on the EMPLOYEES table

  D. Null lock on the row being updated

  Correct Answer: B

• Question 218:

  You take your database backups by using the RMAN media management interface (MMI). Which two are true about the use of the RMAN MMI? (Choose two.)

  A. You can use it to create image copies for entire file systems.

  B. You can use it to create image copies for database files.

  C. You can use it to create backup sets for database files.

  D. You can use it to create proxy copies for database files.

  E. You can use it to create proxy copies for entire file systems.

  Correct Answer: BC

  Reference: https://docs.oracle.com/database/121/ADMQS/GUID-0A8FC1FE-0994-49A7-9F222E3F5FAEAF68.htm#ADMQS0926

• Question 219:

  In an Oracle 12c database, you attempt to load data into the HR.EMPLOYEES table in a pluggable

  database (PDB):

  $> sqlldr hr/hr@pdb table=employees

  Which three are true? (Choose three.)

  A. It creates the HR.EMPLOYEES table in the PDB and loads data into it if the table does not exist in the PDB to which HR connects.

  B. It succeeds if HR is a local user in the PDB to which HR connects.

  C. It loads data into HR.EMPLOYEES if the table exists in the PDB to which HR connects.

  D. It succeeds if HR is a common user.

  E. It loads data into HR.EMPLOYEES if the table exists in CDB$ROOT.

  Correct Answer: ABC

• Question 220:

  Which two are prerequisites for performing Flashback Transaction? (Choose two.)

  A. A supplemental log must be enabled for the primary key.

  B. Undo retention guarantee must be configured for the database.

  C. Fast Recovery Area must be enabled for the database.

  D. The EXECUTE privilege must be granted to a user on the DBMS_FLASHBACK package.

  E. Row movement must be enabled.

  Correct Answer: AD

  Reference https://docs.oracle.com/cd/E11882_01/appdev.112/e41502/adfns_flashback.htm#ADFNS01003