Oracle Oracle Certifications 1Z0-052 Questions & Answers

• Question 261:

  Which two types of information can be found in the alert log? (Choose two.)

  A. instance recovery details

  B. values of all initialization parameters whenever an instance is restarted

  C. a record of all DDL statements performed by non-DBA users

  D. critical errors encountered by background processes

  E. a record of all actions performed by SYS and SYSTEM

  Correct Answer: DE

• Question 262:

  Which two are true about roles? (Choose two.)

  A. A secure application role can be set only by its associated PL/SQL package.

  B. A role can be granted a combination of system and object privileges and other roles.

  C. Roles are owned by SYSTEM.

  D. The CONNECT role is granted automatically to a user when it is created.

  E. The RESOURCE role is granted the CREATE SESSION privilege.

  Correct Answer: AB

• Question 263:

  Which two events always cause the LGWR to write? (Choose two.)

  A. when a checkpoint occurs

  B. when DBWn writes dirty buffers

  C. when LGWR is notified by a server process that performs a COMMIT OR ROLLBACK

  D. when a log switch occurs

  E. when PMON restarts a server process

  Correct Answer: AD

• Question 264:

  Which two are true about space management in tablespaces? (Choose two.)

  A. Extent allocation must be specified as automatic for automatic segment space management (ASSM) tablespaces

  B. Free lists are used for managing free space for segments in locally managed tablespaces

  C. ASSM tablespaces prevent row chaining

  D. Locally managed tablespaces track adjacent free space automatically by using bitmaps

  E. Locally managed tablespaces have either ASSM or manual segment space management (MSSM), and all the segments in these tablespaces are managed one way or the other

  Correct Answer: BD

• Question 265:

  Which is true about the Automatic Diagnostic Repository (ADR)?

  A. It only contains the alert log and trace files for background processes

  B. Its location is always set by the ORACLE_BASE variable

  C. It is used only if the DISGNOSTIC_DEST parameter is manually configured

  D. It includes diagnostic data for critical errors for each server and background process

  Correct Answer: A

• Question 266:

  A database instance was terminated due to a lost data file and has not been restarted. You wish to restore database availability by using the Data Recovery Advisor. Examine this list of RMAN commands:

  

  What are the minimum required commands and in what order must they be executed to achieve this?

  A. 1, 2, 3, 4, and 5

  B. 1 and 4

  C. 1, 2, 3, and 4

  D. 1, 3, and 4

  E. 1, 3, 4, and 5

  Correct Answer: D

• Question 267:

  Examine these attributes for the profile assigned to USER1 whose password is oracle_4U. PASSWORD_REUSE_MAX IS 5 PASSWORD_REUSE_TIME IS 10 PASSWORD_GARCE_TIME IS 15

  Which two conditions must be met for USER1 to reuse oracle_4U? (Choose two.)

  A. At least 10 days must have passed since oracle_4U was last used

  B. The password must have changed 5 times since oracle_4U was last used

  C. At least 15 days must have passed since oracle_4U was last used

  D. At least 5 days must have passed since oracle_4U was last used

  E. The password must have changed 10 times since oracle_4U was last used

  Correct Answer: CE

• Question 268:

  Where is backup metadata stored for use by Recovery Manager (RMAN)?

  A. in the SYSTEM tablespace

  B. in the control file

  C. in the SPFILE

  D. in the SYSAUX tablespace

  E. in the diagnostic destination files

  Correct Answer: B

• Question 269:

  Which is true about invalid PL/SQL objects?

  A. They must be manually recompiled before they can be used if a DDL is performed on a table that is referenced in the PL/SQL object.

  B. They are automatically recompiled against the new definition of a referenced object when they are called.

  C. They are automatically recompiled against the new definition of a referenced object at the same time as the modified referenced object.

  D. They can be manually recompiled only by using SQL commands.

  Correct Answer: B

• Question 270:

  Your DB_RECOVERY_FILE_DEST_SIZE is 8G.

  Currently, 5G of the space is used of which 4G consists of obsolete backups.

  You execute this command:

  SQL> ALTER SYSTEM SET db_recovery_fle_dest_size=2G;

  What is the outcome?

  A. It changes DB_RECOVERY_FILE_DEST_SIZE to 2G and deletes the obsolete backups.

  B. It changes DB_RECOVERY_FILE_DEST_SIZE to 5G.

  C. It fails because DB_RECOVERY_FILE_DEST_SIZE is a static parameter.

  D. It fails because the new size is less than 5G.

  E. It changes DB_RECOVERY_FILE_DEST_SIZE to 2G without deleting valid backups.

  Correct Answer: E