Oracle 1Z0-052 Online Practice Questions and Exam Preparation

Oracle 1Z0-052 Online Questions & Answers

• Question 281:

  Which three are true about the Automatic Database Diagnostic Monitor (ADDM)? (Choose three.)

  A. It can assist the DBA in diagnosing database instance startup failures
  B. Its findings are accessible only by using Oracle Enterprise Manager
  C. It provides recommendations to improve database performance
  D. It runs automatically after each Automatic Workload Repository snapshot is created
  E. It improves database performance by automatically implementing Oracle's best practices
  F. it can be used by executing the PL/SQL procedures in the DBMS_ADDM package
  B. Its findings are accessible only by using Oracle Enterprise Manager
  C. It provides recommendations to improve database performance
  D. It runs automatically after each Automatic Workload Repository snapshot is created

• Question 282:

  Which is true about the Database Configuration Assistant (DBCA)?

  A. It can register a database with Cloud Control and configure Database Control for the same database.
  B. It can change the server mode from dedicated to shared and vice versa for an existing database.
  C. It can use Oracle ASM for storing database files only if Oracle Managed Files (OMF) is configured.
  D. It can create new database templates only from existing templates or databases.
  D. It can create new database templates only from existing templates or databases.

• Question 283:

  Which statement describes the effect on an index, when the indexed column for the rows is updated in the base table?

  A. An update in a leaf row takes place.
  B. The index becomes invalid after the update.
  C. The leaf block containing the row to be updated is marked as invalid.
  D. A row in the leaf block of the index for the key value is logically deleted and a new leaf row is inserted.
  D. A row in the leaf block of the index for the key value is logically deleted and a new leaf row is inserted.

• Question 284:

  Which two statements are true regarding listeners? (Choose two.)

  A. Listeners use only the TCP/IP protocol.
  B. Multiple listener processes can run simultaneously on a host.
  C. Multiple database instances can be registered with a single listener.
  D. The listener-related errors can be traced only at the administrative level.
  E. Only one database instance can be registered with a single listener at any time.
  B. Multiple listener processes can run simultaneously on a host.
  C. Multiple database instances can be registered with a single listener.

• Question 285:

  Examine the command:

  SQL>ALTER USR skd ACCOUNT LOCK;

  Which two statements are true after the command is executed? (Choose two.)

  A. The SKD user cannot log in to the database instance
  B. The objects owned by the SKD user are not accessible to any user
  C. The other users can access the objects owned by the SKD user, on which they have access
  D. The password for the SKD user expires and the user is forced to change the password at the next log in
  A. The SKD user cannot log in to the database instance
  C. The other users can access the objects owned by the SKD user, on which they have access