Oracle Oracle Certifications 1Z0-063 Questions & Answers

• Question 271:

  You issue the command:

  SQL> ALTER DATABASE BACKUP CONTROLFILE TO TRACE;

  Which statement is true about the command?

  A. It creates a copy of the control file and stores it in the location specified in the diagnostic_dest initialization parameter.

  B. It creates a file that contains the SQL statement, which is required to re-create the control file.

  C. It updates the alert log file with the location and contents of the control file.

  D. It creates a binary backup of the control file.

  Correct Answer: B

• Question 272:

  You create a default Flashback Data Archive FLA1 and enable it for the EMPLOYEES table in the HR

  schema.

  After a few days, you want to alter the EMPLOYEES table by executing the command:

  SQL> ALTER TABLE EMPLOYEES ADD PHONE NUMBER(12);

  Which statement is true about the execution of the command?

  A. It gives an error because DDL statements cannot be executed on a table that is enabled for Flashback Data Archive.

  B. It executes successfully and all metadata related to the EMPLOYEES table before altering the table definition is purged from Flashback Data Archive.

  C. It executes successfully and continues to store metadata related to the EMPLOYEES table.

  D. It executes successfully but Flashback Data Archive is disabled for the EMPLOYEES table.

  Correct Answer: C

• Question 273:

  Examine the commands executed in CDB$ROOT of your multitenant container database (CDB) that has multiple pluggable databases (PDB):

  

  Which statement is true about granting the select privilege on the DBA_users view to the c##ROLE1 role?

  A. The command fails and gives an error because object privileges cannot be granted to a common user.

  B. The command fails because container is not set to current.

  C. The command succeeds and the common user c##admin can create a session and query the DBA_users view in cdb$root and all the PDBs.

  D. The command succeeds and the common user c##admin can create a session in cdb$root and all the PDBs, but can only query the dba_users view in cdb$root.

  E. The command succeeds and the common user c##admin can create a session and query the DBA_users view only in cdb$root.

  Correct Answer: C

• Question 274:

  Identify three reasons for using a recovery catalog with Recovery Manager (RMAN). (Choose three.)

  A. to store backup information of multiple databases in one place

  B. to restrict the amount of space that is used by backups

  C. to maintain a backup for an indefinite period of time by using the KEEP FOREVER clause

  D. to store RMAN scripts that are available to any RMAN client that can connect to target databasesregistered in the recovery catalog

  E. to automatically delete obsolete backups after a specified period of time

  Correct Answer: ACD

• Question 275:

  Which two statements are true regarding Oracle Data Pump? (Choose two.)

  A. EXPDP and IMPDP are the client components of Oracle Data Pump.

  B. DBMS_DATAPUMP PL/SQL packages can be used independently of the Data Pump clients.

  C. Oracle Data Pump export and import operations can be performed only by users with the SYSDBA privilege.

  D. Oracle Data Pump imports can be done from the export files generated in the Original Export Utility.

  E. EXPDP and IMPDP use the procedures provided by DBMS_METADATA to execute export and import commands.

  Correct Answer: AB

  Reference: http://docs.oracle.com/cd/B19306_01/server.102/b14215/dp_overview.htm

• Question 276:

  Which two statements are true about making RMAN image copies of a database? (Choose two.)

  A. They can only be written to disk.

  B. They can be made only when the database is running in NOARCHIVELOG mode.

  C. They can be made only when the database is in MOUNT state.

  D. They consist of all used and unused blocks in the data files.

  E. They can be made only when the database is running in ARCHIVELOG mode.

  Correct Answer: AD

  An image copy can be written only to disk.

  An image copy is the same as datafiles. The disadvantage of image copy backup mode is that it occupies much space and does not skip unused data blocks. References: http://www.dba-oracle.com/t_rman_10_image_copies.htm