Quiz 1z0-042

Quiz 1z0-042, Database 10g Administration I

Which three pieces of information are considered while deciding the size of the undo tablespace in your database?

Which two statements are true?

What would be your suggestion to receive recommendations on the efficient use of indexes and materialized views to improve query performance?

Which combination of triggering time and event would you use to achieve this objective?

You issued this command to change the value of the LOG_BUFFER initialization parameter:ALTER SYSTEM SET LOG_BUFFER=24M SCOPE=BOTH;What would be the outcome of this command?

Which type of script does the backup scheduler generate?

Which file is used by the Oracle database server to authenticate APP_DBA?

What is the best method to create the replica?

Data files of which three tablespaces can be recovered by performing an open recovery?

Which two operations can be flashed back using the Flashback technology?