Oracle Oracle Certifications 1Z0-052 Questions & Answers

• Question 201:

  You want to enable archiving on your database. Presently, the database is running in NOARCHIVELOG

  mode.

  Given below are the steps to accomplish the task in random order:

  1.

  Shut down the instance.

  2.

  Execute the ALTER DATABASE ARCHIVELOG command.

  3.

  Start up the instance and mount the database.

  4.

  Set the DB_RECOVERY_FILE_DEST initialization parameter to $ORACLE_HOME/dest_1.

  5.

  Open the database.

  Which is the correct sequence of steps for accomplishing the task?

  A. 4, 1, 3, 2, 5

  B. 1, 3, 4, 5, 2

  C. 1, 3, 2, 5; 4 not required

  D. 4, 1, 5, 2; 3 not required

  E. 1, 3, 4, 5; 2 not required

  Correct Answer: C

• Question 202:

  You want to check the details of few errors that users have reported. You search for the alert log file and execute few commands to find the location of the alert log file.

  View the Exhibit and check the commands executed.

  

  What is the location of the alert_orcl.log file?

  A. ORACLE_HOME/dbs

  B. ORACEL_HOME/rdbms

  C. /u01/app/oracle/admin/orcl/adump

  D. /u01/app/oracle/flash_recovery_area

  E. ORACLE_BASE/diag/rdbms/orcl/alert

  F. ORACLE_BASE/diag/rdbms/orcl/orcl/trace

  Correct Answer: F

• Question 203:

  You executed the following command to create a tablespace called SALES_DATA:

  SQL> CREATE TABLESPACE sales_data

  DATAFILE SIZE 100M

  SEGMENT SPACE MANAGEMENT AUTO;

  Which two statements are true about the SALES_DATA tablespace? (Choose two)

  A. The database automatically determines the extent-sizing policy for the tablespace.

  B. The segments are automatically shrunk when the contents are removed from them.

  C. The allocation of extents within the tablespace is managed through the dictionary tables.

  D. The space utilization description of the data blocks in segments is recorded in bitmap blocks.

  E. The space utilization description of the data blocks in segments is managed through free lists.

  Correct Answer: AD

• Question 204:

  Identify the memory component from which memory may be allocated for:

  Session memory for the shared serverBuffers for I/O slavesOracle Database Recovery Manager (RMAN) backup and restore operations

  A. Large Pool

  B. Redo Log Buffer

  C. Database Buffer Cache

  D. Program Global Area (PGA)

  Correct Answer: A

• Question 205:

  You plan to install Oracle Grid Infrastructure and Oracle Database

  Which two mandatory tasks must be completed before you perform these installations? (Choose two.)

  A. creating an operating system user to be the owner of the Oracle installation

  B. setting the ORACLE_BASE environment variable to an existing directory

  C. creating the oper and asmdba operating system groups

  D. creating the Oracle Inventory and OSDBA groups in the operating system

  E. setting the ORACLE_SID environment variable

  Correct Answer: AD

• Question 206:

  Which command is used to display files that no longer conform to the backup retention policy?

  A. CROSSCHECK BACKUP

  B. SHOW DATAFILE BACKUP COPIES

  C. LIST EXPIRED BACKUP

  D. REPORT OBSOLETE

  Correct Answer: B

• Question 207:

  You notice that the performance of the database has degraded because of frequent checkpoints. Which two actions resolve the issue? (Choose two.)

  A. Disable automatic checkpoint tuning

  B. Check the size of the redo log file size and increase the size if it is small

  C. Set the FAST_START_MTTR_TARGET parameter as per the advice given by the MTTR Advisor

  D. Decrease the number of redo log members if there are more than one redo log members available in each redo log group

  Correct Answer: BC

• Question 208:

  You want to audit update statements that refer to USER1.DEPT.DNAME.

  Which type of auditing must you use?

  A. standard auditing

  B. mandatory auditing

  C. value-based auditing

  D. fine-grained auditing

  Correct Answer: C

• Question 209:

  Archivelog mode is enabled for your database and DB_CREATE_FILE_DEST is set to `/u01/oracle/db01'.

  The parameters, DB_CREATE_ONLINE_LOG_DEST_n and DB_RECOVERY_FILE_DEST, are not specified.

  Which four are stored in the location specified by DB-CREATE_FILE_DEST? (Choose four.)

  A. RMAN backups

  B. data files

  C. archived redo logs

  D. temp files

  E. control files

  F. audit logs

  G. audit files

  H. redo logs

  Correct Answer: BEFH

• Question 210:

  Your database instance is in the open state with uncommitted transactions.

  You plan to execute these commands:

  

  Which is true about the STARTUP command?

  A. It performs an instance recovery before opening the database in read/write mode

  B. It performs an instance recovery and leaves the database instance in mount state

  C. It opens the database in read-only mode

  D. It opens the database in read/write mode only if an spfile is used

  Correct Answer: C