Free Oracle 1Z1-052 Exam Dumps Questions & Answers

What can you achieve by implementing reverse key index?

• A.  Prevent contention on the highest leaf block when using sequences to generate keys
• B.  Remove repeated key values from the index to fit more index entries in a given amount of disk space
• C.  Reverse the bytes of each column indexed including the row ID
• D.  Store a bitmap for each key value instead of a list of row IDs in the leaf node

You created a profile APP_USER and assigned it to the users. After a month, you decide to drop the profile.
Some user sessions are currently connected to the database instance and are using the APP_USER profile.
This command is used to drop the profile:
SQL> DROP PROFILE app_user;
Which statement describes the result?

• A.  The command produces an error.
• B.  The profile is dropped and current user sessions use the DEFAULT profile immediately.
• C.  The profile is dropped, the sessions are terminated, and the subsequent user sessions use the DEFAULT profile.

Which two statements are true regarding B-tree index? (Choose two.)

• A.  The leaf node stores a bitmap for each key value.
• B.  The rows with NULL value in key columns also have entries in the index.
• C.  The leaf blocks in the index are doubly linked.
• D.  The deletion of a row from the table causes a logical deletion in index leaf block and the space becomes available for the new leaf entry.

Examine the values for the following initialization parameters:
FAST_START_MTTR_TARGET=0
LOG_CHECKPOINT_INTERVAL=0
Which two will be the implications of these values in your database? (Choose two.)

• A.  The MTTR advisor will be disabled
• B.  Automatic checkpoint tuning will be disabled
• C.  The SGA advisor will be disabled
• D.  Checkpoint information will not be written to the alert log file

Which statements are true regarding the creation of an incident package file by using the EM Workbench Support? (Choose all that apply.)

• A.  You cannot create an incremental incident package when the physical files are purged from the ADR.
• B.  You can create the incremental incident package ZIP file for new or modified diagnostic information for the incident package already created.
• C.  You can add SQL test cases to the incident package.
• D.  You can add or remove the trace files to the package.