Oracle 1Z0-053 Online Practice Questions and Exam Preparation

Oracle 1Z0-053 Online Questions & Answers

• Question 71:

  Which statement is true about a Scheduler-generated event?

  A. It can be generated when a file arrives on the file system.
  B. it indicates state changes that occur within the Scheduler itself.
  C. it is raised by an application that is consumed by the Scheduler to start a job.
  D. it requires jobs to be defined with an event condition and a queue specification.
  D. it requires jobs to be defined with an event condition and a queue specification.

• Question 72:

  Which of the following is NOT an advantage of block media recovery (BMR)?

  A. Reduced MTTR.
  B. Datafiles remain offline while corrupt blocks are repaired.
  C. Datafiles remain online while corrupt blocks are repaired.
  D. A and C
  B. Datafiles remain offline while corrupt blocks are repaired.

• Question 73:

  David managed to accidentally delete the datafiles for database called DSL. He called Heber and Heber tried to help but he managed to delete the control files of the database. Heber called Bill and Bill saved the day.

  They are using a recovery catalog for this database.

  What steps did Bill perform to recover the database and in what order?

  a.

  Restored the control file with the RMAN restore controlfile command.

  b.

  Mounted the DSL instance with the alter database mount command.

  c.

  Restored the datafiles for the DSL database with the RMAN restore command.

  d.

  Opened the DSL database with the alter database open resetlogs command.

  e.

  Recovered the datafiles for the DSL database with the RMAN recover command.

  f.

  Started the DSL instance.

  g.

  Connected to the recovery catalog with RMAN.

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

• Question 74:

  Evaluate the following command:

  SQL> CREATE TABLE design_data (id NUMBER,

  doc CLOB)

  LOB(doc) STORE AS SECUREFILE(DEDUPLICATE);

  Which statement is true regarding the above command?

  A. The LOB values are automatically compressed.
  B. The LOB values are cached by default in the buffer cache.
  C. The LOB values are automatically stored in encrypted mode.
  D. All LOB data that is identical in two or more rows in a LOB column share the same data blocks.
  D. All LOB data that is identical in two or more rows in a LOB column share the same data blocks.

• Question 75:

  The database is configured in ARCHIVELOG mode and regular complete database backups are taken. The loss of which two types of files may require a recovery with the RESETLOGS option? (Choose two)

  A. Control files
  B. Password files
  C. Inactive online redo log file
  D. Archived log files required to perform recovery
  E. Newly created tablespace which is not backed up
  A. Control files
  D. Archived log files required to perform recovery

• Question 76:

  Which statement about using RMAN stored scripts is true?

  A. To create and execute an RMAN stored script, you must use a recovery catalog.
  B. When executing a stored script and a command fails, the remainder of the script is executed, and a message is written to the alert log file.
  C. RMAN stored scripts can always be executed against any target database that is registered in the recovery catalog.
  D. When you execute a stored script, it always executes using the persistent channel settings previously set with the CONFIGURE command.
  A. To create and execute an RMAN stored script, you must use a recovery catalog.

• Question 77:

  You have backed up your database twice without connecting to the recovery catalog.

  What command do you issue to transfer the control-file metadata to the recovery catalog?

  A. synch catalog
  B. resync catalog
  C. replicate catalog
  D. update catalog
  E. restore catalog
  B. resync catalog

• Question 78:

  At the request of a user, you issue the following command to restore a dropped table:

  SQL> flashback table "BIN$F2JFfMq8Q5unbC0ceE9eJg==$0" to before drop;

  Later, the user notifies you that the data in the table seems to be very old and out of date.

  What might be the problem?

  A. Because a proper range of SCNs was not specified, the wrong data was restored.
  B. A proper range of timestamps was not specified, so the wrong data was restored.
  C. A previous Flashback Drop operation had been performed, resulting in multiple versions of the table being stored in the Recycle Bin.
  D. Either option A or B could be correct. Not enough information was provided to determine which.
  E. None of the above.
  C. A previous Flashback Drop operation had been performed, resulting in multiple versions of the table being stored in the Recycle Bin.

• Question 79:

  If you lost your entire database, including the database spfile, control files, online redo logs, and database datafiles, what kind of recovery would be required with RMAN?

  A. Complete database recovery.
  B. Incomplete database recovery.
  C. Approximate database recovery.
  D. Archived database recovery.
  E. The database could not be recovered with RMAN.
  B. Incomplete database recovery.

• Question 80:

  Which of these recommendations should be followed before capturing a workload? (Choose all that apply.)

  A. Make sure your replay database has the same structure as the capture database, except without data.
  B. Make sure the replay and capture databases are similar in data content.
  C. Perform a clean shutdown and restart of the capture database before beginning a workload capture.
  D. Start the capture database in UNRESTRICTED mode, then start the capture.
  E. Define inclusion and exclusion filters.
  B. Make sure the replay and capture databases are similar in data content.
  C. Perform a clean shutdown and restart of the capture database before beginning a workload capture.