Oracle Oracle Certifications 1Z0-063 Questions & Answers

• Question 131:

  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.

  Correct Answer: AD

• Question 132:

  user_data is a non-encrypted tablespace containing tables with data.

  You must encrypt all data in this tablespace.

  Which three methods can do this? (Choose three.)

  A. Use Data Pump.

  B. Use ALTERTABLE. . .MOVE

  C. Use CREATE TABLE AS SELECT

  D. Use alter tablespace to encrypt the tablespace after enabling row movement on all its disk space

  E. Use altertablespace to encrypt the tablespace.

  Correct Answer: ABC

• Question 133:

  Which two statements are true about a common user? (Choose two.)

  A. A common user connected to a pluggable database (PDB) can exercise privileges across other PDBs.

  B. A common user with the create user privilege can create other common users, as well as local users.

  C. A common user can be granted only a common role.

  D. A common user can have a local schema in a PDB.

  E. A common user always uses the global temporary tablespace that is defined at the CDB level as the default temporary tablespace.

  Correct Answer: BD

• Question 134:

  Which three statements are true about the keystore storage framework for transparent data encryption? (Choose three.)

  A. It facilitates and helps to enforce keystore backup requirements.

  B. It handles encrypted data without modifying applications.

  C. It enables a keystore to be stored only in a file on a file system.

  D. It enables separation of duties between the database administrator and the security administrator.

  E. It transparently decrypts data for the database users and applications that access this data.

  F. It helps to track encryption keys and implement requirements such as keystore password rotation and master encryption key reset or re-key operations.

  Correct Answer: ADF

  Reference:

  http://oradb-srv.wlv.ac.uk/E16655_01/network.121/e17729/asotrans.htm#CHDEABCA (benefits of the

  keystore storage framework)

• Question 135:

  You want to reduce fragmentation and reclaim unused space for the sales table but not its dependent objects. During this operation, you want to ensure the following:

  A. Long-running queries are not affected.

  ii. No extra space is used.

  iii. Data manipulation language (DML) operations on the table succeed at all times throughout the process.

  iv. Unused space is reclaimed both above and below the high water mark.

  Which alter TABLE option would you recommend?

  B. DEALLOCATE UNUSED

  C. SHRINK SPACE CASCADE

  D. SHRINK SPACE COMPACT

  E. ROW STORE COMPRESS BASIC

  Correct Answer: C

• Question 136:

  You have a production Oracle 12c database running on a host.

  You want to install and create databases across multiple new machines that do not have any Oracle database software installed. You also want the new databases to have the same directory structure and components as your existing 12c database.

  The steps in random order:

  1.

  Create directory structures similar to the production database on all new machines.

  2.

  Create a response file for Oracle Universal Installer (OUI) with the same configurations as the production database.

  3.

  Create a database clone template for the database.

  4.

  Run the Database Configuration Assistant (DBCA) to create the database.

  5.

  Run OUI in graphical mode on each machine.

  6.

  Run OUI in silent mode using the OUI response file.

  Identify the required steps in the correct sequence to achieve the requirement with minimal human intervention.

  A. 2, 1, 6, and 4

  B. 2, 3, and 6

  C. 3, 1, 5, and 6

  D. 2, 3, 1, and 6

  E. 1, 5, and 4

  Correct Answer: D

• Question 137:

  For which two requirements would you use the Database Resource Manager? (Choose two.)

  A. limiting the CPU used per database call

  B. specifying the maximum number of concurrent sessions allowed for a user

  C. specifying the amount of private space a session can allocate in the shared pool of the SGA

  D. limiting the degree of parallelism of operations performed by a user or group of users

  E. specifying an idle time limit that applies to sessions that are idle and blocking other sessions

  Correct Answer: DE

• Question 138:

  Examine the command to back up the ASM metadata:

  ASMCMD> md_backup /backup/ASM_backup

  In which three situations can you use the backup? (Choose three.)

  A. when one or more disks in an ASM disk group are lost

  B. when the data file on an ASM disk group gets corrupted

  C. when one of the disks in a disk group is accidentally unplugged

  D. when one or more file directory paths are accidentally deleted from an ASM disk group

  E. when all the ASM disk groups for the ASM instance are lost

  Correct Answer: ADE

• Question 139:

  You are administering a database that supports data warehousing workload and is running in noarchivelog mode. You use RMAN to perform a level 0 backup on Sundays and level 1 Incremental backups on all the other days of the week.

  One of the data files is corrupted and the current online redo log file is lost because of a media failure.

  You want to recover the data file.

  Examine the steps involved in the recovery process:

  1.

  Shut down the database instance.

  2.

  Start up the database instance in nomount state.

  3.

  Mount the database.

  4.

  Take the data file offline.

  5.

  Put the data file online.

  6.

  Restore the control file.

  7.

  Restore the database.

  8.

  Restore the data file.

  9.

  Open the database with the RESETLOGS option.

  10.

  Recover the database with the NOREDO option.

  11.

  Recover the data file with the NOREDO option.

  Identify the required steps in the correct order.

  A. 4, 8, 11, 5

  B. 1, 3, 8, 11, 9

  C. 1, 2, 6, 3, 7, 10, 9

  D. 1, 3, 7, 10, 9

  E. 1, 2, 6, 3, 8, 11, 9

  Correct Answer: C

• Question 140:

  Examine the commands:

  SQL> ALTER SESSION SET RECYCLEBIN = ON;

  Session altered.

  SQL> DROP TABLE emp; --(First EMP table)

  Table dropped.

  SQL> CREATE TABLE emp(id NUMBER CONSTRAINT emp_id_idx PRIMARY KEY, name VARCHAR2

  (15), salary NUMBER(7,2));

  Table created.

  You then execute multiple INSERT statements to insert rows into the EMP table and drop the table again:

  SQL> DROP TABLE emp; -- (Second EMP table)

  Table dropped.

  SQL> FLASHBACK TABLE emp TO BEFORE DROP;

  Which statement is true about the FLASHBACK command?

  A. It recovers the structure, data, and indexes of the first EMP table.

  B. It recovers only the structure of the second EMP table.

  C. It returns an error because two tables with the same name exist in the recycle bin.

  D. It recovers the structure, data, and indexes of the second EMP table.

  Correct Answer: D