6.9. Review Questions

  1. Which underlying database technology is used by Flashback Drop, Flashback Table, and Flash back Versions Query to recover data?

    1. Redo logs

    2. Rollback segments

    3. Undo data

    4. Archive logs

  2. Which of the following statements is true regarding the Recycle Bin? (Choose all that apply.)

    1. The Recycle Bin is a physical storage area of flashback dropped objects.

    2. The Recycle Bin is a logical container area of flashback dropped objects.

    3. The objects in the Recycle Bin are stored in the UNDO tablespace.

    4. The objects in the Recycle Bin are stored in the tablespace they were created in.

  3. What actions does the Flashback Drop process perform?

    1. Back up table only

    2. Back up table and indexes only

    3. Back up table and referential constraints only

    4. Back up table and dependent objects

  4. Which activity can occur with the Recycle Bin?

    1. All indexed-organized tables are protected by the Recycle Bin.

    2. System- and dictionary-managed tablespaces are stored in the Recycle Bin.

    3. Dependent objects of stored tables—including referential constraints—are stored in the Recycle Bin.

    4. Data Manipulation Language (DML) and Data Definition Language (DDL) can be run against objects in the Recycle Bin.

    5. None of the above.

  5. One method of dropping objects and bypassing the Recycle Bin is to perform which command?

    1. DROP USER user CASCADE

    2. DROP TABLE

    3. DROP TABLE INCLUDING CONTENTS

    4. DROP USER user

  6. Which command is responsible for removing the objects in multiple users from the Recycle Bin?

    1. PURGE RECYCLEBIN

    2. PURGE TABLESPACE user

    3. PURGE DBA_RECYCLEBIN

    4. PURGE TABLES user

  7. What is the naming convention of a Recycle Bin object?

    1. BIHSglobalUIDSversion

    2. BIHSglobalSUIDversion

    3. BIHSglobalUIDversion

    4. BIHglobalUIDversion

  8. What two methods can be used to view the Recycle Bin?

    1. Run the SHOW RECYCLEBIN command.

    2. Query the view DBA_RECYCLEBIN.

    3. Query the view VSRECYCLEBIN.

    4. Query the view RECYCLEBIN.

  9. What best describes the space pressure in the Recycle Bin?

    1. No free extents in the Recycle Bin, and objects being removed from the Recycle Bin to free up extents for non-Recycle Bin objects.

    2. No free extents in a tablespace, and objects being removed from the Recycle Bin to free up extents for non-Recycle Bin objects.

    3. No free extents in a tablespace, and objects being removed from the Recycle Bin to free up extents in a tablespace for non-Recycle Bin objects on a first in, first out (FIFO) basis.

    4. No free extents in the Recycle Bin tablespace and objects being removed from Recycle Bin tablespace to free up extents for non-Recycle Bin objects on a first in, first out (FIFO) basis.

  10. If a tablespace is configured for AUTO EXTEND, what will occur when there are no free extents and there are objects in the AUTO EXTEND tablespace?

    1. The tablespace will autoextend to make more free space and Oracle will not remove Recycle Bin objects associated with the tablespace.

    2. The tablespace will not autoextend, and objects in the Recycle Bin will be removed to make space in the tablespace.

    3. The tablespace will autoextend to make more free space and Oracle will remove Recycle Bin objects associated with the tablespace.

    4. The tablespace will not autoextend, and objects in the Recycle Bin will be compressed to make space in the tablespace.

  11. Which of the following statements best describes Flashback Versions Query?

    1. Flashback Versions Query is a query to perform diagnostics on version changes in row data on rows that existed between the times the query was executed to a determined point-in-time in the past.

    2. Flashback Versions Query is a method of querying all version changes on rows that existed between the times the query was executed to a determined point-in-time in the past.

    3. Flashback Versions Query is a query to perform diagnostics on table changes in row data on rows that existed between the times the query was executed to a determined point-in-time in the past.

    4. Flashback Versions Query is a method of querying all version changes on rows that existed between the times the query was executed to a determined point-in-time in the future.

  12. What view can be used to query diagnostic information about transactional changes in the database?

    1. FLASHBACK_TRANSACTION_QUERY

    2. DBA_TRANSACTION_QUERY

    3. V$TRANSACTION_QUERY

    4. V$FLASHBACK_TRANSACTION_QUERY

  13. What are the methods of performing a Flashback Versions Query? (Choose all that apply.)

    1. Flashback Versions Query can be performed by minimum and maximum SCN value.

    2. Flashback Versions Query can be performed by minimum and maximum sequence number.

    3. Flashback Versions Query can be performed by starting and ending timestamp.

    4. Flashback Versions Query can be performed by minimum and maximum undo value.

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

    1. The VERSIONS BETWEEN clause only supports SCN.

    2. The VERSIONS BETWEEN clause only supports log sequences.

    3. The VERSIONS BETWEEN clause cannot produce versions past modifications to the table structure.

    4. The VERSIONS BETWEEN clause can produce versions past Data Definition Language (DDL) changes to an object.

  15. Which pseudocolumn do you use to identify a unique row in a Flashback Versions Query?

    1. VERSIONS_XID

    2. BVERSIONS_OPERATION

    3. VERSIONS_ENDTIME

    4. VERSION_STARTTIME

  16. Which of the following statements are true regarding the VERSIONS BETWEEN clause? (Choose all that apply.)

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

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

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

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

  17. Which of the following statements is true regarding implementing a Flashback Table recovery?

    1. SCN is never needed to perform a Flashback Table recovery.

    2. ROW MOVEMENT must be enabled to perform a Flashback Table recovery.

    3. Only one table may be recovered to perform a Flashback Table recovery.

    4. Flashback Table recovery does not use undo data to perform a Flashback Table recovery.

  18. What happens to enabled triggers on a table after a FLASHBACK TABLE command is performed? (Choose all that apply.)

    1. The triggers are disabled by default.

    2. The triggers are enabled by default.

    3. Disabled triggers remain disabled with the default FLASHBACK TABLE command.

    4. All triggers are enabled if the ENABLE TRIGGER clause is used.

  19. What method can you use to identify a DML operation and the SQL statement that has been performed against a row in a specific table for a schema owner? (Choose all that apply.)

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

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

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

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

  20. How can you protect the amount of time you can query information from the Flashback Transaction Query?

    1. Add UNDO GUARANTEE to the UNDO tablespace.

    2. Add RETENTION GUARANTEE to the UNDO tablespace.

    3. Add RETENTION GUARANTEE to the Recycle Bin logical storage container.

    4. Add UNDO GUARANTEE to the Recycle Bin logical storage container.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset