Oracle DBA 11g Chapter 19 Study Questions

Which of the following commands is not necessary for a Flashback Database operation? (Choose all that apply.) Alter database open readonly Alter database open resetlogs Flashback database to . . . Recover database until . . . Shutdown Startup mount

Alter database open readonly Recover database until . . .

Which of these operations cannot be executed against a table for which archiving has been enabled? (Choose all correct answers.) DROP TRUNCATE Add a column Drop a column None of the above

DROP TRUNCATE Drop a column

What tool(s) can be used to perform a database flashback?

Database Control and RMAN

Which process is responsible for writing before-images of rows to a Flashback Data Archive?

FBDA, Flashback Data Archiver Process

What is the best technique to flash back two tables in a foreign key relationship?

Flash back the both tables in one operation.

Why and when must you enable row movement on a table before a flashback operation?

Flashback Table requires row movement, because any affected rows may be moved as the changes are reversed.

A user error has occurred, but the effects are limited to one tablespace. You want to flash back this one tablespace, but not the others. What must you do?

It is not possible to flash back one tablespace and leave the rest of the database current.

What state must the database be in to turn on the Flashback Database feature?

Mount

Under which of the following circumstances will Flashback Drop work? When a table has been truncated When a table has been purged When a user has been dropped When an index has been dropped None of the above

None of the above

After dropping a table, how can you access the rows within it?

Query the table using its recycling bin name

You have enabled Flashback Database, but you suspect that flashback logging is impacting adversely on performance. What could you do?

Stop flashback logging for some tablespaces.

When you drop a table, what objects will go into the recycle bin? (Choose two answers.)

The Table Indexes on the table

You have set the DB_FLASHBACK_RETENTION_TARGET to one day, but the flash recovery area does not have room for this much flashback data. What will happen?

The database will continue to function, but flashback operations may fail

If a Flashback Table operation violates a constraint, what will happen?

The flashback operation will be rolled back

There are two tables in the recycle bin with the same original name. What will happen if you issue a FLASHBACK TABLE <original_name> TO BEFORE DROP command?

The newest recycle bin table will be recovered

Under which of these circumstances might Flashback Database be of use? (Choose the best answer.) To recover a dropped table To recover a dropped schema To recover a damaged datafile To reverse a bad transaction All of the above

To recover a dropped schema

Why is archive log mode required to enable Flashback Database?

To recover to an exact time after flashback

If a table has been dropped and then another table created with the same name, which of the following statements is correct? (Choose two answers.) You can rename the new table, before you flash back the dropped one. You can flash back the dropped table, if you specify a new name for it. You can flash back the dropped table into a different schema. You must drop the new table before flashing back the old one.

You can rename the new table, before you flash back the dropped one. You can flash back the dropped table, if you specify a new name for it.

Which of the following is correct about Flashback Database? (Choose two correct answers.) You should set the FLASHBACK_BUFFER_SIZE parameter. You must create the flashback log files. You must set the DB_RECOVERY_FILE_DEST parameter. You must issue ALTER SYSTEM FLASHBACK ON. You must issue ALTER DATABASE FLASHBACK ON.

You must set the DB_RECOVERY_FILE_DEST parameter. You must issue ALTER DATABASE FLASHBACK ON.