Oracle Oracle Certifications 1Z0-052 Questions & Answers

• Question 211:

  Which two are true about the Fast Recovery Area (FRA)? (Choose two.)

  A. Space management in the FRA is controlled by the database backup retention policy

  B. It must reside on the same file system as the database data files

  C. A database must be in ARCHIVELOG mode to use the FRA

  D. It should be larger than the database

  E. Only consistent backups can be stored in the FRA

  Correct Answer: AD

• Question 212:

  Which is true about external tables?

  A. The ORACLE_DATAPUMP access driver can be used to load data into external tables

  B. They do not support partitioning

  C. Segments are allocated for external tables

  D. DML operations may be performed on external tables

  E. They may have indexes

  Correct Answer: A

• Question 213:

  Which two are true about Optimizer Statistics? (Choose two.)

  A. They are automatically updated when DDL statements execute

  B. They can be gathered by executing the PL/SQL procedures in the DBMS_STATS package

  C. They are gathered by the Manageability Monitor (MMON) background process

  D. They provide information to the Optimizer so that it can determine optimal execution plans for SQL statements

  E. They can be used to determine the events on which a database instance waited

  F. They do not persist across instance restarts

  Correct Answer: BD

• Question 214:

  A database user SMITH tries to query the V$SESSION view and fails to access it as follows:

  

  Which solution will enable SMITH to query the data in V$SESSION?

  A. granting SELECT privilege to SMITH on V$SESSION

  B. granting SELECT privilege to SMITH on V_$SESSION

  C. asking the user SMITH to run the catalog.sql script

  D. granting SELECT privilege to SMITH on V$FIXED_TABLES

  E. setting the O7_DICTIONARY_ACCESSIBILITY parameter to TRUE

  Correct Answer: B

• Question 215:

  Examine these commands and their output:

  

  A power failure occurs. The instance is restarted and this query is executed.

  SQL> SELECT ename FROM emp;

  What is the outcome?

  A. No rows are returned

  B. Only Adam and Alan are displayed

  C. Adam, Alan, Ben, and Bryan are displayed

  D. Only Adam, Alan, and Bryan are displayed

  E. Only Adam, Alan, and Ben are displayed

  Correct Answer: B

• Question 216:

  You want to use the ALTER SYSTEM statement with SCOPE=MEMORY to change an initialization parameter value.

  Which is true?

  A. The change occurs immediately in memory for dynamic parameters but it is not persistent after instance restart

  B. It can be used only if an spfile is used

  C. The change occurs immediately in memory for static parameters but it is not persistent after instance restart

  D. It can be used only if a pfile is used

  Correct Answer: A

• Question 217:

  Which are three of the various resources that must be accessible to keep a database open?

  A. SYSTEM tablespace

  B. spfile

  C. all members of a redo log group

  D. SYSAUX tablespace

  E. control file

  Correct Answer: ADE

• Question 218:

  Which three are true about the Automatic Workload Repository (AWR)? (Choose three.)

  A. AWR data is stored in the SYSTEM tablespace

  B. Its collection level is determined by the value of the STATISTICS_LEVEL database parameter

  C. It is the foundation for the self-managing infrastructure

  D. The taking of AWR snapshots cannot be disabled

  E. By default, AWR snapshots are taken every 60 minutes

  Correct Answer: BCE

• Question 219:

  USER1.EMP has a referential integrity constraint defined on EMP.DNO that references USER1.DEPT.DNO.

  USER1 executes these commands:

  

  What will be the outcome and why?

  A. It will execute successfully and drop the DEPT.DNO and EMP.DNO columns

  B. It will fail because there is an uncommitted transaction on USER1.EMP

  C. It will execute successfully and drop DEPT.DNO

  D. It will fail because a referential integrity constraint is defined on USER1.EMP

  E. It will fail because there is an uncommitted transaction on USER1.DEPT

  Correct Answer: C

• Question 220:

  Which four are true about transaction, table, and row locks in an Oracle Database? (Choose four.)

  A. Transaction locks are released when that transaction executes a COMMIT statement

  B. DML statements lock modified tables in exclusive mode

  C. Transaction locks are released when that transaction executes a ROLLBACK statement

  D. DDL statements never lock the objects that they modify

  E. A table's row-level locks escalate to table locks when a majority of rows in that table are locked in exclusive mode

  F. SELECT statements are never blocked by row-level locks

  G. DML statements lock modified rows in exclusive mode

  Correct Answer: BCFG