| Exam Code/Number: | 1Z0-035Join the discussion |
| Exam Name: | Oracle9i dba new features for Oracle7.3 and Oracle9 ocps |
| Certification: | Oracle |
| Question Number: | 168 |
| Publish Date: | Dec 15, 2025 |
|
Rating
100%
|
|
What is true if you want to switch undo tablespaces from the current one, called UNDO1, to a new one called UNDO2?
You need to add a column to a table that holds updateable image data. Which data type should you use for this column?
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?
Which two statements about optimizer plan stability are true? (Choose two.)