Free Oracle 1Z0-035 Exam Dumps Questions & Answers

What is true if you want to switch undo tablespaces from the current one, called UNDO1, to a new one called UNDO2?

• A.  It is possible to switch to UNDO2; current active transactions will be automatically migrated to UNDO2.
• B.  It is NOT possible to switch unless no active transaction exists in UNDO1.
• C.  It is possible to switch to UNDO2; only current active transactions will continue to execute inside UNDO1.
• D.  It is possible to switch to UNDO2, but current active transactions will abort.

You need to add a column to a table that holds updateable image data. Which data type should you use for this column?

• A.  BFILE
• B.  BLOB
• C.  LOBFILE
• D.  CLOB

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?

• A.  Take the individual data file offline (not the whole tablespace), restore and recover the data file from backup with RMAN, then set the data file online again.
• B.  Rebuild the index using the online option.
• C.  Take the individual data file (not the whole tablespace) offline, use RMAN with Block Media Recovery to restore and recover only those blocks, then set the data file online again.
• D.  Without setting the individual data file offline, use RMAN with Block Media Recovery to restore and recover only those blocks.

Which two statements about optimizer plan stability are true? (Choose two.)

• A.  Profiles specify the user's default category.
• B.  Data dictionary statistics are ignored when creating a stored outline.
• C.  Data dictionary statistics are ignored when using a stored outline.
• D.  Categories allow different stored outlines for the same SQL statement.

What can you see when querying V$LOGMNR_CONTENTS?

• A.  the SQL statement run, and the old image
• B.  the old image and the new image of the row that was modified
• C.  the SQL statement run, and the relevant undo SQL statement
• D.  the SQL statement run, and the new image
• E.  only the redo generated by the current schema