随笔分类 - OCP
OCP考试学习
摘要:What is the end result of these commands if they are successful?RMAN> show retention policy;RMAN configuration parameters for database with db_unique_
阅读全文
摘要:Which command will restore all datafiles to the date 9/30/2008 at 18:00 hours?A. restore datafiles until time '09/28/2008:21:03:11';B. restore databas
阅读全文
摘要:If you lost your entire database, including the database spfile, control files, online redo logs, anddatabase datafiles, what kind of recovery would b
阅读全文
摘要:Given a complete loss of your database, in what order would you need to perform the followingRMAN operations to restore it?A. restore controlfileB. re
阅读全文
摘要:Which commands are used for RMAN database recovery? (Choose all that apply.)A. restoreB. repairC. copyD. recoverE. replace The restore command is used
阅读全文
摘要:Given the following RMAN commands, choose the option that reflects the order required to restoreyour currently operational ARCHIVELOG-mode database.A.
阅读全文
摘要:What command would you issue to enable automated backups of control files?A. alter database controlfile autobackup onB. alter system controlfile autob
阅读全文
摘要:Which is the correct way to connect to both the target database and the recovery catalogfrom the RMAN command line? Assume that the target database is
阅读全文
摘要:Given the scriptcreate script db_backup_datafile_script{backup datafile and 1, and2 plus archivelog delete input;}What is the result of running this c
阅读全文
摘要:The RVPC user can do which of the following? (Choose all that apply.)A. Register databases if granted the register database privilegeB. See all databa
阅读全文
摘要:How would you grant the RVPC user access to specific RMAN database records in the RMAN virtual private catalog?A. Issue the grant command from the SYS
阅读全文
摘要:You have created a script in the recovery catalog called backup_database. Which of the followingcommands would successfully execute that script?A. run
阅读全文
摘要:If you back up a database without connecting to the recovery catalog, which operations will cause the recovery catalog to be updated? (Choose all that
阅读全文
摘要:Which command do you use to create a recovery-catalog schema?A. create recovery catalogB. create catalogC. build catalogD. catalog createE. mount cata
阅读全文
摘要:What privileges must be granted to allow an account to create the recovery catalog? (Choose all thatapply.)A. RECOVERY_CATALOG_OWNERB. DBAC. RESOURCED
阅读全文
摘要:What is the purpose of the RMAN recovery catalog? (Choose all that apply.)A. It must be used because all RMAN-related backup and recovery metadata inf
阅读全文
摘要:You issue the following command:RMAN>CONFIGURE BACKUP OPTIMIZATION ON;What is the result of this command on your backups?A. An incremental backup stra
阅读全文
摘要:Which command is used to configure RMAN to perform a compressed backup for every backupexecuted?A. BACKUP AS COMPRESSED BACKUPSET DATABASEB. BACKUP AS
阅读全文
摘要:Which of the following statements are true about the BACKUP command? (Choose all that apply.)A. The BACKUP command can not be used to make image copie
阅读全文
摘要:Given the following steps, which would be the correct order to create a backup of an Oracle database in ARCHIVELOG mode with control-file autobackups
阅读全文
浙公网安备 33010602011771号