Oracle 1Z0-030: Oracle 9i: New Features For Administrators
#31. Users complain that SQL statements using a particular index fail. Using DBVERIFY, you find that two separate blocks in the index have become corrupt. The database data files for user data and index are very large. What is the least disruptive recovery strategy available in Oracle9i?
#33. When adding a new master site in an Advanced Replication environment without quiescing replication activity, you can instantiate the database at the new master site by using one of two methods. Which two methods can be used to perform this step? (Choose two.)
#36. Which three attributes of the LOG_ARCHIVE_DEST_n initialization parameter control the data availability mode of a Data Guard standby database? (Choose three.)
#39. Examine the extract from a SQL*Plus session. Assuming that there is at least one row for each value shown in the HIGH VALUE column, what is the result of the ALTER TABLE statement?