Oracle Oracle Certifications 1Z0-063 Questions & Answers

• Question 31:

  Examine the steps/operations performed during the RMAN backup operation by using Oracle Secure Backup (OSB):

  1.

  Start the RMAN client by using the RMAN target / command.

  2.

  Start the RMAN client by using the OSB user.

  3.

  RMAN creates the backup pieces.

  4.

  Run the RMAN backup command with the sbt channels.

  5.

  OSB creates a backup job and assigns a unique identifier.

  6.

  OSB creates a backup job request through the OSB sbt library.

  7.

  OSB stores metadata about RMAN backup pieces in the OSB catalog.

  8.

  OSB starts the backup operation.

  9.

  OSB updates the RMAN catalog.

  Identify the required steps/operations performed in correct order.

  A. 1, 4, 6, 5, 8, 3, 9

  B. 1, 6, 4, 5, 8, 3, 9

  C. 2, 4, 6, 5, 8, 3, 7

  D. 2, 4, 5, 8, 3, 7, 9

  Correct Answer: C

• Question 32:

  You want to back up a database such that only formatted blocks are backed up. Which statement is true about this backup operation?

  A. The backup must be performed in mount state.

  B. The tablespace must be taken offline.

  C. All files must be backed up as backup sets.

  D. The database must be backed up as an image copy.

  Correct Answer: C

• Question 33:

  You wish to enable an audit policy for all database users, except sys, system, and scott. You issue the following statements:

  SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYS; SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYSTEM; SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SCOTT;

  For which database users is the audit policy now active?

  A. all users except sys

  B. all users except scott

  C. all users except sys and scott

  D. all users except sys, system, and scott

  Correct Answer: B

• Question 34:

  A database is running in archivelog mode. You want to back up a 10 TB data file belonging to the users

  tablespace. The backup of the data file is too slow.

  What type of backup do you recommend to improve the performance of the backup?

  A. image copy backup by using RMAN

  B. multisection image copy backup by using RMAN

  C. multisection parallel backup by using RMAN

  D. cold backup after taking the tablespace offline

  E. cold backup after placing the tablespace in backup mode

  Correct Answer: C

• Question 35:

  Automatic Undo Management is enabled for your database. You want a user to retrieve metadata and historical data for a given transaction or for transactions in a given time interval.

  Which three are prerequisites to fulfill this requirement? (Choose three.)

  A. Minimal supplemental logging must be enabled.

  B. The database must be running in archivelog mode.

  C. Flashback Data Archive must be created and the flashback archive administer system privilege must be granted to the user.

  D. The flashback any table privilege must be granted to the user.

  E. The select any transaction privilege must be granted to the user.

  F. The recycle bin parameter must be set to on.

  Correct Answer: ABE

• Question 36:

  Examine these Data Pump commands to export and import objects from and to the same database.

  The dba has not yet created users hr1 and oe1.

  $expdp system/manager schemas = hr.oe directory = EXP_DIR dumpfile = export.dat include = table $ impdpsysten/manager schemas = hr1,oe1 directory = EXP_DIR dumpfile = export.dat remap_schena=hr:hrl, oe:oe1

  What will happen when running these commands?

  A. expdp will fail because no path has been defined for the dumpfile.

  B. expdp will succeed but impdp will fail because the users do not exist.

  C. inpdp will create two users called hr1 and oe1 and import all objects to the new schemas.

  D. impdp will create two users called hr1 and oe1 and import only the tables owned by hr and oe schemas to ht1 and oe1 schemas, respectively.

  Correct Answer: B

• Question 37:

  Which two statements are true about a multitenant architecture? (Choose two.)

  A. Each pluggable database (PDB) has its own initialization parameter file.

  B. A PDB can have a private undo tablespace.

  C. Log switches occur only at the container database level.

  D. A PDB can have a private temporary tablespace.

  E. Each PDB has a private control file.

  Correct Answer: CD

• Question 38:

  Which three tasks can be automatically performed by the Automatic Data Optimization feature of Information Lifecycle Management (ILM)? (Choose three.)

  A. tracking the most recent read time for a table segment in a user tablespace

  B. tracking the most recent write time for a table segment in a user tablespace

  C. tracking insert time by row for table rows

  D. tracking the most recent write time for each block in a table segment

  E. tracking the most recent read time for a table segment in the sysaux tablespace

  F. tracking the most recent write time for a table segment in the sysaux tablespace

  Correct Answer: ABD

• Question 39:

  Which three RMAN persistent settings can be set for a database? (Choose three.)

  A. backup retention policy

  B. default backup device type

  C. default section size for backups

  D. default destinations for backups

  E. multiple backup device types for a single backup

  Correct Answer: ABD

  Reference: http://docs.oracle.com/cd/B19306_01/backup.102/b14192/setup004.htm#i1019739

• Question 40:

  Your production database is running in archivelog mode. You use RMAN with a recovery catalog to back up your database to media and the database is uniquely identified in the recovery catalog.

  You want to create a test database from the production database and allow the production database to remain open during the duplicate process. You restore the database backups to a new host with the same directory structure as the production database and want to use the recovery catalog for future backups after the database is successfully restored to the new host.

  How would you achieve this?

  A. by using the RMAN SWITCH command to set the new location for the data files

  B. by using the RMAN DUPLICATE command with NOFILENAMECHECK to recover the database to the new host

  C. by using the RMAN DUPLICATE command with DBID and SET NEWNAME FOR TABLESPACE to recover the database to the new host

  D. by creating a new database in the new host, and then using the RMAN RECOVER command

  Correct Answer: B