Oracle 1z0-032: Oracle 9i: Database Fundamentals II
#41. 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 Oracle 9i, 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 steam would be lost. Oracle 9i changes that with the Trial Recovery feature. Trial Recover is used to test the application of the redo logs to the database. What are three other characteristics of Trial Recovery (Choose three)
#43. The database was started up using a text parameter file. What will be the default scope of changes made by using the SET clause of the ALTER SYSTEM statement?
#44. You plan to take a closed database backup using operating system commands. Which three SHUTDOWN options are appropriate for this type of backup? (Choose three)
#46. In a dedicated sever configuration, which two statements describe the actions that can be taken to complete a client/server connection when the client and server are NOT on the same computer? (Choose two)
#47. A user is running a long update batch file. Many tables are updated and all the statements are in one transaction. Before the process is finished, the user machine lost power. When the user calls you, what should you do as DBA?
#49. Your database is running in NOARCHIVE LOG mode. Every night there is a backup taken using RMAN. During your startup this morning you received en error regarding DISK 3 on your server. This is the location of your data file for the SYSTEM table space. Which option is open to you?
#50. The multithreaded agent architecture for heterogeneous services is similar to the Oracle multithreaded server architecture. The principal difference is that it used threads instead of processes. What are thee kinds of threads that it uses? (Choose three)
gen. 0.111
Forum
Master braindump