单项选择题
You have joined a new organization as a Database Administrator. The Security Administrator in your organization has kept human errors, such as erroneously dropping users, tables, and important data, to a minimum by carefully granting only the necessary privileges to each user. As a result of several ongoing transactions within your database, you discover that the flashback logs are rapidly increasing in the flash recovery area. To avoid out-of-space errors, you decide to delete the flashback logs from the flash recovery area. How can you delete the flashback logs from the database if your database is up and running?()
A. Shut down the database using the SHUTDOWN command. Mount the database using the STARTUP MOUNT EXCLUSIVE command and disable Flashback Database using the ALTER DATABASE FLASHBACK OFF statement.
B. Change the parameter setting in the SPFILE for the DB_RECOVERY_FILE_DEST parameter using the ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=’’ SCOPE=BOTH statement while the database is up and running.
C. Shut down the database using the SHUTDOWN command. Mount the database using the STARTUP MOUNT EXCLUSIVE command. Change the parameter setting in the SPFILE for the DB_RECOVERY_FILE_DEST parameter using the ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=’’ SCOPE=BOTH statement. Disable Flashback Database using the ALTER DATABASE FLASHBACK OFF statement.
D. Change the parameter setting in the SPFILE for the DB_RECOVERY_FILE_DEST parameter using the ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=’’ SCOPE=BOTH statement. Shut down the database using the SHUTDOWN command. Mount the database using the STARTUP MOUNT EXCLUSIVE command and disable Flashback Database using the ALTER DATABASE FLASHBACK OFF statement.
相关考题
-
单项选择题
InwhichscenariodoyouusetheFlashbackDatabasefeature?()
A. when a table is dropped and you restore it from the Recycle Bin
B. when a user’s schema is dropped and you recover the user’s schema
C. when some incorrect data is inserted in the table and you retrieve the table to a state that was at a certain timestamp
D. when a row of a table is updated frequently and committed, and you view all the versions of the row within a specific duration -
单项选择题
An important tablespace of your database is dropped by mistake. You use the Flashback Database feature to retrieve the tablespace. You perform the following steps to retrieve the tablespace: 1. You log on to Enterprise Manager as SYSDBA. 2. You select the maintenance screen. 3. You choose Perform Recovery option on the maintenance screen. 4. You choose Whole Database in the Object Type drop-down list Perform Recovery: Type screen. 5. You choose Recover to Current Time from the Operation Type on the Perform Recovery: Type screen. 6. You provide the Host Credentials for a database user. on the Perform Recovery: Type screen. 7. You click the continue button. An information screen appears saying that the database is unavailable. What is this information screen?()
A.Recovery Manager
B.Recovery Window
C.Recovery Wizard
D.Enterprise Manager Home Page -
单项选择题
FlashbackDatabaseisenabledinyourOracle10gdatabase.Oneofyourdatabaseuserserroneouslypurgedanimportanttableresidinginhisschema.Thetablewaspurgedsometimebetween10:00P.M.and10:30P.M.Thenextday,youdecidetoflashbackthedatabase.Beforeyouflashbackthedatabase,youwanttoensurethatyouhaveallthenecessaryflashbackdata.Whichdynamicperformanceviewmustyouusetodeterminewhetheryouhavetherequiredflashbackdatatorecoverthepurgedtable?()
A. V$DATABASE
B. V$UNDOSTAT
C. V$FLASHBACK_DATABASE_LOG
D. V$FLASHBACK_DATABASE_STAT
