Download Oracle.1z0-052.BrainDumps.2018-12-29.165q.tqb
| Vendor: | Oracle |
| Exam Code: | 1z0-052 |
| Exam Name: | Oracle Database 11g: Administration I |
| Date: | Dec 29, 2018 |
| File Size: | 6 MB |
| Downloads: | 1 |
Demo Questions
Question 1
What can you achieve by implementing reverse key index?
- Reverse the bytes of each column indexed including the row ID
- Store a bitmap for each key value instead of a list of row IDs in the leaf node
- Prevent contention on the highest leaf block when using sequences to generate keys
- Remove repeated key values from the index to fit more index entries in a given amount of disk space
Correct answer: C
Question 2
SQL> AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL;
What is the effect of this command?
- One audit record is created for every successful DROP TABLE command executed in the session of SCOTT
- One audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to other users
- One audit record is created for the whole session if user SCOTT successfully drops one or more tables in his session
- One audit record is created for every session of any other user in which a table owned by SCOTT is dropped successfully
- One audit record is created for every successful DROP TABLE command executed by any user to drop tables owned by SCOTT
Correct answer: C
Question 3
You executed the following command to perform a backup of the USERS tablespace:
SQL> ALTER TABLESPACE users BEGIN BACKUP;
ALTER TABLESPACE users BEGIN BACKUP
*
ERROR at line 1:
ORA-01123: cannot start online backup; media recovery not enabled
What could be the reason for this error?
- The MTTR Advisor is disabled.
- The database is in NOARCHIVELOG mode.
- The tablespace is already in backup mode.
- The Flash Recovery Area is not configured.
Correct answer: B
