Oracle Oracle Certifications 1Z0-052 Questions & Answers

• Question 161:

  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

  Correct Answer: AD

• Question 162:

  Which statements listed below describe the data dictionary views?

  1.

  These are stored in the SYSTEM tablespace

  2.

  These are the based on the virtual tables

  3.

  These are owned by the SYS user

  4.

  These can be queried by a normal user only if O7_DICTIONARY_ACCESSIBLILITY parameter is set to TRUE

  5.

  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

  Correct Answer: A

• Question 163:

  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

  Correct Answer: D

• Question 164:

  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

  Correct Answer: C

• Question 165:

  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.

  Correct Answer: B

• Question 166:

  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

  Correct Answer: C

• Question 167:

  Examine the following command that is used to create a table:

  

  Which two statements are true about the effect of the above command? (Choose two.)

  A. A CHECK constraint is created on the OID column

  B. A NOT NULL constraint is created on the OID column

  C. The ORDERS table is the only object created in the USERS tablespace

  D. The ORDERS table and a unique index are created in the USERS tablespace

  E. The ORDERS table is created in the USERS tablepsace and a unique index is created on the OID column in the SYSTEM tablespace

  Correct Answer: BD

• Question 168:

  View the Exhibit to examine the details for an incident.

  

  Which statement is true regarding the status of the incident?

  A. The DBA is working on the incident and prefers that the incident be kept in the ADR

  B. The incident is now in the Done state and the ADR can select the incident to be purged

  C. The incident has been newly created and is in the process of collecting diagnostic information

  D. The data collection for the incident is complete and the incident can be packaged and sent to Oracle Support

  Correct Answer: D

• Question 169:

  You want to access employee details contained in flat files as part of the EMPLOYEE table. You plan to add a new column to the EMPLOYEE table to achieve this.

  Which data types would you use for the new column?

  A. CLOB

  B. BLOB

  C. BFILE

  D. LONG RAW

  Correct Answer: C

• Question 170:

  The HR user creates a stand-alone procedure as follows and grants the EXECUTE privilege on the

  procedure to many database users:

  CREATE OR REPLACE PROCEDURE create_dept ( v_deptno NUMBER, v_dname VARCHAR2, v_mgr

  NUMBER, v_loc NUMBER)

  BEGIN

  INSERT INTO hr.departments VALUES (v_deptno, v_dname, v_mgr, v_loc);

  END;

  The users having permission to execute the procedure are able to insert records into the DEPARTMENTS

  table even though they do not have the INSERT privilege on the table. You want only those users who have privileges on the DEPARTMENTS table to be able to execute the procedure successfully. What would you suggest to the PL/SQL developers to achieve this?

  A. Create the procedure with definer's right.

  B. Create the procedure with invoker's right.

  C. Grant the EXECUTE privilege with GRANT OPTION on the procedure to selected users.

  D. Create the procedure as part of a PL/SQL package and grant the EXECUTE privilege on the package to selected users.

  Correct Answer: B