Oracle 1Z0-062 Online Practice Questions and Exam Preparation

Oracle 1Z0-062 Online Questions & Answers

• Question 41:

  Which three statements are true about the SQL Tuning Advisor? (Choose three.)

  A. It can get input from the Automatic Workload Repository (AWR).
  B. It can run while a maintenance window is open.
  C. It can recommend creation of SQL plan baselines.
  D. It can rebuild indexes.
  E. It prevents regression of SQL statement performance.
  F. It can get input from SQL Scripts in flat files.
  A. It can get input from the Automatic Workload Repository (AWR).
  B. It can run while a maintenance window is open.
  E. It prevents regression of SQL statement performance.

  ---

  Reference: https://docs.oracle.com/database/121/TGSQL/tgsql_sqltune.htm#TGSQL543

• Question 42:

  An employee salary in the non-partitioned EMPLOYEES table, has been updated but the transaction is uncommitted. Which two types of lock are held by the transaction? (Choose two.)

  A. a row level lock on the row being updated
  B. a null lock on the row being updated
  C. a row shared lock on the EMPLOYEES table
  D. an exclusive lock on the EMPLOYEES table
  E. a null lock on the EMPLOYEES table
  A. a row level lock on the row being updated
  C. a row shared lock on the EMPLOYEES table

• Question 43:

  The user SCOTT owns the CUST table that is placed in the SALES tablespace. The user SCOTT opens a session and executes commands as follows:

  SQL> INSERT INTO cust VALUES(101, 'JACK');

  1 row created.

  SQL> INSERT INTO cust VALUES(102, 'SMITH');

  1 row created.

  As a DBA, you execute the following command from another session:

  ALTER TABLESPACE sales READ ONLY;

  Which statement is true regarding the effect of this command on the transaction in Scott's session?

  A. The command fails as a transaction is still pending.
  B. The transaction in Scott's session is rolled back and the tablespace becomes readonly.
  C. The command waits and the user SCOTT can execute data manipulation language (DML) statements only as part of the current transaction.
  D. The command hangs until all transactions on the objects in the tablespace commit or rollback, and then the tablespace is placed in readonly mode.
  B. The transaction in Scott's session is rolled back and the tablespace becomes readonly.

• Question 44:

  Examine the following command;

  ALTER SYSTEM SET enable_ddl_logging = TRUE;

  Which statement is true?

  A. Only the data definition language (DDL) commands that resulted in errors are logged in the alert log file.
  B. All DDL commands are logged in the alert log file.
  C. All DDL commands are logged in a different log file that contains DDL statements and their execution dates.
  D. Only DDL commands that resulted in the creation of new segments are logged.
  E. All DDL commands are logged in XML format in the alert directory under the Automatic Diagnostic Repository (ADR) home.
  E. All DDL commands are logged in XML format in the alert directory under the Automatic Diagnostic Repository (ADR) home.

• Question 45:

  Which three statements are true concerning unplugging a pluggable database (PDB)? (Choose three.)

  A. The PDB must be open in read only mode.
  B. The PDB must be dosed.
  C. The unplugged PDB becomes a non-CDB.
  D. The unplugged PDB can be plugged into the same multitenant container database (CDB)
  E. The unplugged PDB can be plugged into another CDB.
  F. The PDB data files are automatically removed from disk.
  B. The PDB must be dosed.
  D. The unplugged PDB can be plugged into the same multitenant container database (CDB)
  E. The unplugged PDB can be plugged into another CDB.

  ---

  B, not A: The PDB must be closed before unplugging it.

  D: An unplugged PDB contains data dictionary tables, and some of the columns in these encode information in an endianness-sensitive way. There is no supported way to handle the conversion of such columns automatically. This means, quite simply, that an unplugged PDB cannot be moved across an endianness difference.

  E (not F): To exploit the new unplug/plug paradigm for patching the Oracle version most effectively, the source and destination CDBs should share a filesystem so that the PDB's datafiles can remain in place.

• Question 46:

  Examine the following ALTER command:

  SQL> ALTER DISKGROUP dgroup1 UNDROP DISKS;

  What is the purpose of the command?

  A. It cancels all pending disk drops within the disk group
  B. It restores disks that are being dropped as the result of a DROP DISKGROUP operation.
  C. It mounts disks in the disk group for which the drop-disk operation has already been completed
  D. It restores all the dropped disks in the disk group for which the drop-disk operation has already been completed
  E. It adds previously dropped disks back into the disk group
  A. It cancels all pending disk drops within the disk group

• Question 47:

  You want to flash back a test database by five hours.

  You issue this command:

  SQL > FLASHBACK DATABASE TO TIMESTAMP (SYSDATE - 5/24);

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

  A. The database must have multiplexed redo logs for the flashback to succeed.
  B. The database must be MOUNTED for the flashback to succeed.
  C. The database must use block change tracking for the flashback to succeed.
  D. The database must be opened in restricted mode for the flashback to succeed.
  E. The database must be opened with the RESETLOGS option after the flashback is complete.
  F. The database must be opened in read-only mode to check if the database has been flashed back to the correct SCN.
  B. The database must be MOUNTED for the flashback to succeed.
  E. The database must be opened with the RESETLOGS option after the flashback is complete.

• Question 48:

  Examine this parameter setting:

  

  Now examine this command:

  ALTER TABLE hr.emp INMEMORY;

  Table altered.

  Which is true about effects of this command and any subsequent processing on hr.emp?

  A. Its data gets loaded into the IM Column Store in row format.
  B. Its data cannot be loaded into the default database buffer cache.
  C. Its data gets loaded into the IM Column Store in columnar format.
  D. The database instance uses the IM Column Store to process DMLs.
  A. Its data gets loaded into the IM Column Store in row format.

• Question 49:

  You want to create a role that:

  -is protected from unauthorized usage

  -

  does not use a password embedded in the application source code or stored in a table

  -

  is enabled for a user based on security policies defined in a PL/SQL package

  How would you create this role?

  A. as a secure application role
  B. with definer's rights
  C. with global authentication
  D. with external authentication
  A. as a secure application role

  ---

  References: https://docs.oracle.com/cd/B28359_01/network.111/b28531/authorization.htm#DBSEG97973

• Question 50:

  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 generates lots of redo.

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

  A. Increase the size of the temporary tablespace.
  B. Enable Automatic Memory Management (AMM).
  C. Enable undo retention guarantee.
  D. Enable temporary undo for the database.
  E. Increase the size of the redo log buffer.
  A. Increase the size of the temporary tablespace.
  D. Enable temporary undo for the database.