How can you reverse the effects of an ALTER DISKGROUP ... DROP DISK command if it has not yetcompleted?（）

单项选择题Given the following steps, which would be the correct order to create a backup of an Oracle database in NOARCHIVELOG mode?（） 1.shutdown immediate from RMAN 2.Log into RMAN 3.startup mount from RMAN 4.backup database 5.alter database open 6.backup database plus archivelog delete input

A.2，3，1，4，5
B.2，1，3，6，5
C.1，3，5，4
D.2，1，3，5，6
E.2，1，3，4，5

单项选择题Given the script   create script db_backup_datafile_script  {backup datafile and 1， and2 plus archivelog delete input；} Run {execute script db_backup_datafile_script using 2；}   What is the result of running this command？（）

A. The script will fail since you instructed RMAN to back up only one datafile rather than two
B. The script will successfully back up datafile 3 without error
C. The script will fail since it uses a substitution variable which is not supported
D. The execute script command will prompt for the value of and2 since it’s not included in the command
E. The script will fail because you cannot use the plus archivelog command when backing up

单项选择题Upon starting your database, you receive the following error: You can choose from the following steps: 1.Restore the database datafiles. 2.Issue the alter database clear unarchived logfile group 1 command. 3.Issue the alter database open command. 4.Issue the alter database open resetlogs command. 5.Recover the database using point-in-time recovery. 6.Issue the Startup Mount command to mount the database. 7.Back up the database. Which is the correct order of these steps in this case?（）

A. 1,6,5,4,7
B. 6,5,4
C. 6,2,3,7
D. 1,6,3
E. The database cannot be recovered

多项选择题TheRVPCusercandowhichofthefollowing？（）

A. Register databases if granted the register database privilege
B. See all databases in the recovery-catalog schema
C. See all database-related metadata in the recovery catalog if they are granted access to that database
D. Unregister databases from the RVPC catalog that were not granted to the RVPC catalog owner with  the grant command
E. Not be connected to with the RMAN command-line catalog parameter for backup or recovery purposes

单项选择题Your database has experienced a loss of datafile users_01.dbf, which is associated with a ablespace called USERS. The database is still running. Which answer properly describes the rder of the steps that you would use to recover from this error?（） 1.Shut down the database. 2.Take the users_01.dbf datafile offline with the alter database command. 3.Restore the users_01.dbf datafile from backup media with the required archived redo logs. 4.Restore all users tablespace-related datafiles from backup media. 5.Issue the recover tablespace users command. 6.Issue the recover datafile users_01.dbf command. 7.Start up the database. 8.Bring the users_01.dbf datafile online with the alter database command.

A.1，3，6，7
B.2，3，6，8
C.1，2，3，6，7
D.1，2，3，6，，7，8
E.2，3，6，5，7