找考题网-背景图
单项选择题

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

单项选择题How many individual archive-log destination directories are supported by Oracle Database11g?（）

A.7
B.1
C.10
D.11
E.21

单项选择题HowwouldyougranttheRVPCuseraccesstospecificRMANdatabaserecordsintheRMANvirtualprivatecatalog？（）

A. Issue the grant command from the SYS user （or equivalent） of the target database.
B. Issue the grant command from the SYS user （or equivalent） of the recovery-catalog database.
C. Issue the grant command from the recovery catalog-owning schema user account in the recovery catalog.
D. Issue the grant command from RMAN when connected to the recovery catalog-owning schema.
E. Issue the grant command from RMAN when connected to the target database.