Oracle Oracle Certifications 1Z0-063 Questions & Answers

• Question 51:

  Your database is running in archivelog mode and a nightly backup of the database, along with an autobackup of the control file, is taken by using RMAN. Because of a media failure, the SPFILE and the control files are lost.

  Examine the steps to restore the SPFILE and the control file to mount the database:

  1.

  Set DBID of the target database in RMAN.

  2.

  Start the database instance by using the startup force nomount command in RMAN.

  3.

  Restore the control files from the backup.

  4.

  Mount the database.

  5.

  Restore the SPFILE from the autobackup.

  6.

  Create a PFILE from the recovered SPFILE.

  7.

  Restart the instance in nomount state.

  Identify the required steps in the correct order.

  A. 1, 2, 5, 3, 6, 4

  B. 1, 2, 3, 5, 6, 4

  C. 2, 1, 5, 7, 3, 4

  D. 2, 1, 5, 6, 7, 4, 3

  Correct Answer: C

• Question 52:

  You created a database with DBCA by using one of the Oracle supplied templates.

  Which is the default permanent tablespace for all users except DBSNMP and OUTLN?

  A. USERS

  B. SYSTEM

  C. SYSAUX

  D. EXAMPLE

  Correct Answer: B

• Question 53:

  Your database is running in archivelog mode. Examine the parameters for your database instance:

  LOG_ARCHIVE_DEST_l ='LOCATION=/disk1/arch MANDATORY' LOG_ARCHIVE_DEST_2 ='LOCATION=/disk2/arch' LOG_ARCHIVE_DEST_3 ='LOCATIO=/disk3/arch' LOG_ARCHIVE_DEST _4 ='LOCATIONs/disk4/arch' LOG_ARCHIVE _MIN_SUCCEED_DEST = 2

  While the database is open, you notice that the destination set by the log_archive_dest_1 parameter is not available. All redo log groups have been used.

  What happens at the next log switch?

  A. The database instance hangs and the redo log files are not overwritten.

  B. The archived redo log files are written to the fast recovery area until the mandatory destination is made available.

  C. The database instance is shutdown immediately.

  D. The destination set by the LOG_ARCHIVE_DEST_1 parameter is ignored and the archived redo log files are created in the next two available locations to guarantee archive log success.

  Correct Answer: D

• Question 54:

  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

  Correct Answer: A

  Reference:

  http://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmbckad.htm#CEGEJABH (to make password

  璭ncrypted backups)

• Question 55:

  The following parameters are set for your Oracle 12c database instance:

  OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES=FALSE OPTIMIZER_USE_SQL_PLAN_BASELINES=TRUE

  You want to manage the SQL plan evolution task manually. Examine the following steps:

  1. Set the evolve task parameters.

  2. Create the evolve task by using the DBMS_SPM.CREATE_EVOVLE_TASK function.

  3. Implement the recommendations in the task by using the DBMS_SPM.IMPLEMENT_EVOLVE_TASK function.

  4. Execute the evolve task by using the DBMS_SPM.EXECUTE_EVOLVE_TASK function.

  5. Report the task outcome by using the DBMS_SPM.REPORT_EVOLVE_TASK function.

  Identify the correct sequence of steps.

  A. 2, 4, 5

  B. 2, 1, 4, 3, 5

  C. 1, 2, 3, 4, 5

  D. 1, 2, 4, 5

  Correct Answer: B

• Question 56:

  Examine the steps to configure Oracle Secure Backup (OSB) for use with RMAN:

  1. Create media families for data files and archived redo log files.

  2. Configure database backup storage selectors or RMAN media management parameters.

  3. Create an OSB user preauthorized for RMAN operations.

  4. Configure RMAN Access to the OSB SBT.

  5. Disable Non-Uniform Memory Access (NUMA) awareness by setting the ob_ignore_numa parameter to

  0.

  Identify the steps in the correct order.

  A. 1, 4, 3, 2, 5

  B. 1, 3, 4, 5, 2

  C. 4, 3, 1, 2, 5

  D. 4, 3, 5, 1, 2

  Correct Answer: C

• Question 57:

  Examine the initialization parameter that is set in the PFILE:

  DB_CREATE_FILE_DEST ='/u01/app/oracle/oradata/'

  You execute the following command to create CDB1 container database (CDB):

  SQL>CREATE DATABASE CDB1 DEFAULT TABLESPACE users DEFAULT TEMPORARY TABLESPACE temp UNDO TABLESPACE Undotbsl ENABLE PLUGGABLE DATABASE SEED SYSTEM DATAFILES SIZE 125M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED SYSAUX DATAFILES SIZE 100M;

  Which three statements are true? (Choose three.)

  A. It creates a multitenant container database with a root and a seed pluggable database (PDB) that are opened in read-write and read-only modes, respectively.

  B. The files created for both the root and seed databases use Oracle Managed Files (OMF).

  C. It creates a multitenant container database with the root and seed databases opened and one PDB mounted.

  D. It sets the users tablespace as the default for both the root and seed databases.

  E. undotbs1 is used as the undo tablespace for both the root and seed databases.

  F. It creates a multitenant container database with the root database opened and the seed database mounted.

  Correct Answer: ABE

• Question 58:

  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

  Correct Answer: BCE

  Reference: http://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmrepai.htm#BRADV89728

• Question 59:

  You want to capture column group usage and gather extended statistics for better cardinality estimates for the customers table in the SH schema.

  Examine the following steps:

  1.

  Issue the SELECTDBMS_STATS. CREATE_EXTENDED_STATS (`SH', 'CUSTOMERS') from dual statement.

  2.

  Execute the dbms_stats.seed_col_usage (null, `SH', 500) procedure.

  3.

  Execute the required queries on the customers table.

  4.

  Issue the select dbms_stats.reportwcol_usage (`SH', 'customers') from dual statement.

  Identify the correct sequence of steps.

  A. 3, 2, 1, 4

  B. 2, 3, 4, 1

  C. 4, 1, 3, 2

  D. 3, 2, 4, 1

  Correct Answer: B

  Step 1 (2). Seed column usage Oracle must observe a representative workload, in order to determine the appropriate column groups. Using the new procedure DBMS_STATS.SEED_COL_USAGE, you tell Oracle how long it should observe the workload. Step 2: (3) You don't need to execute all of the queries in your work during this window. You can simply run explain plan for some of your longer running queries to ensure column group information is recorded for these queries. Step 3. (1) Create the column groups At this point you can get Oracle to automatically create the column groups for each of the tables based on the usage information captured during the monitoring window. You simply have to call the DBMS_STATS.CREATE_EXTENDED_STATS function for each table.This function requires just two arguments, the schema name and the table name. From then on, statistics will be maintained for each column group whenever statistics are gathered on the table. Note:

  *

  DBMS_STATS.REPORT_COL_USAGE reports column usage information and records all the SQL

  operations the database has processed for a given object.

  *

  The Oracle SQL optimizer has always been ignorant of the implied relationships between data columns

  within the same table. While the optimizer has traditionally analyzed the distribution of values within a

  column, he does not collect value-based relationships between columns.

  *

  Creating extended statistics

  Here are the steps to create extended statistics for related table columns

  withdbms_stats.created_extended_stats:

  1 - The first step is to create column histograms for the related columns.

  2 ?Next, we run dbms_stats.create_extended_stats to relate the columns together.

  Unlike a traditional procedure that is invoked via an execute ("exec") statement, Oracle extended statistics

  are created via a select statement.

• Question 60:

  Which two statements are true when row-archival management is enabled? (Choose two.)

  A. Visibility of the ORA_ARCHIVE_STATE column is controlled by the row archival visibility session parameter.

  B. The ORA_ARCHIVE_STATE column is updated manually or by a program that can reference activity tracking columns, to indicate that a row is no longer considered active.

  C. The row archival visibility session parameter defaults to all rows.

  D. The ORA_ARCHIVE_STATE column is visible if it is referenced in the select list of a query.

  E. The ORA_ARCHIVE_STATE column is updated automatically by the database based on activity tracking columns, to indicate that a row is no longer considered active.

  Correct Answer: BD