Oracle Oracle Certifications 1Z0-053 Questions & Answers

• Question 311:

  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.

  Correct Answer: A

• Question 312:

  Which of the following statements best describes Flashback Versions Query?

  A. Flashback Versions Query is used to make changes to multiple versions of data that existed between two points in time.

  B. Flashback Versions Query is used to view all version changes on rows that existed between the time the query was executed and a point in time in the past.

  C. Flashback Versions Query is used to view version changes and the SQL to undo those changes on rows that existed between two points in time.

  D. Flashback Versions Query is used to view all version changes on rows that existed between two points in time.

  Correct Answer: D

• Question 313:

  Which pseudocolumn could you use to identify a unique row in a Flashback Versions Query?

  A. XID

  B. VERSIONS_PK

  C. VERSIONS_XID

  D. VERSIONS_UNIQUE

  Correct Answer: C

• Question 314:

  Which of the following can be used in conjunction with a Flashback Versions Query to filter the results? (Choose all that apply.)

  A. A range of SCN values

  B. A list of SCN values

  C. A starting and ending timestamp

  D. Minimum and maximum sequence values

  E. A list of sequence values

  Correct Answer: AC

• Question 315:

  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.

  Correct Answer: C

• Question 316:

  Which of the following statements is true regarding the VERSIONS BETWEEN clause?

  A. The VERSIONS BETWEEN clause may be used in DML statements.

  B. The VERSIONS BETWEEN clause may be used in DDL statements.

  C. The VERSIONS BETWEEN clause may not be used to query past DDL changes to tables.

  D. The VERSIONS BETWEEN clause may not be used to query past DML statements to tables.

  Correct Answer: C

• Question 317:

  You executed the following commands in a database session:

  

  Which statement is true about the contents of the recycle bin in this situation?

  A. They remain unaffected.

  B. They are moved to flashback logs.

  C. They are moved to the undo tablespace.

  D. They are moved to a temporary tablespace.

  E. The objects in the recycle bin that are in the default tablespace for the session user are cleaned up.

  Correct Answer: E

• Question 318:

  Which method could be utilized to identify both DML operations and the SQL statements needed to undo those operations for a specific schema owner? (Choose all that apply.)

  A. Query DBA_TRANSACTION_QUERY for TABLE_NAME, OPERATION, and UNDO_SQL. Limit rows by START_SCN and TABLE_OWNER.

  B. Query FLASHBACK_TRANSACTION_QUERY for TABLE_NAME, OPERATION, and UNDO_SQL. Limit rows by START_SCN and TABLE_OWNER.

  C. Query FLASHBACK_TRANSACTION_QUERY for TABLE_NAME, OPERATION, and UNDO_SQL. Limit rows by START_TIMESTAMP and TABLE_OWNER.

  D. Query DBA_TRANSACTION_QUERY for TABLE_NAME, OPERATION, and UNDO_SQL. Limit rows by START_TIMESTAMP and TABLE_OWNER.

  Correct Answer: BC

• Question 319:

  The _______ writes the Flashback Database logs in the flash recovery area.

  A. FLSH

  B. FLDB

  C. RVWR

  D. RVRW

  E. FBDA

  Correct Answer: C

  RVWR (Recovery Writer Process), Writes flashback data to the flashback logs in the fast recovery area RVWR writes flashback data from the flashback buffer in the SGA to the flashback logs. RVWR also creates flashback logs and performs some tasks for flashback log automatic management. Existed in Database instance, Flashback Database FBDA (Flashback Data Archiver Process), Archives historical rows for tracked tables into flashback data archives and manages archive space, organization, and retention When a transaction that modifies a tracked table commits, FBDA stores the pre-image of the rows in the archive. FDBA maintains metadata on the current rows and tracks how much data has been archived.

  FBDA is also responsible for automatically managing the flashback data archive for space, organization (partitioning tablespaces), and retention. FBDA also keeps track of how far the archiving of tracked transactions has progressed.

  See Also: Oracle Database Advanced Application Developer's Guide Existed in Database and ASM instances

• Question 320:

  AUM (Automatic UNDO Management) has been retaining about 15 minutes worth of undo. You want to double the retention period, but not at the expense of new transactions failing. You decide to alter the system to set the parameter UNDO_RETENTION=18000. However, AUM still retains only about 15 minutes worth of undo.

  What is the problem? (Choose the best answer.)

  A. You need to alter the undo tablespace to add the RETENTION GUARANTEE setting.

  B. You need to increase the size of the undo tablespace.

  C. The undo tablespace is not set to auto-extend.

  D. You need to alter the Recycle Bin to add the RETENTION GUARANTEE setting.

  Correct Answer: C