Oracle 1Z0-053 Online Practice Questions and Exam Preparation

Oracle 1Z0-053 Online Questions & Answers

• Question 101:

  Your ARCHIVELOG mode database has lost three datafiles and shut down. One is assigned to the SYSTEM tablespace and two are assigned to the USERS tablespace. You can choose from the following steps to recover your database:

  a: Restore the three database datafiles that were lost.

  b: Issue the Startup Mount command to mount the database.

  c: Issue the alter database open command.

  d: Issue the alter database open resetlogs command.

  e: Recover the database using the recover database command.

  f: Recover the datafiles with the recover datafile command.

  g:

  Take the datafiles offline.

  Which is the correct order of these steps in this case?

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

• Question 102:

  What view would you use to determine if a given tablespace is fully self-contained for the execution of a tablespace point-in-time recovery?

  A. TS_CHECK
  B. TPITR_CHECK
  C. TS_PITR_CHECK
  D. CHECK_TSPITR
  E. PITR_TS_CHECK
  C. TS_PITR_CHECK

• Question 103:

  Which mode of database shutdown requires an instance recovery at the time of the next database startup?

  A. ABORT
  B. NORMAL
  C. IMMEDIATE
  D. TRANSACTIONAL
  A. ABORT

• Question 104:

  To control the execution of a server process when it is receiving bad packets from a potentially malicious client, you set the SEC_PROTOCOL_ERROR_FURTHER_ACTION initialization parameter as follows: SQL> ALTER SYSTEM SET SEC_PROTOCOL_ERROR_FURTHER_ACTION = Drop,10;

  What is the significance of this setting?

  A. It terminates the client connection after 10 bad packets and the client cannot reconnect to the same instance.
  B. It terminates the client connection after 10 bad packets but the client can still reconnect, and attempt the same operation again.
  C. It terminates the client connection 10 seconds after receiving a bad packet and the client cannot reconnect to the same instance.
  D. It terminates the client connection after receiving a bad packet and the client can reconnect to the same instance after 10 minutes.
  B. It terminates the client connection after 10 bad packets but the client can still reconnect, and attempt the same operation again.

• Question 105:

  Given the following steps, which would be the correct order to create a backup of an Oracle database in NOARCHIVELOG mode?

  7.

  shutdown immediate from RMAN

  8.

  Log into RMAN

  9.

  startup mount from RMAN 10.backup database 11.alter database open 12.backup database plus archivelog delete input

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

• Question 106:

  Users notify you that their application is failing every time they try to add new records. Because of poor application design, the actual ORA error message is unavailable. What might be the problem? (Choose the best answers.)

  A. The application user has exceeded their undo quota.
  B. The FLASHBACK GUARANTEE option is set on the undo tablespace.
  C. The table is currently being queried by a Flashback Transaction Query operation.
  D. The table is currently being queried by a Flashback Versions Query operation.
  E. The RETENTION GUARANTEE option is set on the undo tablespace.
  A. The application user has exceeded their undo quota.

• Question 107:

  You plan to set up the Automatic Workload Repository (AWR) baseline metric thresholds for a moving window baseline. Which action would you take before performing this task?

  A. Compute the baseline statistics.
  B. Take an immediate AWR snapshot.
  C. Decrease the window size for the baseline.
  D. Decrease the expiration time for the baseline.
  A. Compute the baseline statistics.

• Question 108:

  A database has three online redo log groups with one member each. A redo log member with the status ACTIVE is damages while the database is running. What is the first step you should take to solve this problem?

  A. Attempt to Issue a checkpoint.
  B. Restart the database using the RESETLOGS option.
  C. Drop the redo log number and create it in a different location.
  D. Perform and incomplete recovery up to the most recent available redo log.
  A. Attempt to Issue a checkpoint.

• Question 109:

  View the Exhibit and examine the RMAN commands.

  

  Which statement describes the effect of a backup retention policy on the backup of a backup set?

  A. Either all the copies of a backup set are obsolete or none of them are as per the retention policy.
  B. The copies of the backup will be reported as obsolete under a redundancy-based backup retention policy.
  C. The copies of the backup will be reported as obsolete under a recovery window-based backup retention policy.
  D. All the copies of the backup set are counted as one instance of a backup and will deleted in backup set exceeds the redundancy-based backup retention policy.
  A. Either all the copies of a backup set are obsolete or none of them are as per the retention policy.

• Question 110:

  You have control-file autobackups enabled. When starting your database from SQL*Plus, you receive the following error message:

  SQL> startup ORA-01078: failure in processing system parameters LRM-00109: could not open parameter file 'C:\ORACLE\PRODUCT\11.1.0\DB_1\DATABASE \INITORCL.ORA'

  Using RMAN, how would you respond to this error?

  A. Issue the startup nomount command and then issue the restore parameter file command from the RMAN prompt.
  B. Issue the startup nomount command and then issue the restore spfile command from the RMAN prompt.
  C. Issue the startup nomount command and then issue the restore spfile from autobackup command from the RMAN prompt.
  D. Issue the startup nomount command and then issue the restore spfile from backup command from the RMAN prompt.
  E. Issue the restore spfile from autobackup command from the RMAN prompt.
  C. Issue the startup nomount command and then issue the restore spfile from autobackup command from the RMAN prompt.