网友您好, 请在下方输入框内输入要搜索的题目:

题目内容 (请给出正确答案)

Which statement about using RMAN stored scripts is true?()

  • A、To create and execute an RMAN stored script, you must use a recovery catalog.
  • B、When executing a stored script and a command fails, the remainder of the script is executed, and a message is written to the alert log file.
  • C、RMAN stored scripts can always be executed against any target database that is registered in the recovery catalog.
  • D、When you execute a stored script, it always executes using the persistent channel settings previously set with the CONFIGURE command.

参考答案

更多 “Which statement about using RMAN stored scripts is true?()A、To create and execute an RMAN stored script, you must use a recovery catalog.B、When executing a stored script and a command fails, the remainder of the script is executed, and a message is written to the alert log file.C、RMAN stored scripts can always be executed against any target database that is registered in the recovery catalog.D、When you execute a stored script, it always executes using the persistent channel settings previously set with the CONFIGURE command.” 相关考题
考题 Examine the following scenario:The target database instance is running. The most recent backup available for the target database was taken two days ago. Log files switches have occurred in last two days. The target database is duplicated on the same host, using the Recovery Manager (RMAN) duplicate command as follows:Which statement is true about the duplicate database in this scenario?()A. It contains data till the last backupB. It contains all data from target database until the current timeC. It contains all data from only the committed transactions in the target databaseD. It contains all data except that which is used by the transactions in the current online redo file of target database

考题 Given the configuration shown in the exhibit, which statement is correct about traffic matching the route 10.10.10.0/24?() A. It will be forwarded to 192.168.100.1 using a metric of 10.B. It will be forwarded to 192.168.100.1 using a metric of 8.C. It will be forwarded to 192.168.200.1 using a metric of 8.D. It will be forwarded to 192.168.200.1 using a metric of 10.

考题 Which statement about using McAfee and Webroot together is true?() A、it is not recommended: the system will not detect more malwareB、it is notpossible : the WSA will accept only one anti-malware licenseC、the system will stop all web-based threatsD、it is recommended: the system will detect more malware

考题 Which statement is true about using Microsoft Windows Cluster as a platform for Mysql?()A、It implements High Availability by using the .NET Connector's' load balancing capabilitiesB、It is shared-nothing architectureC、It is provided by means of IP- level disk replicationD、It relies on the shared disk architecture being visible to both servers

考题 You want to take the backup of the USERS tablespace. It has a single data file of 900 MB. You have tape drives of 300 MB each. The SBT channel is configured for Recovery Manager (RMAN). To accomplish the backup, you issued the following RMAN command: RMAN BACKUP SECTION SIZE 300M TABLESPACE users; Which two statements are true about the execution of the above command? ()(Choose two.)A、The backup piece size will be limited to 300 MBB、The RMAN uses multiplexing to perform backupC、The operation is accomplished using the default channel availableD、The RMAN parallelizes the backup although the parallelism is not set for a channel

考题 You are maintaining the database in Oracle10g. You are performing an incomplete recovery by using RMAN because an important table, EMPLOYEE, is dropped and purged from the Recycle Bin. Which statement is NOT true regarding an incomplete recovery?()A、 The target database must be in the MOUNT mode to ensure restoration of the datafiles.B、 You can restore the datafiles from the backup by using the RMAN utility only if the backups were taken using the RMAN utility.C、 The control file must be recreated.D、 The database must be opened with the RESETLOGS option.

考题 You scheduled a backup by using the Schedule Backup option in Oracle Enterprise Manager. Which statement about the script created by Oracle Enterprise Manager is true? ()A、It is a SQL script.B、It is a PL/SQL file.C、It is an operating system (OS) file.D、It is a Recovery Manager (RMAN) script

考题 You want to implement the backup and recovery strategy in your database using Recovery Manager (RMAN). You have chosen the control file of the target database for the RMAN repository.  Which command-line RMAN command would you use to establish a local connection between RMAN and the RMAN repository if your database is using password file authentication?()A、 rman TARGET / NOCATALOGB、 rman TARGET sys/passwordC、 rman TARGET sys/password AS SYSDBAD、 rman TARGET sys/password@db_name CATALOG rman_user/rman_password@rcat

考题 You perform a backup using the following BACKUP command:   RMAN BACKUP AS COMPRESSED BACKUPSET DATABASE;   Which statement is true of this command?()  A、 A different procedure is required to restore a database from compressed backupsB、 The AS COMPRESSED clause of the BACKUP command provided by RMAN is used to create compressed  backup sets and image copies.C、 Using this command to create backups minimizes the bandwidth consumedD、 Using this command to create backups improves the performance of the backup process

考题 You work as a database administrator for Supportcenter.cn. You are using Recovery Manager (RMAN) for backup and recovery of your database. You executed the delete command in RMAN to delete a backup of a tablespace. Which statement is true in this scenario?()A、The backup status will be marked expired in RMAN recovery catalog.B、The backup status will be marked deleted in RMAN recovery catalog after you execute the crosscheck command.C、The backup will be deleted physically from the OS (Operating system)and the backup information is removed from the recovery cataloglD、The backup status will be marked deleted and you must delete the backup file manually from the OS (Operating system).E、The backup status will be marked deleted and you must delete the backup file manually from the OS (Operating system), if you are not using Oracle Managed Files (OMF).

考题 单选题Which statement about using RMAN stored scripts is true?()A  To create and execute an RMAN stored script,you must use a recovery catalog.B  When executing a stored script and a command fails,the remainder of the script is executed,and a message is written to the alert log file.C  RMAN stored scripts can always be executed against any target database that is registered in the recovery catalog.D  When you execute a stored script,it always executes using the persistent channel settings previously set with the CONFIGURE command.

考题 单选题Which statement is true about using Microsoft Windows Cluster as a platform for Mysql?()A It implements High Availability by using the .NET Connector's' load balancing capabilitiesB It is shared-nothing architectureC It is provided by means of IP- level disk replicationD It relies on the shared disk architecture being visible to both servers

考题 单选题Examine the following scenario: The target database instance is running. The most recent backup available for the target database was taken two days ago. Log files switches have occurred in last two days. The target database is duplicated on the same host, using the Recovery Manager (RMAN) duplicate command as follows:   RMAN RUN { ALLOCATE AUXILIARY CHANNEL aux 1 DEVICE TYPE DISK;  DUPLICATE TARGET DATABASE TO auxdb; }   Which statement is true about the duplicate database in this scenario?()A  It contains data till the last backupB  It contains all data from target database until the current timeC  It contains all data from only the committed transactions in the target databaseD  It contains all data except that which is used by the transactions in the current online redo file of target database

考题 多选题Which two statements are true about Block Media Recovery (BMR)?()ABMR increases the Mean Time To Recover (MTTR).BBMR can only be implemented using Recovery Manager (RMAN).CThe blocks that need to be recovered are accessible during BMR.DBMR cannot be performed using cumulative incremental backups.EThe datafile must be restored if most of the blocks in the datafile are corrupt.

考题 多选题You want to take the backup of the USERS tablespace. It has a single data file of 900 MB. You have tape drives of 300 MB each. The SBT channel is configured for Recovery Manager (RMAN). To accomplish the backup, you issued the following RMAN command: RMAN BACKUP SECTION SIZE 300M TABLESPACE users; Which two statements are true about the execution of the above command? ()(Choose two.)AThe backup piece size will be limited to 300 MBBThe RMAN uses multiplexing to perform backupCThe operation is accomplished using the default channel availableDThe RMAN parallelizes the backup although the parallelism is not set for a channel

考题 单选题You want to implement the backup and recovery strategy in your database using Recovery Manager (RMAN). You have chosen the control file of the target database for the RMAN repository.  Which command-line RMAN command would you use to establish a local connection between RMAN and the RMAN repository if your database is using password file authentication?()A  rman TARGET / NOCATALOGB  rman TARGET sys/passwordC  rman TARGET sys/password AS SYSDBAD  rman TARGET sys/password@db_name CATALOG rman_user/rman_password@rcat

考题 多选题An administrator account is granted the CREATE SESSION and SET CONTAINER system privileges. A multitenant container database (CDB) instant has the following parameter set: THREADED_EXECUTION = FALSE Which four statements are true about this administrator establishing connections to root in a CDB that has been opened in read only mode?()AYou can conned as a common user by using the connect statement.BYou can connect as a local user by using the connect statement.CYou can connect by using easy connect.DYou can connect by using OS authentication.EYou can connect by using a Net Service name.FYou can connect as a local user by using the SET CONTAINER statement.

考题 单选题You perform a backup using the following BACKUP command: RMAN BACKUP AS COMPRESSED BACKUPSET DATABASE; Which statement is true of this command?()A A different procedure is required to restore a database from compressed backupsB The AS COMPRESSED clause of the BACKUP command provided by RMAN is used to create compressed backup sets and image copies.C Using this command to create backups minimizes the bandwidth consumedD Using this command to create backups improves the performance of the backup process

考题 单选题You perform a backup using the following BACKUP command:   RMAN BACKUP AS COMPRESSED BACKUPSET DATABASE;   Which statement is true of this command?()A  A different procedure is required to restore a database from compressed backupsB  The AS COMPRESSED clause of the BACKUP command provided by RMAN is used to create compressed  backup sets and image copies.C  Using this command to create backups minimizes the bandwidth consumedD  Using this command to create backups improves the performance of the backup process

考题 单选题Your database is in ARCHIVELOG mode. On Friday evening, you perform an online database backup by using the BACKUP DATABASE command at the Recovery Manager (RMAN) prompt and close the  database. On Monday, the System Administrator informs you about the failure of two hard disks. One of the lost disks contains two datafiles, HR1.DBF and HR2.DBF, both of which belong to a read/write tablespace named HR. The disk also contains a datafile, USERS.DBF, which belongs to a read/write tablespace named USERS. You need to restore and recover the database backup that was performed on Friday evening. After mounting the database, you issue the following RMAN commands:        RMANRESTORE DATABASE;        RMANRECOVER DATABASE;   After successfully executing these RMAN commands, you issue the following statement using SQL*Plus:        SQLALTER DATABASE OPEN;   You receive the following errors when attempting to open the database:        ORA-01157: cannot identify/lock data file 10 see DBWR trace file        ORA-01110: data file 10: ’D:///USERS.DBF’   What is the cause of these errors?()A  The USERS.DBF datafile is corrupted and cannot be restored by RMAN.B  The USERS.DBF datafile was not backed up using the RMAN BACKUP DATABASE command.C  The USERS.DBF datafile was not restored using the RMAN RESTORE DATABASE command.D  The USERS.DBF datafile was not recovered using the RMAN RECOVER DATABASE command.

考题 单选题You have an Automatic Storage Management (ASM) instance managing the database files of your production database. The database contains ASM files and non-ASM files. Using Recovery Manager (RMAN), you migrate the complete production database to use the ASM instance. Which statement is true? ()A  RMAN would relocate all the data files to an ASM disk group and other files to an operating system location, defined using Oracle Managed Files (OMF).B  RMAN would relocate the ASM files to an ASM disk group and the non-ASM files to an operating system location, defined using OMFC  RMAN would relocate all the database files to an ASM disk group.D  RMAN would change the file definitions in the control file to use the ASM but would not relocate the database files physically.

考题 单选题Which statement about using RMAN stored scripts is true?()A To create and execute an RMAN stored script, you must use a recovery catalog.B When executing a stored script and a command fails, the remainder of the script is executed, and a message is written to the alert log file.C RMAN stored scripts can always be executed against any target database that is registered in the recovery catalog.D When you execute a stored script, it always executes using the persistent channel settings previously set with the CONFIGURE command.

考题 单选题Which statement about using McAfee and Webroot together is true?()A it is not recommended: the system will not detect more malwareB it is notpossible : the WSA will accept only one anti-malware licenseC the system will stop all web-based threatsD it is recommended: the system will detect more malware

考题 单选题You scheduled a backup by using the Schedule Backup option in Oracle Enterprise Manager. Which statement about the script created by Oracle Enterprise Manager is true? ()A It is a SQL script.B It is a PL/SQL file.C It is an operating system (OS) file.D It is a Recovery Manager (RMAN) script

考题 多选题Using the LIST command in Recovery Manager (RMAN),which two pieces of information in the RMAN repository can be listed?()Astored scripts in the recovery catalogBbackups that can be deleted from diskCbackup sets and image copies are obsoleteDbackups that do not have the AVAILABLE status in the RMAN repository

考题 多选题Which four can be thrown using the throw statement?()AErrorBEventCObjectDThrowableEExceptionFRuntimeException

考题 单选题You are maintaining the database in Oracle10g. You are performing an incomplete recovery by using RMAN because an important table, EMPLOYEE, is dropped and purged from the Recycle Bin. Which statement is NOT true regarding an incomplete recovery?()A  The target database must be in the MOUNT mode to ensure restoration of the datafiles.B  You can restore the datafiles from the backup by using the RMAN utility only if the backups were taken using the RMAN utility.C  The control file must be recreated.D  The database must be opened with the RESETLOGS option.