You executed the following command in Recovery Manager （RMAN）： RMAN> RESTORE CONTROLFILE; Which operation must you perform before this command is executed？（）
A. back up the control file to trace
B. bring database to the MOUNT state
C. open a connection to the RMAN recovery catalog， which contains the RMAN metadata for the target database
D. set the database ID （DBID）， but only if the DB_NAME parameter associated with the target database is unique in the recovery catalog
查看答案
相关试题
换一换
You executed the following command in Recovery Manager （RMAN）： RMAN> RESTORE CONTROLFILE; Which operation must you perform before this command is executed？（）
A.back up the control file to trace B.bring database to the MOUNT state C.open a connection to the RMAN recovery catalog， which contains the RMAN metadata for the target database D.set the database ID （DBID）， but only if the DB_NAME parameter associated with the target database is unique in the recovery catalog
答案
You decided to change the location of the flash recovery area. You executed the following command： Which statement is true？（）
A.The location can be changed only if the flash recovery area is empty. B.fter executing the command， all new flash recovery area files will be created in the new location. C.The command will generate an error because you cannot change the flash recovery area while the database is open. D.ll the existing files in the flash recovery area will be moved to the new location， and all new Flash Recovery Area files will be created in the new location.
答案
You executed the following query in your database： SELECT oldest_flashback_scn， oldest_flashback_time FROM V$FLASHBACK_DATABASE_LOG； What would you determine from the output？（）
A. The time when the last flashback operation in your database was performed. B. The time when the first flashback operation in your database was performed. C. A list of flashback operations performed in your database using SCN and time. D. The approximate time and the lowest system change number （SCN） to which you can flash back your database.
答案
You executed the following query in your database： SELECT oldest_flashback_scn， oldest_flashback_time FROM V$FLASHBACK_DATABASE_LOG； What would you determine from the output？（）
A. The time when the last flashback operation in your database was performed. B. The time when the first flashback operation in your database was performed. C. A list of flashback operations performed in your database using SCN and time. D. The approximate time and the lowest system change number （SCN） to which you can flash back your database.
答案
You executed the STARTUP MOUNT command to start your database. For which database operation do you need to start the database in the MOUNT state？（）
A.renaming the control files B.dropping a user in your database C.enabling or disabling redo log archiving D.dropping a tablespace in your database E.re-creating the control files， after you lost all the control files in your database
答案
You executed the following command to back up the control file： ALTER DATABASE BACKUP CONTROLFILE TO TRACE； What do you find in the trace file？（）
A.Image of the control file B.Location of the control file C.ontents of the control file in text format D.SQL command to re-create the database E.SQL command to re-create the control file F.ontents of the control file in binary format
答案
You started a long transaction. Before committing， you executed a query on one of the tables currently being modified. You received the following error： ORA-01555： snapshot too old How would you prevent such an error in the future？（）
A.guarantee undo retention B.add one more redo log group C.size the redo log files appropriately D.size the UNDO tablespace appropriately E.size the SYSTEM tablespace appropriately F.configure an appropriate undo retention interval G.change automatic undo management to manual
答案
Which built-in would you use to test whether the CREATE TABLE command issued in the SALES form executed successfully?（）
A.FORMS_DDL B.DO_SQL C.FORM_SUCCESS D.FORM_NOT_SUCCESS E.DBMS.ERROR_CODE
答案
Which built-in would you use to test whether the CREATE TABLE command issued in the SALES form executed successfully?（）
A.ORMS_DDL B.O_SQL C.ORM_SUCCESS D.ORM_NOT_SUCCESS E.BMS.ERROR_CODE
答案
You executed the following FLASHBACK TABLE command： FLASHBACK TABLE emp TO TIMESTAMP （’11：45’，’hh12：mi’）； Which two statements are correct？ （）
A. The FLASHBACK TABLE statement will not be written to the alert log file. B. The EMP table that was dropped by mistake from the database will be restored. C. The changes made to the EMP table since the specified time will be undone. D. The FLASHBACK TABLE statement will not maintain the existing indexes on the EMP table. E. The FLASHBACK TABLE statement will be executed within a single transaction. F. The list of transactions that have modified the EMP table since the specified time will be displayed.
答案
热门试题
You executed the following FLASHBACK TABLE command： FLASHBACK TABLE emp TO TIMESTAMP （’11：45’，’hh12：mi’）； Which two statements are correct？ （）
You executed the following FLASHBACK TABLE command： FLASHBACK TABLE emp TO TIMESTAMP （’11：45’，’hh12：mi’）; Which two statements are correct？（）
You executed the following FLASHBACK TABLE command： FLASHBACK TABLE emp TO TIMESTAMP （’11：45’，’hh12：mi’）; Which two statements are correct？（）
The backup retention policy is configured as RECOVERY WINDOW 2. You executed the following command in Recovery Manager （RMAN） against your database： RMAN> REPORT OBSOLETE； What would you see in the output？（）
You work as a database administrator for Certkiller .com. You suspect that in one of your applications the customer table is being accessed by some unauthorized users. Which option would you use to monitor the queries being executed on the customer table？（）
You work as a database administrator for Supportcenter.cn. You are using Recovery Manager （RMAN） for backup and recovery of your database. You executed the delete command in RMAN to delete a backup of a tablespace. Which statement is true in this scenario？（）
You work as a database administrator for Supportcenter.cn. You are using Recovery Manager （RMAN） for backup and recovery of your database. You executed the delete command in RMAN to delete a backup of a tablespace. Which statement is true in this scenario？（）
You work as a database administrator for Certkiller .com. You suspect that in one of your applications the customer table is being accessed by some unauthorized users. Which option would you use to monitor the queries being executed on the customer table？（）
You work as a database administrator for Supportcenter.cn. You suspect that in one of your applications the customer table is being accessed by some unauthorized users. Which option would you use to monitor the queries being executed on the customer table？（）
You work as a database administrator for Supportcenter.cn. You suspect that in one of your applications the customer table is being accessed by some unauthorized users. Which option would you use to monitor the queries being executed on the customer table？（）
You have executed this command to change the size of the database buffer cache： SQL> ALTER SYSTEM SET DB_CACHE_SIZE=2516582； System altered. To verify the change in size， you executed this command：SQL> SHOW PARAMETER DB_CACHE_SIZENAME TYPE VALUE ------------------- ----------- ------------------ db_cache_size big integer 4194304 Why is the value set to 4194304 and not to 2516582（）
Which of the following commands cannot be executed when the database open？（）
You are working on an online transaction processing （OLTP） system. You notice that a PL/SQL procedure got executed twice at 2） 00 p.m. This has incorrectly updated the EMP_SAL table. How would you revert the table to its state at 2） 00 p.m.？（）
You are working on an online transaction processing （OLTP） system. You notice that a PL/SQL procedure got executed twice at 2） 00 p.m. This has incorrectly updated the EMP_SAL table. How would you revert the table to its state at 2） 00 p.m.？（）
You executed the following command in Recovery Manager （RMAN） against your Oracle 10g database：RMAN> REPORT NEED BACKUP days 3；What would be the output of this command？（）
You are developing a tax report for the payroll application. You created a before parameter form report trigger to create three temporary tables to store text that are need while the report is executed. Which report trigger would you use to delete these temporary tables?（）
You are developing a tax report for the payroll application. You created a before parameter form report trigger to create three temporary tables to store text that are need while the report is executed. Which report trigger would you use to delete these temporary tables?（）
You executed the following SQL statement to shrink the EMPLOYEES table segment stored in the EXAMPLE tablespace: ALTER TABLE employees SHRINK SPACE CASCADE; Which statement is correct in this scenario?（）
You executed the following SQL statement to shrink the EMPLOYEES table segment stored in the EXAMPLE tablespace: ALTER TABLE employees SHRINK SPACE CASCADE; Which statement is correct in this scenario?（）
At 10：30 A.M.， you ran a batch job by mistake， which executed a transaction in the database. The transaction identifier of the transaction that made to the changes in the database is 0500A00627B000. At 11：10 A.M.， you stopped the batch job. Now， you want to identify the changes made to the database tables by the batch job. Which view will you query？（）
使用微信扫一扫登录
