Oracle 1Z0-053 Online Practice Questions and Exam Preparation

Oracle 1Z0-053 Online Questions & Answers

• Question 51:

  You want to enable resumable space allocation at the instance level.

  Which two actions would enable resumable space allocation at the instance level? (Choose two.)

  A. issuing the ALTER SYSTEM ENABLE RESUMABLE; statement
  B. issuing the ALTER SESSION ENABLE RESUMABLE; statement
  C. modifying the RESUMABLE_TIMEOUT initialization parameter to a nonzero value
  D. issuing the ALTER SYSTEM SET RESUMABLE_TIMEOUT=; statement
  C. modifying the RESUMABLE_TIMEOUT initialization parameter to a nonzero value
  D. issuing the ALTER SYSTEM SET RESUMABLE_TIMEOUT=; statement

• Question 52:

  The INV_HISTORY table is created using the command:

  

  The following data has been inserted into the INV_HISTORY table:

  

  You would like to store the data belonging to the year 2006 in a single partition and issue the command:

  SQL> ALTER TABLE inv_history

  MERGE PARTITIONS

  FOR(TO_DATE('15-feb-2006','dd-mon-yyyy')),

  FOR(TO_DATE('15-apr-2006'))

  INTO PARTITION sys_py;

  What would be the outcome of this command?

  A. It executes successfully, and the transition point is set to '1-apr-2006'.
  B. It executes successfully, and the transition point is set to '15-apr-2006'.
  C. It produces an error because the partitions specified for merging are not adjacent.
  D. It produces an error because the date values specified in the merge do not match the date values stored in the table.
  C. It produces an error because the partitions specified for merging are not adjacent.

• Question 53:

  You performed the RMAN database backup having a backupset key number 231 with the KEEP FOREVER option. After some days, you want to change the status of the database backup and you issued the following command: RMAN>CHANGE BACKUPSET 231 NOKEEP; What is the implication of this command?

  A. The backup is deleted.
  B. The backup is marked unavailable.
  C. The backup overrides the backup retention policy.
  D. the backup becomes eligible for deletion according to the existing retention policy
  D. the backup becomes eligible for deletion according to the existing retention policy

• Question 54:

  Which statements describe the capabilities of the DBMS_NETWORK_ACL_ADMIN package? (Choose all that apply.)

  A. It can be used to allow the access privilege settings for users but not roles.
  B. It can be used to allow the access privilege settings for users as well as roles.
  C. It can be used to control the time interval for which the access privilege is available to a user.
  D. It can be used to selectively restrict the access for each user in a database to different host computers.
  E. It can be used to selectively restrict a user's access to different applications in a specific host computer.
  B. It can be used to allow the access privilege settings for users as well as roles.
  C. It can be used to control the time interval for which the access privilege is available to a user.
  D. It can be used to selectively restrict the access for each user in a database to different host computers.

• Question 55:

  In Oracle 11g, by default which one of the following conditions implicitly enables Automatic PGA Memory Management?

  A. Setting a nonzero value for SGA_TARGET
  B. Configuring Automatic Shared Memory Management
  C. Configuring Automatic Memory Management
  D. Setting a nonzero value for SGA_MAX_SIZE and PGA_AGGREGATE_TARGET
  E. None of the above
  B. Configuring Automatic Shared Memory Management

• Question 56:

  You want to analyze a SQL Tuning Set (STS) using SQL Performance Analyzer in a test database.

  Which two statements are true regarding the activities performed during the test execution of SQLs in a SQL Tuning Set? (Choose two.)

  A. Every SQL statement in the STS is considered only once for execution.
  B. The SQL statements in the STS are executed concurrently to produce the execution plan and execution statistics.
  C. The execution plan and execution statistics are computed for each SQL statement in the STS.
  D. The effects of DDL and DML are considered to produce the execution plan and execution statistics.
  A. Every SQL statement in the STS is considered only once for execution.
  C. The execution plan and execution statistics are computed for each SQL statement in the STS.

• Question 57:

  You want to perform an RMAN backup of database as a copy.

  Which two factors will you consider while performing the backup operation? (Choose two).

  A. The backup as copy can only be taken to disk
  B. The backup as copy can only be taken to tape
  C. Backup can be performed only when the instance is shutdown
  D. Backup will constitute all used and unused blocks in the database
  A. The backup as copy can only be taken to disk
  D. Backup will constitute all used and unused blocks in the database

• Question 58:

  Which of the following does the recover command not do?

  A. Restore archived redo logs.
  B. Apply archived redo logs.
  C. Restore incremental backups.
  D. Apply incremental backups.
  E. Restore datafile images.
  A. Restore archived redo logs.

• Question 59:

  Your database instance is running. You are not able to access Oracle Enterprise Manager Database Control because the listener is not started. Which tool or utility would you use to start the listener?

  A. Oracle Net Manager
  B. Listener Control utility
  C. Database Configuration Assistant
  D. Oracle Net Configuration Assistant
  B. Listener Control utility

• Question 60:

  What is the purpose of the RMAN recovery catalog? (Choose all that apply.)

  A. Make backups faster
  B. Store RMAN metadata
  C. Store RMAN scripts
  D. Provide the ability to do centralized backup reporting.
  E. Make recovery faster
  B. Store RMAN metadata
  C. Store RMAN scripts
  D. Provide the ability to do centralized backup reporting.