Oracle 1Z0-052 Online Practice Questions and Exam Preparation

Oracle 1Z0-052 Online Questions & Answers

• Question 11:

  The database instance is currently using SPFILE. View the Exhibit and examine the error that you received while running the DB Structure Integrity check. Given below are the steps to recover from the error in random order:

  1.

  Shut down the instance, if not already done.

  2.

  Copy one of the remaining control files to a new location.

  3.

  Change the value of the CONTROL_FILES initialization parameter to correspond to the new location of the control files.

  4.

  Start up the database instance to the NOMOUNT stage.

  5.

  Recover the database to the point of failure of the control file.

  6.

  Open the database.

  Identify the correct sequence of steps?

  Exhibit:

  

  A. 1, 2, 4, 3, 5, 6
  B. 2, 4, 3, 5, 6; 1 not required
  C. 4, 5, 6, 2, 3; 1 not required
  D. 5, 2, 3, 4; 1 and 6 not required
  A. 1, 2, 4, 3, 5, 6

• Question 12:

  Examine the command: SQL>DBMS_STATS.SET_TABLE_PREFS('SH','CUSTOMERS','PUBLISH','false'); Which statement describes the effect of the above command?

  A. Automatic statistics collection is stopped for the CUSTOMERS table
  B. Statistics for the CUSTOMERS table are locked and cannot be overwritten
  C. Existing statistics for the CUSTOMERS table become unusable for the query optimizer
  D. Subsequently, statistics gathered on the CUSTOMERS table are stored as pending statistics
  D. Subsequently, statistics gathered on the CUSTOMERS table are stored as pending statistics

• Question 13:

  While observing the index statistics, you find that an index is highly fragmented, thereby resulting in poor database performance. Which option would you use to reduce fragmentation without affecting the users who are currently using the index?

  A. Validate the index structure using the ANALYZE .... INDEX command
  B. Rebuild the index using the ALTER INDEX ..... REBUILD ONLINE command
  C. Change the block space utilization parameters using the ALTER INDEX command
  D. Deallocate the unused space in the index using the ALTER INDEX ... DEALLOCATE UNUSED command
  B. Rebuild the index using the ALTER INDEX ..... REBUILD ONLINE command

• Question 14:

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

  A. The ADDM requires at least four AWR snapshots for analysis
  B. The ADDM runs after each AWR snapshot is collected automatically by MMON
  C. The results of the ADDM analysis are stored in the Automatic Workload Repository (AWR)
  D. The ADDM analysis provides only diagnostics information but does not provide recommendations
  E. The ADDM calls other advisors if required, but does not provide recommendations about the advisors
  B. The ADDM runs after each AWR snapshot is collected automatically by MMON
  C. The results of the ADDM analysis are stored in the Automatic Workload Repository (AWR)

• Question 15:

  View the Exhibit. What would happen if Oracle Home is not empty?

  

  A. The installation will not be continued until the location is empty.
  B. The installation will proceed without overwriting the existing files.
  C. The installation can be continued, but the existing files will be overwritten.
  D. The installation terminates automatically after showing an error message.
  A. The installation will not be continued until the location is empty.

• Question 16:

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

  A. The checkpoint frequency decreases with the smaller redo log file size.
  B. It ensures that all committed data is written to the data files during normal shutdown.
  C. The frequent full checkpoint in a database can cause the overall degradation of the database performance.
  D. It prompts the Checkpoint (CKPT) process to write data to the data files and redo information to the online redo log files.
  B. It ensures that all committed data is written to the data files during normal shutdown.
  C. The frequent full checkpoint in a database can cause the overall degradation of the database performance.

• Question 17:

  You have issued a SHUTDOWN ABORT command to bring down your database instance. Consider the steps that will be performed later when you open the database:

  1.

  SGA is allocated.

  2.

  Control file is read.

  3.

  Redo log files are opened.

  4.

  Instance recovery is started.

  5.

  Background processes are started.

  6.

  Data file headers are checked for consistency.

  7.

  Server parameter file or the initialization parameter file is read. Which option has the correct order in which these steps occur?

  A. 7, 1, 5, 2, 3, 6, 4
  B. 1, 2, 3, 7, 5, 6, 4
  C. 7, 1, 4, 5, 2, 3, 6
  D. 1, 7, 5, 4, 2, 3, 6
  A. 7, 1, 5, 2, 3, 6, 4

• Question 18:

  Which naming method uses the tnsnames.ora file to store the connect descriptor used by the client while connecting to the database instance from a remote machine?

  A. Host naming method
  B. Local naming method
  C. External naming method
  D. Directory naming method
  B. Local naming method

• Question 19:

  The database is running in ARCHIVELOG mode. Examine the initialization parameters and their values set to enable archiving on your database server:

  

  Which statement is true regarding the archived redo log files?

  A. It will be created on the local file system in the location specified LOG_ARCHIVE_DEST_1 parameter.
  B. It will be created only in the flash recovery area (fast recovery area).
  C. It will be created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and the default location $ORACLE_HOME/dbs.
  D. It will be created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and location specified by the DB_RECOVERY_FILE_DEST parameter.
  A. It will be created on the local file system in the location specified LOG_ARCHIVE_DEST_1 parameter.

• Question 20:

  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).
  B. It performs instance recovery when failed database instance is restarted.