ITPub博客

356.Which of the following commands will perform an active database duplication of the ORCL database to the ORCL2 database?A. Set oracle_sid=orclrman target=sys/robert auxname=sys/Robert@orcl2 create duplicate target database to neworcl from active database nofilenamecheckspfile set control_file...

349.What is the result of this command? RMAN> Report need backup days 3;A. Lists all datafiles created in the last three days that are not backed up.B. Lists all datafiles not recoverable based on the current retention criteria.C. Lists all datafiles not backed up in the last three days. The data...

347.What does the output on this report indicate? RMAN> report need backup;RMAN retention policy will be applied to the commandRMAN retention policy is set to redundancy 1Report of files with less than 1 redundant backupsFile #bkps Name5 0 C:\ORACLE\ORADATA\ORCL\MY_DATA_01.DBF...

346.What is the impact of the results of the output of the following command? RMAN> report unrecoverable database;Report of files that need backup due to unrecoverable operationsFile Type of Backup Required Name4 full or incremental C:\ORACLE\ORADATA\ORCL\USERS01.DBFA. There are n...

344.In what view are you likely to see the following output? SID SERIAL# EVENT SECONDS_IN_WAIT121 269 RMAN backup & recovery I/O 2129 415 SQL*Net message from client 63 130 270 SQL*Net message from clientA. V$SESSION_EVENTB. V$SESSIONC. V$WAITSD. V$WAITSTATE. V$SYSSTAT...

343.What is the impact of the following backup if it exceeds the duration allowance? (Choose all that apply.)Backup as compressed backupset duration 2:00 partial minimize load database ;A. The entire backup will fail. It will not be usable for recovery.B. The entire backup will fail, but any data...

310.The RVPC user can do which of the following? (Choose all that apply.)A. Register databases if granted the register database privilegeB. See all databases in the recovery-catalogT sMchemaC. See all database-related metadata in the recovery catalog if they are granted access to that databaseD....

304.What privileges must be granted to allow an account to create the recovery catalog? (Choose all that apply.)A. RECOVERY_CATALOG_OWNERB. DBAC. RESOURCED. SELECT ANY DICTIONARYE. CONNECTAnswer: AC允许帐户创建恢复目录时必须授予什么权限？

303.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 information is contained in it.B. It provides a convenient, optional, repository of backup- and recovery-related metadata.C. It provides the abili...

600.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 copies of a datafile.B. The BACKUP command can improve performance by multiplexing backup files.C. The BACKUP can take advantage of the block-change...

593.Given the following steps, which would be the correct order to create a backup of an Oracle database in NOARCHIVELOG mode?a. shutdown immediate from RMANb. Log into RMANc. startup mount from RMANd. backup databasee. alter database openf. backup database plus archivelog delete inputA. b, c...

590.Which type of backup backs up only data blocks modified since the most recent backup at the same level or lower?A. Differential incremental backupB. Different incremental backupC. Cumulative backupD. Cumulative incremental backupAnswer: A哪种备份类型的备份只备份自同一级别的最新备份或较低...

589.Which of the following best describes a full backup?A. All datafiles of a databaseB. All datafiles, archive logs, and control filesC. All datafiles and control filesD. All the used blocks in a datafileAnswer: D以下哪一个最好的描述了一个完整的备份？D. 数据文件中所有使用的数据块...

545.When performing an online backup, what is the proper order of the following steps?a. Issue the alter database end backup command.b. Back up the archived redo logs.c. Issue the alter database begin backup command.d. Back up the database files.e. Determine the beginning log sequence number.f...

544.Your database is in NOARCHIVELOG mode. You start to do a backup, but your users complain that they dont want you to shut down the database to perform the backup. What options are available to you?A. Put the database in hot backup mode and perform an online backup, including backing up the archi...

517.Which of the following are true concerning block media recovery? (Choose all that apply.)A. Any gap in archive logs ends the recovery.B. If a gap in archive logs is encountered, RMAN will search forward for newer versions of the blocks that are not corrupt.C. Uncorrupted blocks from the flash...

512.Which two statements correctly describe the relationship among the Scheduler components:job,program, and schedule? (Choose two)A. A job is specified as part of a program definitionB. A program can be used in the definition of multiple jobsC. A program and job can be specified as part of a sc...

511.You have configured flash recovery area in your database and you set the following Initialization parameters for your database instance:LOG_ARCHIVE_DEST 1 = ,,LOCATION=/disk1/arch MANDATORY'LOG _ARCHIEVE_DEST 2 = ,,LOCATION=/disk2/arch'LOG_ARCHIVK_DEST_3 = ,,LOCATION=/diSk3/archLOG_ARCH1VK_D...

597.What command would you use to set a persistent setting in RMAN so that backups are all written to a tape device?A. CONFIGURE DEFAULT DEVICE TYPE TO TAPE MEDIAB. CONFIGURE DEFAULT DEVICE TYPE TO TAPEC. CONFIGURE DEFAULT DEVICE TYPE TO SBTD. CONFIGURE DEFAULT DEVICE TYPE TO SBT_TAPEAnswer: C...

166.Note the output of the following query;SQL> SELECT flashback_archieve_name, status FROM dba_flashback_archieve;FLASHBACK_ARCHIEVE_NAME STATUSFLA1You executed the following command to enable Flashback Data Archive on the EXCHANGB_PATE table:ALTER TABLE exchange_rate FLASHBACK ARCHIEVE;What ...