Oracle 1Z0-063 Online Practice Questions and Exam Preparation

Oracle 1Z0-063 Online Questions & Answers

• Question 201:

  Which two are true about RMAN image copies? (Choose two.)

  A. The can only be written to disk.
  B. They are the only backup option available for database in NOARCHIVELOG mode.
  C. They can be encrypted using Transparent Data Encryption (TDE).
  D. They can be used as a level 0 incremental backup.
  A. The can only be written to disk.
  D. They can be used as a level 0 incremental backup.

• Question 202:

  Which two statements are true about the Automatic Diagnostic Repository (ADR)? (Choose two.)

  A. The ADR base is shared across multiple instances.
  B. The ADR base keeps all diagnostic information in binary format.
  C. The ADR can be used to store statspack snapshots to diagnose database performance issues.
  D. The ADR can be used for problem diagnosis even when the database instance is down.
  E. The ADR is used to store Automatic Workload Repository (AWR) snapshots.
  A. The ADR base is shared across multiple instances.
  D. The ADR can be used for problem diagnosis even when the database instance is down.

• Question 203:

  Your Oracle 12c multitenant container database (CDB) contains multiple pluggable databases (PDBs). In the PDB HR_PDB, the common user C##ADMIN and the 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:

  

  Which two statements are true? (Choose two.)

  A. C##ADMIN can create and select any table, and grant the C##ROLE1 role to users only in the root container.
  B. B_ADMIN can create and select any table in both the root container and HR_PDB.
  C. C##ADMIN can create and select any table in the root container and all the PDBs.
  D. B_ADMIN can create and select any table only in HR_PDB.
  E. The GRANT c##role1 TO b_admin command returns an error because CONTAINER should be set to ALL.
  C. C##ADMIN can create and select any table in the root container and all the PDBs.
  D. B_ADMIN can create and select any table only in HR_PDB.

• Question 204:

  You must unload data from the orders, order_items, and products database tables to four files using the External Tables.

  CREATE TABLE orders_ext (order_id, order_date, product_id, product_name,quantity) ORGANIZATION EXTERNAL ( TYPE ORACLE_DATAPUMP DEFAULT DIRECTORY ext.dir LOCATION (`ordersl.dmp','orders2.dmp','orders3.dmp','lorders4.dmp') ) PARALLEL AS SELECT o.order_id,o.order_date,p.product_id,p.product_name,i.quantity FROM orders o,productsp,order_items WHERE o.orderid = i.order_id and i.product_id = p.product_id;

  You execute the command shown in the Exhibit, but only two files are created. Which parameter must be changed so that four files are created?

  A. TYPE
  B. LOCATION
  C. PARALLEL
  D. DEFAULT DIRECTORY
  E. ORGANIZATION EXTERNAL
  C. PARALLEL

• Question 205:

  Examine the RMAN command:

  RMAN> SET ENCRYPTION IDENTIFIED BY ON FOR ALL TABLESPACES; RMAN> BACKUP DATABASE PLUS ARCHIVELOG;

  Which type of encryption is used for the backup performed by using this command?

  A. password-mode encryption
  B. dual-mode encryption
  C. transparent encryption
  D. default encryption
  A. password-mode encryption

• Question 206:

  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.
  A. They can only be written to disk.
  D. They consist of all used and unused blocks in the data files.

• Question 207:

  You plan to duplicate the multitenant container database (CDB) cdb1 that contains the pluggable database (PDB) SALES:

  

  Which two statements are true? (Choose two.)

  A. The root and seed databases are included in the duplication.
  B. Only the SALES PDB is duplicated as the non-CDB CDBDUP.
  C. A backup of the SALES PDB must exist before the execution of the command.
  D. An auxiliary instance must have been started with the initialization parameter ENABLE_PLUGGABLE_DATABASE set to TRUE.
  E. RMAN must be connected to a recovery catalog for the execution of the command.
  A. The root and seed databases are included in the duplication.
  D. An auxiliary instance must have been started with the initialization parameter ENABLE_PLUGGABLE_DATABASE set to TRUE.

• Question 208:

  You set the following parameters in the parameter file and restart the database instance:

  NEMORY_MAX_TARGET=0 MEMORY__TARGET=500M PGA_AGGREGATE_TARGET=90M SGA_TARGET=270M

  Which two statements are true? (Choose two.)

  A. The memory_max_target parameter is automatically set to 500 MB.
  B. The pga_aggregate_target and sga_target parameters are automatically set to zero.
  C. The value of the memory_max_target parameter remains zero for the database instance.
  D. The lower limits of the pga_aggregate_target and sga_target parameters are set to 90 MB and 270 MB respectively.
  E. The instance does not start up because Automatic Memory Management (AMM) is enabled but pga_aggregate_target and sga_target parameters are set to nonzero values.
  A. The memory_max_target parameter is automatically set to 500 MB.
  D. The lower limits of the pga_aggregate_target and sga_target parameters are set to 90 MB and 270 MB respectively.

• Question 209:

  Which three types of failures are detected by the Data Recovery Advisor (DRA)? (Choose three.)

  A. loss of a non-critical data file
  B. loss of a control file
  C. physical data block corruption
  D. logical data block corruption
  E. loss of an archived redo log
  B. loss of a control file
  C. physical data block corruption
  E. loss of an archived redo log

• Question 210:

  Examine the command to duplicate a database:

  RMAN> DUPLICATE TARGET DATABASE TO cdb

  PLUGGABLE DATABASE pdb1, pdb5;

  Which two statements are true about the DUPLICATE command? (Choose two.)

  A. The SPFILE is copied along with the data files of the pluggable databases (PDBs).
  B. A backup of pdb1 and pdb5 must exist before executing the command.
  C. The DUPLICATE command first creates a backup, and then duplicates the PDBs by using the backup.
  D. The root and the seed database in the container database (CDB) are also duplicated.
  E. An auxiliary instance must be started with the initialization parameter ENABLE_PLUGGABLE_DATABASE set to TRUE.
  B. A backup of pdb1 and pdb5 must exist before executing the command.
  E. An auxiliary instance must be started with the initialization parameter ENABLE_PLUGGABLE_DATABASE set to TRUE.