Quiz 1z0-043

Quiz 1z0-043, Database 10g: Administration II

What is the purpose of this instance?

What is the best table structure that you can use to gain optimal performance?

Which two backups would you be able to perform when the database is being accessed by users?

b) The operation takes the minimum possible timeWhich option would you choose?

Which condition should be met to drop a redo log file?

Which type of PL/SQL construct would you use to automatically correct the error resulting from a statement that was suspended due to a space-related problem?

Which component stores these statistics?

While designing the database for one of your online transaction processing (OLTP) applications, you want to achieve the following:a) high availability of datab) faster primary key access to the table datac) compact storage for the tableWhich type of tables would you use to achieve these objectives?

Why is %r used in the file name format?

You executed the following query in your database:SELECT oldest_flashback_scn, oldest_flashback_time FROM V$FLASHBACK_DATABASE_LOG;What would you determine from the output?