Oracle 1Z0-030: Oracle 9i: New Features For Administrators
#21. You decide to activate the resumable space allocation feature for all your database users by enabling the feature in a logon trigger. This causes a statement that requires space beyond a user's quota ___________.
#24. Your company has four DBAs. You need to know which DBA added a column to the JOB_HISTORY table. The database cannot be offline during work hours. Which LogMiner command can you use to find out which user made the table change?
#25. The Oracle9i LogMiner needs a data dictionary copy to display the object names. From which three locations can LogMiner retrieve the data dictionary information? (Choose three.)
#26. Media recovery can sometimes be stopped by the inability to read past a certain point in the redo stream. This is often referred to as "stuck recovery." Before Oracle9i, the Database Administrator had few options to deal with stuck recovery. If the corrupt redo could not be recovered from some other source, then all transactions that committed after the corrupt point in the redo stream would be lost. Oracle9i changes that with the Trial Recovery feature. Trial Recovery is used to test the application of the redo logs to the database. What are three other characteristics of Trial Recovery? (Choose three.)
gen. 0.066
Forum
Master braindump