Oracle Oracle Certifications 1Z0-063 Questions & Answers

• Question 121:

  You want the execution of large database operations to suspend, and then resume, in the event of space allocation failures.

  You set the value of the initialization parameter resumable_timeout to 3600.

  Which two statements are true? (Choose two.)

  A. A resumable statement can be suspended and resumed only once during execution.

  B. Data Manipulation Language (DML) operations are resumable, provided that they are not embedded in a PL/SQL block.

  C. A suspended statement will report an error if no corrective action has taken place during a timeout period.

  D. Before a statement executes in resumable mode, the alter session enable resumable statement must be issued in its session.

  E. Suspending a statement automatically results in suspending a transaction and releasing all the resources held by the transaction.

  Correct Answer: CD

• Question 122:

  Your database is running in archivelog mode and Automatic Undo Management is enabled.

  Which two tasks should you perform before enabling Flashback Database? (Choose two.)

  A. Enable minimal supplemental logging.

  B. Ensure that the db_flashback_retention_target parameter is set to a point in time (in minutes) to which the database can be flashed back.

  C. Enable the recyclebin.

  D. Enable undo retention guarantee.

  E. Enable Fast Recovery Area.

  Correct Answer: BE

• Question 123:

  Consider the following scenario for your database:

  Backup optimization is enabled in RMAN.

  The recovery window is set to seven days in RMAN.

  The most recent backup to disk for the tools tablespace was taken on March 1, 2013.

  The tools tablespace is read-only since March 2, 2013.

  On March 15, 2013, you issue the RMAN command to back up the database to disk.

  Which statement is true about the backup of the tools tablespace?

  A. The RMAN backup fails because the tools tablespace is read-only.

  B. RMAN skips the backup of the tools tablespace because backup optimization is enabled.

  C. RMAN creates a backup of the tools tablespace because backup optimization is applicable only for the backups written to media.

  D. RMAN creates a backup of the tools tablespace because no backup of the tablespace exists within the seven-day recovery window.

  Correct Answer: D

• Question 124:

  You are administering a database that supports a 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.

  Which action must you take for recovery?

  A. Restore the data file, recover it by using the recover datafilenoredo command, and use the resetlogs option to open the database.

  B. Restore the control file and all the data files, recover them by using the recover database noredo command, and use the resetlogs option to open the database.

  C. Restore all the data files, recover them by using the recover database command, and open the database.

  D. Restore all the data files, recover them by using the recover database noredo command, and use the resetlogs option to open the database.

  Correct Answer: B

• Question 125:

  Which three statements are true about Oracle Restart? (Choose three.)

  A. It can be configured to automatically attempt to restart various components after a hardware or software failure.

  B. While starting any components, it automatically attempts to start all dependencies first and in proper order.

  C. It can be configured to automatically restart a database in case of normal shutdown of the database instance.

  D. It can be used to only start Oracle components.

  E. It runs periodic check operations to monitor the health of Oracle components.

  Correct Answer: ABE

  Reference: http://docs.oracle.com/cd/E18283_01/server.112/e17120/restart001.htm

• Question 126:

  Examine the parameters for your database instance:

  NAME TYPE VALUE

  optimizer_adaptive_reporting_only boolean FALSE optimizer_capture_sql_plan_baselines boolean FALSE optimizer_dynamic_sampling integer 2 optimizer_features_enable string 12.1.0.1

  Which three statements are true about the process of automatic optimization by using statistics feedback? (Choose three.)

  A. The optimizer automatically changes a plan during subsequent execution of a SQL statement if there is a huge difference in optimizer estimates and execution statistics.

  B. The optimizer can re optimize a query only once using cardinality feedback.

  C. The optimizer enables monitoring for cardinality feedback after the first execution of a query.

  D. The optimizer does not monitor cardinality feedback if dynamic sampling and multicolumn statistics are enabled.

  E. After the optimizer identifies a query as a re-optimization candidate, statistics collected by the collectors are submitted to the optimizer.

  Correct Answer: ACE

• Question 127:

  RMAN is connected to the target database prod1 and an auxiliary instance in nomount state. Examine the command to create a duplicate database:

  

  Which two statements are true about the execution of the duplicate command? (Choose two.)

  A. All archive redo log files are automatically copied to the duplicate database.

  B. The duplicate database has the same directory structure as the source database.

  C. C. The duplicate database is created by using the backups created during the execution of the DUPLICATE command.

  D. The password file and SPFILE for the duplicate database DUP1 are created in their respective default locations.

  E. The duplicate database is created without using RMAN backups and PROD1 is allowed to remain open during duplication.

  Correct Answer: BE

• Question 128:

  A user issues a query on the sales table and receives the following error: ERROR at line 1:

  ORA-01565: error in identifying file '/u0l/app/oracle/oradata/ORCL/temp01.dbf' ORA-27037: unable to obtain file status

  Which two actions would you take to recover the temporary tablespace? (Choose two.)

  A. Drop the tenp01.dbf file, and then re-create the temp file.

  B. Add a new temp file to the temporary tablespace and drop the temp01.dbf file.

  C. Shut down the database instance, start up the database instance in mount state, create a new temporary tablespace, and then open the database.

  D. Take the temporary tablespace offline, recover the missing temp file, and then bring the temporary tablespace online.

  E. Create a new temporary tablespace and assign it as the default to the user.

  Correct Answer: BE

• Question 129:

  Your database supports an online transaction processing (OLTP) workload in which one of the applications creates a temporary table for a session and performs transactions on it. This consumes a lot of undo tablespace and is affecting undo retention.

  Which two actions would you take to solve this problem? (Choose two.)

  A. Enable temporary undo for the database.

  B. Enable undo retention guarantee.

  C. Increase the size of the redo log buffer.

  D. Enable Automatic Memory Management (AMM).

  E. Increase the size of the temporary tablespace.

  Correct Answer: AE

• Question 130:

  Your multitenant container database (CDB) contains multiple pluggable databases (PDBs). You execute the command to create a common user:

  SQL> CREATE USER c##a_admin IDENTIFIED BY password DEFAULT TABLESPACE users QUOTA 100M ON users TEMPORARY TABLESPACE temp;

  Which statement is true about the execution of the command?

  A. The common user is created in the CDB and all the PDBs, and uses the users and temp tablespaces of the CDB to store schema objects.

  B. The command succeeds only if all the PDBs have the USERS and TEMP tablespaces.

  C. The command gives an error because the CONTAINER=ALL clause is missing.

  D. The command succeeds and sets the default permanent tablespace of a PDB as the default tablespace for the C##A_ADMIN user if the USERS tablespace does not exist in that PDB.

  Correct Answer: B