ITPub博客

（317）If you lost your entire database, including the database spfile, control files, online redo logs, and database datafiles,what kind of recovery would be required with RMAN?A. Complete database recovery.B. Incomplete database recovery.C. Approximate database recovery.D. Archi...

（316）Given a complete loss of your database, in what order would you need to perform the following RMAN operations to restore it?a. restore controlfileb. restore databasec. restore spfiled. recover databasee. alter database openf. alter database open resetlogsA b, a, c, ...

（315）Which commands are used for RMAN database recovery? (Choose all that apply.)A. restoreB. repairC. copyD. recoverE. replace答案：（A、D）

（314）Given the following RMAN commands, choose the option that reflects the order required to restore your currently operational ARCHIVELOG-mode database.a. restore database;b. recover database;c. shutdown immediated. startupe. restore archivelog all;f. alte...

（313）What command would you issue to enable automated backups of control files?A. alter database controlfile autobackup onB. alter system controlfile autobackup onC. configure controlfile autobackup onD. enable controlfile autobackup答案：（C）

（312）Which is the correct way to connect to both the target database and the recovery catalog from the RMAN command line?Assume that the target database is called ORCL and that the recovery catalog database is called RCAT.Also assume that the recovery-catalog owner is called RCAT_OWN.As...

（311）Given the scriptcreate script db_backup_datafile_script {backup datafile and 1, and2 plus archivelog delete input;}What is the result of running this command?Run {execute script db_backup_datafile_script using 2;}A. The script will fail since you instructed RMAN to back up only...

（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-catalog schemaC. See all database-related metadata in the recovery catalog if they are granted access to that da...

（309）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 user (or equivalent) of the target database.B. Issue the grant command from the SYS user (or equivalent) of the recovery-catalog databa...

（308）In what order would you execute the following steps to create a recovery catalog?a. Issue the create catalog command.b. Create the recovery-catalog database.c. Create the recovery-catalog user.d. Grant the recovery_catalog_owner privilege to the recovery-catalog user.e. Iss...

（307）You have created a script in the recovery catalog called backup_database.Which of the following commands would successfully execute that script?A. run { open script backup_database; run script backup_database }B. run { engage script backup_database; }C. run { run script backup_...

（306）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 apply.)A. The next time you back up the database when you are also connected to the recovery catalog and the target databaseB. The next...

（305）Which command do you use to create a recovery-catalog schema?A. create recovery catalogB. create catalogC. build catalogD. catalog createE. mount catalog答案：（B）

（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. CONNECT答案：（A、C、E）或（A）解析：因为A包含C和E，实际上只要有A即可...

（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 provide...

（302）You issue the following command:RMAN>CONFIGURE BACKUP OPTIMIZATION ON;What is the result of this command on your backups?A. An incremental backup strategy will be used automatically.B. Read-only datafiles will not be backed up as long as backups of those files already exist a...

（301）Which command is used to configure RMAN to perform a compressed backup for every backup executed?A. BACKUP AS COMPRESSED BACKUPSET DATABASEB. BACKUP AS COMPRESSED COPY OF DATABASEC. CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COMPRESSED BACKUPSETD. CONFIGURE DEVICE TYPE DISK BACK...

再来一例,当闪回删除表时,相关的索引、约束和触发器将保持在回收站中的名称。

（300）The following databases are registered in the base recovery catalog: PROD1, PROD2, and PROD3.The database user CATOWNER owns the base recovery catalog. You want a new user VPC1 to have access to only the PROD1 database and create a virtual private catalog.Given below are some of the co...