Oracle Oracle Certifications 1Z0-063 Questions & Answers

• Question 11:

  A telecom company wishes to generate monthly bills to include details of customer calls, listed in order of time of call.

  Which table organization allows for generating the bills with minimum degree of row sorting?

  A. a hash cluster

  B. an index cluster

  C. a partitioned table

  D. a sorted hash cluster

  E. a heap table with a rowid column

  Correct Answer: D

• Question 12:

  Examine the following steps of privilege analysis for checking and revoking excessive, unused privileges granted to users:

  1.

  Create a policy to capture the privileges used by a user for privilege analysis.

  2.

  Generate a report with the data captured for a specified privilege capture.

  3.

  Start analyzing the data captured by the policy.

  4.

  Revoke the unused privileges.

  5.

  Compare the used and unused privileges' lists.

  6.

  Stop analyzing the data.

  Identify the correct sequence of steps.

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

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

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

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

  Correct Answer: B

  1. Create a policy to capture the privilege used by a user for privilege analysis.

  3. Start analyzing the data captured by the policy.

  6. Stop analyzing the data.

  2. Generate a report with the data captured for a specified privilege capture.

  5. Compare the used and unused privileges' lists.

  4. Revoke the unused privileges.

• Question 13:

  Which three statements are true about the startup and shutdown of multitenant container databases (CDBs) and pluggable databases (PDBs)? (Choose three.)

  A. A PDB opened in restricted mode allows only local users to connect.

  B. When a CDB is open in restricted mode, PDBs must also be opened in restricted mode.

  C. When a CDB is in mount state, PDBs are automatically placed in mount state.

  D. All PDBs must be shut down before shutting down a CDB instance.

  E. When a CDB instance is started, PDBs can be placed in open state by using database triggers or by executing the alter pluggable database command.

  Correct Answer: BCE

• Question 14:

  You specified the warning and critical thresholds for a locally managed tablespace to be 60% and 70%, respectively.

  From the tablespace space usage metrics, you find that the space usage has reached the specified warning threshold value, but no alerts have been generated.

  What could be the reason for this?

  A. The event parameter was not set.

  B. The sql_trace parameter is set to false.

  C. Enterprise Manager was not used.

  D. The statistics_level parameter is set to basic.

  E. The timed_statistics parameter is set to false.

  Correct Answer: D

• Question 15:

  You are administering a multitenant container database (CDB) CDB1 that is running in ARCHIVELOG mode and contains pluggable databases (PDBs), PDB_1 and PDB_2.

  While opening pdb_1, you get an error:

  SQL> alter pluggable database pdb_1 open;

  ORA-01157: cannot identify/lock data file 11 - see DBWR trace file ORA-01110: data file 11: '/u01/app/oracle/oradata/cdb1/pdb_1/example01.dbf'

  To repair the failure, you open an RMAN session for the target database CDB$ROOT. You execute the following as the first command:

  RMAN> REPAIR FAILURE;

  Which statement describes the consequence of the command?

  A. The command performs the recovery and closes the failure.

  B. The command produces an error because RMAN is not connected to the target database pdb_1.

  C. The command produces an error because the ADVISE FAILURE command was not executed before the REPAIR FAILURE command.

  D. The command executes successfully, performs recovery, and opens PDB_1.

  Correct Answer: C

• Question 16:

  What can be automatically implemented after the SQL Tuning Advisor is run as part of the Automated Maintenance Task?

  A. statistics recommendations

  B. SQL profile recommendations

  C. SQL statement restructure recommendations

  D. creation of materialized views to improve query performance

  Correct Answer: B

• Question 17:

  You use RMAN with a recovery catalog to back up your database. The backups and the archived redo log files are backed up to media daily. Because of a media failure, the entire database along with the recovery catalog database is lost.

  Examine the steps required to recover the database:

  1.

  Restore an autobackup of the server parameter file.

  2.

  Restore the control file.

  3.

  Start up the database instance in nomount state.

  4.

  Mount the database.

  5.

  Restore the data files.

  6.

  Open the database with the resetlogs option.

  7.

  Recover the data files.

  8.

  Set D3ID for the database.

  Identify the required steps in the correct order.

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

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

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

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

  E. 8, 1, 3, 2, 4, 5, 6

  Correct Answer: B

• Question 18:

  Which four actions are possible during an Online Datafile Move operation? (Choose four.)

  A. Creating and dropping tables in the datafile being moved

  B. Performing file shrink of the data file being moved

  C. Querying tables in the datafile being moved

  D. Performing Block Media Recovery for a data block in the datafile being moved

  E. Flashing back the database

  F. Executing DML statements on objects stored in the datafile being moved

  Correct Answer: ACDF

• Question 19:

  Examine the command used to perform an incremental level-0 backup:

  RMAN> BACKUP INCREMENTAL LEVEL0 DATABASE;

  To enable block change tracking, after the incremental level 0 backup, you issue the command:

  SQL> ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE'/mydir/rman_change_track.f';

  To perform an incremental level-1 cumulative backup, you issue the command:

  RMAN> BACKUP INCREMENTAL LEVEL1 CUMULATIVE DATABASE;

  Which two statements are true in the preceding situation? (Choose two.)

  A. The block change tracking data is used only from the next incremental backup.

  B. The incremental level 1 backup fails because a block change tracking file Is created after the level 0 backup.

  C. The incremental level 1 backup does not use change tracking data for accomplishing the backup.

  D. The block change tracking file scans all blocks and creates a bitmap for the blocks backed up in the level 0 backup.

  E. The block change tracking data is used for the next incremental level 1 backup only after the next level 0 backup.

  Correct Answer: CE

• Question 20:

  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

  Correct Answer: C