Download Oracle Database 11g-Administration I.braindumps.1z0-052.1e.165q.vcex

Download Dump

File Info

Exam Oracle Database 11g: Administration I
Number 1z0-052
File Name Oracle Database 11g-Administration I.braindumps.1z0-052.1e.165q.vcex
Size 4.91 Mb
Posted December 29, 2018
Downloads 33



How to open VCEX & EXAM Files?

Files with VCEX & EXAM extensions can be opened by ProfExam Simulator.

Purchase
Coupon: EXAMFILESCOM

Coupon: EXAMFILESCOM
With discount: 20%





Demo Questions

Question 1
What can you achieve by implementing reverse key index?

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



Question 2
SQL> AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL; 
What is the effect of this command?

  • A: One audit record is created for every successful DROP TABLE command executed in the session of SCOTT
  • B: One audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to other users
  • C: One audit record is created for the whole session if user SCOTT successfully drops one or more tables in his session
  • D: One audit record is created for every session of any other user in which a table owned by SCOTT is dropped successfully
  • E: One audit record is created for every successful DROP TABLE command executed by any user to drop tables owned by SCOTT



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?

  • A: The MTTR Advisor is disabled.
  • B: The database is in NOARCHIVELOG mode.
  • C: The tablespace is already in backup mode.
  • D: The Flash Recovery Area is not configured.



Question 4
Which statements listed below describe the data dictionary views? 
These are stored in the SYSTEM tablespace. 
These are the based on the virtual tables. 
These are owned by the SYS user. 
These can be queried by a normal user only if O7_DICTIONARY_ACCESSIBLILITY parameter is set to TRUE. 
The V$FIXED_TABLE view can be queried to list the names of these views.

  • A: 1 and 3
  • B: 2,3 and 5
  • C: 1,2, and 5
  • D: 2,3,4 and 5



Question 5
View the Exhibit to examine the error that occurred during the database startup. 

  

You opened an RMAN session for the database. To repair the failure, you executed the following command as the first RMAN command:
RMAN> REPAIR FAILURE; 

Which statement describes the consequence of this command?

  • A: The command performs the recovery and closes the failure.
  • B: The command only displays the advice and the RMAN script required for recovery.
  • C: The command executes the RMAN script to repair the failure and remove the entry from the Automatic Diagnostic Repository (ADR).
  • D: The command produces an error because the ADVISE FAILURE command was not executed before the REPAIR FAILURE command.



Question 6
You execute this command to drop the ITEM table, which has the primary key referred in the ORDERS table:
SQL> DROP TABLE scott.item CASCADE CONSTRAINTS PURGE; 
Which two statements are true about the effect of the command? (Choose two.)

  • A: No flashback is possible to bring back the ITEM table
  • B: The ORDERS table is dropped along with the ITEM table
  • C: The dependent referential integrity constraints in the ORDERS table are disabled
  • D: The dependent referential integrity constraints in the ORDERS table are removed
  • E: The table definition of the ITEM table and associated indexes are placed in the recycle bin



Question 7
You plan to move data from a flat file to a table in your database. You decide to use SQL*Loader direct path load method to perform this task. The table in which you plan to load data in an important table having various integrity constraint defined on it. 
Which constraints will remain enabled by default during this operation? (Choose all that apply.)

  • A: CHECK
  • B: UNIQUE
  • C: NOT NULL
  • D: PRIMARY KEY
  • E: FOREIGN KEY



Question 8
SQL> AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL; 
What is the effect of this command?

  • A: One audit record is created for every successful DROP TABLE command executed in the session of SCOTT
  • B: One audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to other users
  • C: One audit record is created for the whole session if user SCOTT successfully drops one or more tables in his session
  • D: One audit record is created for every session of any other user in which a table owned by SCOTT is dropped successfully
  • E: One audit record is created for every successful DROP TABLE command executed by any user to drop tables owned by SCOTT



Question 9
User A executes the following command to drop a large table in your database:
SQL> DROP TABLE trans; 

While the drop table operation is in progress; user B executes the following command on the same table; 
SQL> DELETE FROM trans WHERE tr_type='SL'; 

Which statement is true regarding the DELETE command?

  • A: It fails to delete the records because the records are locked in the SHARE mode
  • B: It deletes the rows successfully because the table is locked in the SHARE mod
  • C: It fails to delete the records because the table is locked in EXCLUSIVE mode
  • D: It deletes the rows successfully because the table is locked in SHARE ROW EXCLUSIVE mode



Question 10
In which situation may the UNDO_RETENTION parameter be ignored, even if it is set to a value?

  • A: When the data file of the undo tablespace is autoextensible
  • B: When there are more than one undo tablespace available in the database
  • C: When the undo tablespace is of a fixed size and retention guarantee is not enabled
  • D: When the undo tablespace is autoextensible and retention guarantee is not enabled









CONNECT US


ProfExam
PROFEXAM WITH A 20% DISCOUNT

You can buy ProfExam with a 20% discount..

Get Now!


HOW TO OPEN VCEX AND EXAM FILES

Use ProfExam Simulator to open VCEX and EXAM files
ProfExam Screen



HOW TO OPEN VCE FILES

Use VCE Exam Simulator to open VCE files
Avanaset