Oracle Oracle Certifications 1Z0-062 Questions & Answers

• Question 161:

  In your database instance, the UNDO_RETENTION parameter is set to 1000 and undo retention is not guaranteed for the fixed size undo tablespace.

  Which statement is true about undo retention?

  A. Undo is retained in the UNDO tablespace for 1000 seconds, and then moved to the SYSTEM tablespace to provide read consistency.

  B. Inactive undo is retained for at least 1000 seconds if free undo space is available.

  C. Inactive undo is retained for 1000 seconds even if new transactions fall due to lack of space in the undo tablespace.

  D. Undo becomes expired obsolete after 1000 seconds.

  Correct Answer: B

• Question 162:

  Which two files must you copy from the Oracle home of the database that is being upgraded to the new Oracle home for Oracle Database 12c? (Choose three.)

  A. the tnsnames.ora file

  B. the sqlnet.ora file

  C. the initialization parameter file

  D. the password file

  E. the listener.ora file

  Correct Answer: ABE

  References: https://docs.oracle.com/cd/E11882_01/server.112/e23633/afterup.htm#UPGRD52747

• Question 163:

  In your Oracle 12c database, you invoke SQL *Loader Express Mode command to load data:

  $> sqlldr hr/hr table=employees

  Which two statements are true about this command? (Choose two.)

  A. It succeeds and creates the EMPLOYEES table in the HR schema if the table does not exist.

  B. It fails because the SQL *Loader control file location is not specified.

  C. It fails because the SQL *Loader data file location is not specified.

  D. It succeeds with default settings if the EMPLOYEES table belonging to the HR schema is already defined in the database.

  E. It succeeds even if the HR user does not have the CREATE DIRECTORY privilege.

  Correct Answer: DE

• Question 164:

  Backup requirements for a database:

  *

  Level 0 backup on Sunday

  *

  Cumulative incremental level 1 backup on Monday, Wednesday, and Saturday

  *

  Differential incremental level 1 backup on Tuesday, Thursday, and Friday

  Which three statements are true about the strategy? (Choose three.)

  A. Level 0 backup on Sunday contains all the blocks that have been formatted.

  B. Level 0 backup on Sunday contains all the blocks that have been changed since the last level 1 backup.

  C. Level 1 backup on Tuesday, Thursday, and Friday contains all the blocks that have been changed since the last level 1 backup.

  D. Level 1 backup on Monday, Wednesday, and Saturday contains all the blocks that have been changed since the last level 0 backup.

  E. Level 1 backup on Tuesday, Thursday, and Friday contains all the blocks that have been changed since the last level 0 backup.

  Correct Answer: BDE

• Question 165:

  When is the UNDO_RETENTION parameter value ignored by a transaction?

  A. when there are multiple undo tablespaces available in a database

  B. when the data file of the undo tablespace is autoextensible

  C. when the undo tablespace is of a fixed size and retention guarantee is not enabled

  D. when Flashback Database is enabled

  Correct Answer: C

  References: https://docs.oracle.com/cd/B19306_01/server.102/b14231/undo.htm (undo retention)

• Question 166:

  You create an Oracle 12c database and then import schemas that are required by an application which has not yet been developed.

  You want to get advice on creation of or modifications to indexes, materialized views and partitioning in these schemas.

  What must you run to achieve this?

  A. SQL Access Advisor with a SQL tuning set

  B. Automatic Database Diagnostic Monitor (ADDM) report

  C. SQL Tuning Advisor

  D. SQL Access Advisor with a hypothetical workload

  E. SQL Performance Analyzer

  Correct Answer: D

• Question 167:

  The HR user updates the salary of one of the employees in the non-partitioned EMPLOYEES table, but does not commit the transaction.

  Which two types of lock exist in this situation? (Choose two.)

  A. exclusive lock on the EMPLOYEES table

  B. null lock on the row being updated

  C. null lock on the EMPLOYEES table

  D. row level lock on the row being updated

  E. shared lock on the EMPLOYEES table

  Correct Answer: DE

• Question 168:

  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. 1, 5, and 4

  B. 3, 1, 5, and 6

  C. 2, 3, 6, and 4

  D. 2, 1, 6, and 4

  E. 2, 3, 1, and 6

  Correct Answer: E

• Question 169:

  The HR.DEPARTMENTS table is the parent of the HR.EMPLOYEES table. The EMPLOYEES.DEPARTMENT_ID column has a foreign key constraint with the ON DELETE CASCADE option that refers to the DEPARTMENTS.DEPARTMENT_ID column. An index exists on the DEPARTMENTS.DEPARTMENT_ID column. A transaction deletes a primary key in the DEPARTMENTS table, which has child rows in the EMPLOYEES table.

  Which statement is true?

  A. The transaction acquires a table lock only on the DEPARTMENTS table until the transaction is complete.

  B. The transaction acquires a table lock on the DEPARTMENTS table. This lock enables other sessions to query but not update the DEPARTMENTS table until the transaction on the DEPARTMENTS table is complete.

  C. The transaction acquires a table lock on the EMPLOYEES table. This lock enables other sessions to query but not update the EMPLOYEES table until the transaction on the DEPARTMENTS table is complete.

  D. Only the rows that are deleted in the DEPARTMENTS and EMPLOYEES tables are locked until the transactions on the DEPARTMENTS table is complete.

  Correct Answer: C

• Question 170:

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

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

  B. limiting the degree of parallelism of operations performed by user sessions in a consumer group

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

  D. limiting the CPU used per database call

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

  Correct Answer: ABC

  References: http://docs.oracle.com/cd/B19306_01/server.102/b14231/dbrm.htm