Oracle Oracle Certifications 1Z0-052 Questions & Answers

• Question 241:

  Which two are true about undo tablespaces? (Choose two.)

  A. They must have only one data file

  B. Single instance databases can have only one active undo tablespace

  C. They always retain undo for the time period defined by UNDO_RETENTION

  D. They can be recovered only when an instance is in MOUNT state

  E. Tables can be created in undo tablespaces by SYS

  Correct Answer: CE

• Question 242:

  What function is performed by the System Monitor (SMON) background process in a database instance?

  A. It performs recovery when a user process fails.

  B. It performs instance recovery when failed database instance is restarted.

  C. It monitors memory space allocation only within the System Global Area (SGA).

  D. It monitors memory space allocation within the SGA and the Program Global Area (PGA).

  Correct Answer: B

• Question 243:

  Which action is automatically performed as part of the Incident Packaging Service in Enterprise Manager Support Workbench?

  A. invoking the Data Recovery Advisor and SQL Repair Advisor

  B. gathering metadata from the Automatic Diagnostic Repository (ADR)

  C. Creating a service request with My Oracle Support

  D. invoking the SQL Test Case Builder

  Correct Answer: B

• Question 244:

  USER1 grants SELECT, INSERT, and UPDATE privileges on USER1, EMP to USER2.

  SYS executes this command:

  SQL>REVOKE UPDATE ON user1.emp FROM user1;

  What will be the outcome?

  A. It will succeed and only USER1 will be unable to perform SELECT, INSERT, or UPDATE on USER1.EMP

  B. It will succeed and only USER2 will be unable to perform SELECT, INSERT, or UPDATE on USER1.EMP

  C. It will fail because USER1 is the owner of USER1.EMP

  D. It will succeed but neither USER1 nor USER2 will be able to perform SELECT, INSERT, or UPDATE on USER1.EMP

  E. It will succeed and neither USER1 nor USER2 will be able to perform INSERT or UPDATE on USER1.EMP, but both will be able to query USER1.EMP

  Correct Answer: C

• Question 245:

  Which is true about the SYSTEM and SYSAUX tablespaces?

  A. Both tablespaces can be used for temporary storage if no temporary tablespace is defined

  B. Both tablespaces must be online for a database to be accessible

  C. The SYSAUX tablespace can be made read-only but the SYSTEM tablespace cannot

  D. Only the SYSTEM tablespace contains data dictionary tables

  Correct Answer: C

• Question 246:

  Which three are true about the Automatic Database Diagnostic Monitor (ADDM)? (Choose three.)

  A. It can assist the DBA in diagnosing database instance startup failures

  B. Its findings are accessible only by using Oracle Enterprise Manager

  C. It provides recommendations to improve database performance

  D. It runs automatically after each Automatic Workload Repository snapshot is created

  E. It improves database performance by automatically implementing Oracle's best practices

  F. it can be used by executing the PL/SQL procedures in the DBMS_ADDM package

  Correct Answer: BCD

• Question 247:

  Which three are true about auditing? (Choose three.)

  A. DDL statements can be audited when they fail to execute.

  B. Audit of the use of system privileges can be enabled for individual database users.

  C. Auditing is active only when the database is OPEN.

  D. All Oracle auditing operations occur by default.

  E. Audit records are always stored in the database.

  F. DML statements can be audited when they execute successfully.

  Correct Answer: BEF

• Question 248:

  Your database is configured in archivelog mode.

  The USERS01 tablespace is currently online.

  You are required to take the tablespace offline.

  Which clause or clauses ensure that no media recovery is required when the tablespace is brought back online?

  A. either the NORMAL or the IMMEDIATE clause

  B. only the IMMEDIATE clause

  C. either the NORMAL or the TEMPORARY clause

  D. only the TEMPORARY clause

  E. only the NORMAL clause

  Correct Answer: D

• Question 249:

  Which two are true about AWR snapshots? (Choose two.)

  A. They are always created automatically.

  B. They can be modified by using DMLs.

  C. They are not generated if STATISTICS_LEVEL is set to TYPICAL.

  D. They are stored in the SYSAUX tablespace.

  E. They can be retained forever.

  Correct Answer: AB

• Question 250:

  Your database is down. You log in as the user SYS and issue the following command:

  SQL>STARTUP

  Which steps occur and in what order as a result of executing this command?

  A. Only the instance is started.

  B. Instance is started and then database is mounted but not opened.

  C. Instance is started, then the database is mounted and finally opened.

  D. Instance is started, then the database is opened and finally mounted.

  Correct Answer: C