Operations flashed back using Flashback technology - Oracle Tablespaces

Q.  Which two operations can be flashed back using the Flashback technology?
- Published on 04 Aug 15

a. DROP USER SACHIN;
b. DROP TABLE STUDENTS;
c. DROP TABLESPACE USERS;
d. BOTH A & C
e. BOTH A & B

ANSWER: BOTH A & B
 

    Discussion

  • Nirja Shah   -Posted on 31 Aug 15
    - Oracle Flashback Technology is a group of Oracle Database features that that let you view past states of database objects or to return database objects to a previous state without using point-in-time media recovery.

    - With flashback features, you can do the following:

    1. Perform queries that return past data
    2. Perform queries that return metadata that shows a detailed history of changes to the database
    3. Recover tables or rows to a previous point in time
    4. Automatically track and archive transactional data changes
    5. Roll back a transaction and its dependent transactions while the database remains online.

Post your comment / Share knowledge


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)