Oracle 1Z0-053 Online Practice Questions and Exam Preparation

Oracle 1Z0-053 Online Questions & Answers

• Question 271:

  Which statement describes the significance of the CHANGE FAILURE command in RMAN? (Choose all that apply.)

  A. It is used to change failure priority only for HIGH or LOW priorities.
  B. It is used to execute the advised repair script.
  C. It is used to change failure priority only for the CRITICAL priority.
  D. It is used to explicitly close the open failures.
  E. It is used to inform the database about the repair after the repair script executes.
  A. It is used to change failure priority only for HIGH or LOW priorities.
  D. It is used to explicitly close the open failures.

• Question 272:

  Identify two options that Oracle recommends while configuring the backup and recovery environment for your recovery catalog. (Choose two.)

  A. configuring control file autobackup to be ON
  B. backing up data filed only and not the archived redo log files
  C. running the recovery catalog database in NOARCHIVELOG mode.
  D. setting the retention policy to a REDUNDANCY value greater than 1
  E. backing up the recovery catalog to the same disk as that of the target database
  A. configuring control file autobackup to be ON
  D. setting the retention policy to a REDUNDANCY value greater than 1

• Question 273:

  Which option is best practice for creating a recovery catalog owner in the catalog database?

  A. Granting UNLIMITED QUOTA on the SYSTEM tablespace to the owner
  B. Allocating the SYSTEM tablespace as the default tablespace and granting the SYSDBA privilege to the user
  C. Creating a new tablespace, allocating this as the default, and granting UNLIMITED QUOTA on this tablespace to the user
  D. Allocating the SYSAUX tablespace as the default tablespace and granting UNLIMITED QUOTA on this tablespace to the user
  C. Creating a new tablespace, allocating this as the default, and granting UNLIMITED QUOTA on this tablespace to the user

• Question 274:

  Which are the correct steps, in order, to deal with the loss of an online redo log if the database has not yet crashed?

  a: Issue a checkpoint.

  b: Shut down the database.

  c: Issue an alter database open command to open the database.

  d: Startup mount the database.

  e: Issue an alter database clear logfile command.

  f:

  Recover all database datafiles.

  A. a, b, c, d
  B. b, d, e, c
  C. a, b, d, e, c
  D. b, f, d, f, c
  E. b, d, a, c
  C. a, b, d, e, c

• Question 275:

  Examine the following command:

  SQL> ALTER TABLE booking SHRINK SPACE COMPACT;

  Which activity is performed when the preceding command is executed?

  A. The shrink operation touches every block in the BOOKING table
  B. The high-water mark (HWM) for the BOOKING table is shifted from its original position
  C. The progress of the shrink operation is saved in the bitmap blocks of the BOOKING table
  D. The data manipulation language (DML) triggers on the BOOKING table are executed because the shrink operation is internally handled by the INSERT/DELETE operation
  C. The progress of the shrink operation is saved in the bitmap blocks of the BOOKING table

• Question 276:

  Which background process of a database instance, using Automatic Storage Management (ASM), connects as a foreground process into the ASM instance?

  A. ASMB
  B. PMON
  C. RBAL
  D. SMON
  A. ASMB

• Question 277:

  You installed Oracle Database 11g at fresh.

  Which statements are true regarding the default audit settings in this database? (Choose all that apply.)

  A. The audit trail is stored in an operating system file.
  B. Auditing is disabled for all privileges.
  C. The audit trail is stored in the database.
  D. Auditing is enabled for all privileges.
  E. Auditing is enabled for certain privileges related to database security.
  C. The audit trail is stored in the database.
  E. Auditing is enabled for certain privileges related to database security.

• Question 278:

  Which three statements are true about windows? (Choose three.)

  A. Only one window can be open at any given time
  B. Consumer groups are associated with windows
  C. Windows work with job classes to control resource allocation
  D. The database service name must be provided during windows creation
  E. Windows can automatically start job or change resource allocation among jobs for various time periods.
  A. Only one window can be open at any given time
  C. Windows work with job classes to control resource allocation
  E. Windows can automatically start job or change resource allocation among jobs for various time periods.

• Question 279:

  You have lost datafiles 1 and 3 from your database, and the database has crashed. In what order should you perform the following steps to recover your database?

  1.

  Take the datafiles that were lost offline.

  2.

  startup mount the database

  3.

  Issue the alter database open command.

  4.

  Restore the datafiles that were lost

  5.

  Recover the datafiles with the recover datafile command.

  6.

  Bring the datafiles back online.

  7.

  Recover the database with the recover database command.

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

• Question 280:

  View the Exhibit1 to examine the series of SQL commands. View the Exhibit2 to examine the plans available in the SQL plan baseline. The baseline in the first row of the Exhibit is created when OPTIMIZER_MODE was set to FIRST_ROWS.

  Which statement is true if the SQL query in exhibit1 is executed again when the value of OPTIMIZER_MODE is set to FIRST_ROWS?

  

  parameter-optimizer (exhibit):

  

  A. The optimizer uses a new plan because none of the plans in the exhibit2 are fixed plans.
  B. The optimizer uses the plan in the second row of the exhibit2 because it is an accepted plan.
  C. The optimizer uses the plan in the first row of the exhibit2 because it is the latest generated plan.
  D. The optimizer uses the plan in the first row of the exhibit2 because OPTIMIZER_MODE was set to FIRST_ROW during its creation.
  B. The optimizer uses the plan in the second row of the exhibit2 because it is an accepted plan.