Oracle Oracle Certifications 1Z0-063 Questions & Answers

• Question 111:

  Examine the following set of RMAN commands:

  

  Which statement is true about the RMAN run block execution?

  A. The script is executed and both DC1 and CH1 channels are used for script execution.

  B. The execution of the script fails because multiple channels cannot exist simultaneously.

  C. The persistent configuration parameter, DC1, is overridden because a new channel is allocated in the RMAN RUN block.

  D. The new channel, CH1, is ignored because a channel has been configured already.

  Correct Answer: C

• Question 112:

  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.

  Correct Answer: AD

• Question 113:

  Your database supports an OLTP workload. Examine the output of the query: To ensure faster instance recovery, you set the FAST_START_MTTR_TARGET initialization parameter to

  

  30.

  What is the effect of this setting on the database?

  A. Automatic checkpoint tuning is disabled.

  B. The frequency of log switches is increased.

  C. The overhead on database performance is increased because of frequent writes to disk.

  D. The MTTR advisor is disabled.

  Correct Answer: C

• Question 114:

  Which three statements are true about persistent lightweight jobs? (Choose three.)

  A. A user cannot set privileges on them.

  B. They generate large amounts of metadata.

  C. They may be created as fully self-contained jobs.

  D. They must reference an existing Scheduler Program.

  E. They are useful when users need to create a large number of jobs quickly.

  Correct Answer: ADE

• Question 115:

  You restore and recover your database to a new host by using an existing RMAN open database backup.

  Which step must you perform next?

  A. Execute catproc.sql to recompile invalid PL/SQL modules.

  B. Open the database with the RESETLOGS option.

  C. Set a new database identifier (DBID) for the newly restored database.

  D. Use the RMAN SET NEWNAME and SWITCH commands to switch to new files.

  Correct Answer: B

• Question 116:

  Which two statements are true about unified auditing? (Choose two.)

  A. A unified audit trail captures audit information from unified audit policies and audit settings.

  B. Unified auditing is enabled by executing make 璮 ins_rdbms.mk uniaud_on ioracle ORACLE_HOME=$ORACLE_HOME.

  C. Audit records are created for all users except sys.

  D. Audit records are created only for the DML and DDL operations performed on database objects.

  E.

  Unified auditing is enabled by setting the audit_trail parameter to db, extended.

  F.

  A unified audit trail resides in a read-only table in the audsys schema in the system tablespace.

  Correct Answer: AB

• Question 117:

  You plan to use the In-Database Archiving feature of Oracle Database 12c, and store rows that are inactive for over three months, in Hybrid Columnar Compressed (HCC) format.

  Which three storage options support the use of HCC? (Choose three.)

  A. ASM disk groups with ASM disks consisting of Exadata Grid Disks.

  B. ASM disk groups with ASM disks consisting of LUNS on any Storage Area Network array

  C. ASM disk groups with ASM disks consisting of any zero padded NFS-mounted files

  D. Database files stored in ZFS and accessed using conventional NFS mounts.

  E. Database files stored in ZFS and accessed using the Oracle Direct NFS feature

  F. Database files stored in any file system and accessed using the Oracle Direct NFS feature

  G. ASM disk groups with ASM disks consisting of LUNs on Pillar Axiom Storage arrays

  Correct Answer: AEG

  HCC requires the use of Oracle Storage ?Exadata (A), Pillar Axiom (G) or Sun ZFS Storage Appliance

  (ZFSSA).

  Note:

  *

  Hybrid Columnar Compression, initially only available on Exadata, has been extended to support Pillar Axiom and Sun ZFS Storage Appliance (ZFSSA) storage when used with Oracle Database Enterprise Edition 11.2.0.3 and above

  *

  Oracle offers the ability to manage NFS using a feature called Oracle Direct NFS (dNFS). Oracle Direct NFS implements NFS V3 protocol within the Oracle database kernel itself. Oracle Direct NFS client overcomes many of the challenges associated with using NFS with the Oracle Database with simple configuration, better performance than traditional NFS clients, and offers consistent configuration across platforms.

• Question 118:

  Which two statements are true about service creation for pluggable databases (PDBs)? (Choose two.)

  A. When a PDB is created, a service is automatically started in the instance with the same name as the PDB.

  B. The default service that is automatically created by a database at the time of PDB creation can be dropped, provided a new additional service is created.

  C. A database managed by Oracle Restart can have additional services created or existing services modified by using the srvctl utility for each PDB.

  D. Only a common user can create additional services for a PDB.

  E. When a PDB is created, a service with the same name as the PDB is created in the PDB.

  Correct Answer: AC

• Question 119:

  You want to move your existing recovery catalog to another database.

  Examine the steps:

  1) Export the catalog data by using the Data Pump Export utility in the source database.

  2) Create a recovery catalog user and grant the necessary privileges in the target database.

  3) Create a recovery catalog by using the CREATE CATALOG command.

  4) Import the catalog data into the new recovery catalog by using the Data Pump Import utility in the target

  database.

  5) Import the source recovery catalog schema by using the RMAN IMPORT CATALOG command.

  6) Connect to the destination database.

  7) Connect as CATALOG to the destination recovery catalog schema.

  Identify the option with the correct sequence for moving the recovery catalog.

  A. 1, 6, 4

  B. 2, 3, 7, 5

  C. 1, 2, 6, 4

  D. 1, 2, 3, 6, 5

  Correct Answer: C

• Question 120:

  Examine the command and its output:

  SQL> DROP TABLE EMPLOYEE; SQL> SELECT object_name AS recycle_name, original_name, type FROM recyclebin; RECYCLE_NAMEORIGINAL_NAMETYPE binsgk31sj/3akk5hg3j21kl5j3d==$0EMPLOYEE TABLE

  You then successfully execute the command:

  SQL> FLASHBACK TABLE "BINSgk31sj/3akk5hg3j21kl5j3d==$0" TO BEFORE DROP;

  Which two statements are true? (Choose two.)

  A. It flashes back the employee table and all the constraints associated with the table.

  B. It automatically flashes back all the indexes on the employees table.

  C. It automatically flashes back any triggers defined on the table.

  D. It flashes back only the structure of the table and not the data.

  E. It flashes back the data from the recycle bin and the existing data in the original table is permanently lost.

  Correct Answer: AC