Oracle 1Z0-052 Online Practice Questions and Exam Preparation

Oracle 1Z0-052 Online Questions & Answers

• Question 1:

  When would you use memory advisors?

  A. to get a recommendation whether Automatic Memory Management (AMM) or Automatic Shared Memory Management (ASMM) should be implemented.
  B. to determine the impact of adding or reducing memory on DB Time
  C. to generate memory-related alerts when memory demand exceeds a specified percentage
  D. to determine the impact of adding memory on hard parse count
  E. to determine the impact of adding memory on logical and physical reads
  B. to determine the impact of adding or reducing memory on DB Time

• Question 2:

  The user HR receives the following error while inserting data into the TTK table:

  ERROR at line 1:

  ORA-01653: unable to extend table HR.TTK by 128 in tablespace SMD

  Upon investigation, you find that SMD is a small file tablespace.

  Which three action would allow the user to insert data? (Choose three.)

  A. Add a data file to the SMD tablespace.
  B. Add a data file to the temporary tablespace associated with the user HR.
  C. Resize the data file associated with the SMD tablespace to make it larger.
  D. Alter the data file associated with the SMD tablespace to grow automatically.
  E. Change the segment space management for the SMD tablespace to automatic.
  A. Add a data file to the SMD tablespace.
  C. Resize the data file associated with the SMD tablespace to make it larger.
  D. Alter the data file associated with the SMD tablespace to grow automatically.

• Question 3:

  You used the IMMEDIATE option to shutdown 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 read.

  4.

  Instance recovery is started.

  5.

  Background processes are started.

  6.

  Data files 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, 5, 7, 2, 3, 6; step 4 is not required
  C. 7, 1, 5, 2, 3, 6 step 4 is not required
  D. 1, 2, 3, 5, 6, 4; step 7 is not required
  C. 7, 1, 5, 2, 3, 6 step 4 is not required

• Question 4:

  Observe the information in the columns:

  

  Which option has the correct match between the memory areas and their contents?

  A. 1-c, 2-b, 3-d, 4-a B. 1-b, 2-c, 3-d, 4-a
  C. 1-a, 2-b, 3-c, 4-d
  D. 1-a, 2-b, 3-d, 4-c
  C. 1-a, 2-b, 3-c, 4-d

• Question 5:

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

  A. Clearing an alert sends the alert to the alert history
  B. Response actions cannot be specified with server-generated alerts
  C. The nonthreshold alerts appear in the DBA_OUTSTANDING_ALERTS view
  D. Server-generated alerts notify the problems that cannot be resolved automatically and require administrators to be notified
  A. Clearing an alert sends the alert to the alert history
  D. Server-generated alerts notify the problems that cannot be resolved automatically and require administrators to be notified

• Question 6:

  Which two statements are true about setting the FAST_START_MTTR_TARGET initialization parameter to a nonzero value? (Choose two.)

  A. The MTTR advisor will be disabled
  B. Automatic checkpoint tuning will be enabled
  C. The value for the LOG_CHECKPOINT_INTERVAL initialization parameter will be override the value for FAST_START_MTTR_TARGET
  D. The time taken to recover the instance after the crash is always exactly the same as the value given for the FAST_START_MTTR_TARGET initialization parameter
  B. Automatic checkpoint tuning will be enabled
  C. The value for the LOG_CHECKPOINT_INTERVAL initialization parameter will be override the value for FAST_START_MTTR_TARGET

• Question 7:

  Which three statements are correct about temporary tables? (Choose three.)

  A. Indexes and views can be created on temporary tables.
  B. Both the data and the structure of temporary tables can be exported.
  C. Temporary tables are always created in a user's temporary tablespace.
  D. The data inserted into a temporary table in a session is available to other sessions.
  E. Data manipulation language (DML) locks are never acquired on the data of temporary tables.
  A. Indexes and views can be created on temporary tables.
  C. Temporary tables are always created in a user's temporary tablespace.
  E. Data manipulation language (DML) locks are never acquired on the data of temporary tables.

• Question 8:

  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
  A. Space management in the FRA is controlled by the database backup retention policy
  D. It should be larger than the database

• Question 9:

  View the Exhibit and examine the parameters. User A executes the following command to update the TRANS table:

  SQL> UPDATE B.trans SET tr_amt=tr_amt+500 WHERE c_code='C005';

  Before user A issues a COMMIT or ROLLBACK command, user B executes the following command on the TRANS table:

  SQL> ALTER TABLE trans MODIFY (tr_type VARCHAR2(3));

  What would happen in this scenario?

  Exhibit:

  

  A. The ALTER TABLE command modifies the column successfully
  B. The DDL operation gets higher priority and transaction for user A is rolled back
  C. The ALETER TABLE command waits indefinitely until user A ends the transaction
  D. The ALTER TABLE command fails after waiting for 60 seconds due to the resource being busy
  D. The ALTER TABLE command fails after waiting for 60 seconds due to the resource being busy

• Question 10:

  The instance abnormally terminates because of a power outage. Which statement is true about redo log files during instance recovery?

  A. Inactive and current redo log files are required to accomplish recovery
  B. Online and archived redo files are required to accomplish instance recovery
  C. All redo log entries after the last checkpoint are applied from redo log files to data files
  D. All redo log entries recorded in the current log file until the checkpoint position are applied to data files
  C. All redo log entries after the last checkpoint are applied from redo log files to data files