Oracle Oracle Certifications 1Z0-052 Questions & Answers

• Question 171:

  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 172:

  View the Exhibit and examine the privileges granted to the SL_REP user.

  

  The EMP table is owned by the SCOTT user. The SL_REP user executes the following command: SQL> GRANT SELECT ON scott.emp TO hr;

  Which statement describes the outcome of the command?

  A. The command executes successfully

  B. The command produces an error because the EMP table is owned by SCOTT

  C. The command produces an error because SL_REP has the GRANT ANY OBJECT PRIVILEGE without ADMIN_OPTION

  D. The command produces an error because SL_REP does not have the SELECT privilege with GRANT_OPTION on the EMP table

  Correct Answer: A

• Question 173:

  You executed this command to create a temporary table:

  SQL> CREATE GLOBAL TEMPORARY TABLE report_work_area (

  startdate DATE,

  enddate DATE,

  class CHAR(20)

  ) ON COMMIT PRESERVE ROWS;

  Which statement is true about the rows inserted into the REPORT_WORK_AREA table during a

  transaction?

  A. The rows stay in the table only until session termination

  B. The rows stay in the table only until the next transaction starts on the table

  C. The rows are visible to all current sessions after the transaction in committed D. The rows stay available for subsequent sessions after the transaction is committed

  Correct Answer: A

• Question 174:

  Examine the following steps performed on a database instance:

  1.

  The DBA grants the CREATE TABLE system privilege to the SKD user with ADMIN OPTION

  2.

  The SKD user creates a table

  3.

  The SKD user grants the CREATE TABLE system privilege to the HR user

  4.

  The HR user creates a table

  5.

  The DBA revokes the CREATE TABLE system privilege from SKD Which statement is true after step 5 is performed?

  A. The table created by SKD is not accessible and SKD cannot create new tables

  B. The tables created by SKD and HR remain, but both cannot create new tables

  C. The table created by HR remains and HR still has the CREATE TABLE system privilege

  D. The table created by HR remains and HR can grant the CREATE TABLE system privilege to other users

  Correct Answer: C

• Question 175:

  Which two statements are true about alerts? (Choose two.)

  A. Clearing an alert sends the alert to the alert history

  B. Response actions cannot be specified with server-generated alerts

  C. The nonthreshold alerts appear in the DBA_OUTSTANDING_ALERTS view

  D. Server-generated alerts notify the problems that cannot be resolved automatically and require administrators to be notified

  Correct Answer: AD

• Question 176:

  Identify the two situations in which the alert log file is updated with details. (Choose two.)

  A. Running a query on a table returns "ORA-600: Internal Error"

  B. Inserting a value in a table returns "ORA-01722: Invalid Number"

  C. Creating a table returns "ORA-00955: name is already used by an existing object'

  D. Inserting a value in a table returns "ORA-00001: unique constraint (SYS.PK_TECHP) violated."

  E. Rebuilding an index using ALTER INDEX ... REBUILD fails with an error "ORA-01578: ORACLE data block corrupted (file # 14, block @ 50)."

  F. Rebuilding an index using ALTER INDEX .... REBUILD fails with an error "ORA-01578: ORACLE data block corrupted (file #14, block #50)."

  Correct Answer: AE

• Question 177:

  Which two statements are true regarding Oracle Data Pump? (Choose two.)

  A. EXPDP and IMPDP are the client components of Oracle Data Pump

  B. DBMS_DATAPUMP PL/SQL packages can be used indedendently of the DATA Pump clients

  C. Oracle Data Pump export and import operations can be performed only by users with the SYSDBA privilege

  D. Oracle Data Pump imports can be done from the export files generated in the Original Export Release

  9.x

  E. EXPDP and IMPDP use the procedures provided by DBMS_METADATA to execute export and import commands

  Correct Answer: AB

• Question 178:

  Which two statements are true regarding a tablespace? (Choose two.)

  A. It can span multiple databases

  B. It can consist of multiple data files

  C. It can contain blocks of different files

  D. It can contains segments of different sizes

  E. It can contains a part of nonpartitioned segment

  Correct Answer: BD

• Question 179:

  Which two statements correctly describe the relation between a data file and the logical database structures? (Choose two)

  A. An extent cannot spread across data files.

  B. A segment cannot spread across data files.

  C. A data file can belong to only one tablespace.

  D. A data file can have only one segment created in it.

  E. A data block can spread across multiple data files as it can consist of multiple operating system (OS) blocks.

  Correct Answer: AC

• Question 180:

  Which two kinds of failures make the Data Recovery Advisor (DRA) generate a manual checklist? (Choose two.)

  A. Failure when no standby database is configured

  B. Failure because a data file is renamed accidentally

  C. Failure that requires no archive logs to be applied for recovery

  D. Failure due to loss of connectivity-for example, an unplugged disk cable

  Correct Answer: BD