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

题目内容 (请给出正确答案)
单选题
In which scenario will you issue the following command?()      SQL> RECOVER DATABASE UNTIL TIME ’2005-10-04 : 12:09:08’ USING        BACKUP CONTROLFILE;
A

 when all the control files are missing and only a binary backup of the current control file exists

B

 when a multiplexed copy of the current control file is missing

C

when all the control files are missing and only a script containing the CREATE CONTROLFILE statement exists

D

 when the SPFILE is missing


参考答案

参考解析
解析: 暂无解析
更多 “单选题In which scenario will you issue the following command?()      SQL RECOVER DATABASE UNTIL TIME ’2005-10-04 : 12:09:08’ USING        BACKUP CONTROLFILE;A  when all the control files are missing and only a binary backup of the current control file existsB  when a multiplexed copy of the current control file is missingC when all the control files are missing and only a script containing the CREATE CONTROLFILE statement existsD  when the SPFILE is missing” 相关考题
考题 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,7B. 6,5,4C. 6,2,3,7D. 1,6,3E. The database cannot be recovered

考题 After logging into the RtrB router, you issue the show interface command as displayed below:After considering the effects of the command output illustrated in the exhibit above,which of the following protocols are operational on the serial link?()A. PPPB. IPC. CompressionD. IPXE. MultilinkF. ATX

考题 At which command prompt would you issue the set date command?()A、[edit chassis]user@router#B、[edit]user@router#C、[edit system] user@router#D、user@router

考题 When you are troubleshooting an ACL issue on a router,which command can help you to verify which interfaces are affected by the ACL?()A、show ip access-listB、show access-listC、list ip interfaceD、show interfaceE、show ip interface

考题 In which scenario, will you issue the following command?() RMAN REPORT NEED BACKUP DAYS 7;A、 to configure RMAN to maintain backup information in the RMAN repository for seven daysB、 to configure RMAN to maintain backup information in the control file for at least seven daysC、 to display the list of files that have not been backed up for the last seven daysD、 to display the list of files that must be backed up within seven days

考题 Consider the following scenario: You have a directory, data, under the disk group tdgroupA. You want to create an alias for one of the data files and you execute the following command: ALTER DISKGROUP tdgroupA  ADD ALIAS ’+tdgroupA/data/datafile.dbf’  FOR ’+tdgroupA.231.45678’;  Which task would be accomplished by the command?()A、The command drops the file +tdgroupA·231.45678.B、The command physically relocates the file to +tdgroupA/data and renames the file to datafile.dbf.C、The command creates a copy of the +tdgroupA·231.45678 file and places it in +tdgroupA/data after renaming the file to datafile.dbf.D、The command creates an alias, datafile.dbf, and places it in +tdgroupA/data and does not remove the +tdgroupA·231.45678 file.E、The command creates a file, datafile.dbf, in +tdgroupA/data and removes the references for +tdgroupA·231.45678 from the data dictionary views.

考题 Your database is running in the ARCHIVELOG mode. You have configured RMAN for backup and recovery operations. You execute the following command from the RMAN prompt:   RMAN CONFIGURE CONTROLFILE AUTOBACKUP ON;   After executing this command, in which of the following cases will RMAN make an auto-backup of the control file? ()A、 when you change the name of a datafileB、 when you drop a table from the databaseC、 when you take an export of the databaseD、 when you back up the database using OS utilitiesE、 when you issue an ALTER SYSTEM SWITCH LOGFILE statementF、 when you issue a BACKUP command from inside the RMAN run block

考题 You are maintaining the PROD database for NetFx Corporation. You have configured controlfile autobackup in your database. At 6:00 P.M. on Monday, you issue the following command:       RMANBACKUP DATABASE;  At 8:00 A.M. on Tuesday, you are unable to start the database because all the control files are missing. You decide to restore the control files from the backup by using the RMAN RESTORE CONTROLFILE FROM AUTOBACKUP; command. Which operation should you perform before using the RMAN RESTORE CONTROLFILE FROM AUTOBACKUP; command?()A、 Start the database in the MOUNT stage.B、 Back up the control file to trace.C、 Set the DBIDD、 Issue the RECOVER DATABASE command.

考题 You execute the following command to start an Automatic Storage Management (ASM) instance:   SQLSTARTUP;   In which of the following modes will the ASM instance start?()A、 OPENB、 MOUNTC、 NORMALD、 NOMOUNT

考题 You are maintaining the database of a company. The listener process, listener1, is configured for remote access. You have issued the following command:   LSNRCTLSTATUS listener1   Which information will NOT be displayed when you issue the above command?() A、 whether the password is set in the listener or a file or notB、 the number of client connections the service handler has refusedC、 the information will be displayed whether the instance can accept connections or notD、 the protocol addresses on which the listener is configured to listen

考题 You discover an out-of-space condition in the database. You decide to suspend a session for five minutes. You issue the following command to suspend the session:   ALTER SESSION ENABLE RESUMABLE;   Which command could you issue to enable the resumable space allocation feature at the session level?()  A、 ALTER SESSION ENABLE RESUMABLE_TIMEOUT = 5;B、 ALTER SYSTEM ENABLE RESUMABLE_TIMEOUT = 5;C、 ALTER SESSION ENABLE RESUMABLE_TIMEOUT = 300;D、 ALTER SYSTEM ENABLE RESUMABLE TIMEOUT = 300;

考题 In which scenario will you issue the following command?()      SQL RECOVER DATABASE UNTIL TIME ’2005-10-04 : 12:09:08’ USING        BACKUP CONTROLFILE;A、 when all the control files are missing and only a binary backup of the current control file existsB、 when a multiplexed copy of the current control file is missingC、when all the control files are missing and only a script containing the CREATE CONTROLFILE statement existsD、 when the SPFILE is missing

考题 单选题In which scenario, will you issue the following command?() RMAN REPORT NEED BACKUP DAYS 7;A  to configure RMAN to maintain backup information in the RMAN repository for seven daysB  to configure RMAN to maintain backup information in the control file for at least seven daysC  to display the list of files that have not been backed up for the last seven daysD  to display the list of files that must be backed up within seven days

考题 单选题You have enabled backup optimization in RMAN. You issue the following RMAN command to configure a redundancy-based retention policy: CONFIGURE RETENTION POLICY TO REDUNDANCY 3; Which statement is true?()A The command fails because you cannot configure a redundancy-based retention policy when backup optimization is enabledB Backup optimization is performed, but RMAN considers the redundancy-based retention policy when it determines which datafiles should be backed upC Backup optimization is permanently disabledD Backup optimization is temporarily disabled because a redundancy-based retention policy is specified

考题 单选题You have enabled backup optimization in RMAN. You issue the following RMAN command to configure a redundancy-based retention policy:   CONFIGURE RETENTION POLICY TO REDUNDANCY 3;   Which statement is true?()A  The command fails because you cannot configure a redundancy-based retention policy when backup  optimization is enabledB  Backup optimization is performed, but RMAN considers the redundancy-based retention policy when it determines which datafiles should be backed upC  Backup optimization is permanently disabledD  Backup optimization is temporarily disabled because a redundancy-based retention policy is specified

考题 单选题You are maintaining the database of a company. The listener process, listener1, is configured for remote access. You have issued the following command:   LSNRCTLSTATUS listener1   Which information will NOT be displayed when you issue the above command?()A  whether the password is set in the listener or a file or notB  the number of client connections the service handler has refusedC  the information will be displayed whether the instance can accept connections or notD  the protocol addresses on which the listener is configured to listen

考题 单选题You have control-file autobackups enabled. When starting your database from SQL*Plus, you receive the following error message:   SQL startup ORA-01078: failure in processing system parameters LRM-00109:  could not open parameter file ,  C:///ORACLE/PRODUCT/11.1.0/DB_1/DATABASE/INITORCL.ORA Using RMAN,   how would you respond to this error?()A  Issue the startup nomount command and then issue the restore parameter file command from the RMAN prompt.B  Issue the startup nomount command and then issue the restore spfile command from the RMAN prompt.C  Issue the startup nomount command and then issue the restore spfile from autobackup command from the RMAN prompt.D  Issue the startup nomount command and then issue the restore spfile from backup command from the RMAN prompt.E  Issue the restore spfile from autobackup command from the RMAN prompt.

考题 单选题You want to use WLST to view metrics for a running domain. Which command should you issue to navigate through the Mbean hierarchy containing the metrics?()A runtime ()  B runtimeMbeanServer ()C connectRuntime ()D beginRuntime ()E serverRuntime ()

考题 多选题A user is successfully authenticating to the network but is unable to access protected resources behind a ScreenOS enforcer. You log in to the ScreenOS enforcer and issue the command get auth table infranet and you do not see the user listed.Which two event log settings on the Junos Pulse Access Control Service must you enable to troubleshootthis issue?()AConnection RequestsBSystem ErrorsCEnforcer EventsDEnforcer Command Trace

考题 单选题You enable block change tracking. You issue the following command: BACKUP INCREMENTAL LEVEL 0 DATABASE; The next day, you issue the following command: BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE; Which statement about the use of the change tracking file is true?()A RMAN reads the block change tracking file only when it performs the incremental level 0 backup.B RMAN reads the block change tracking file when it performs both incremental backups.C RMAN reads the block change tracking file only when it performs the incremental level 1 backup.D RMAN does not read the block change tracking file when it performs either incremental backup.

考题 单选题You executed the following commands in an RMAN session for your database instance that has failures: RMAN LIST FAILURE; After some time, you executed the following command in the same session: RMAN ADVISE FAILURE; But there are new failures recorded in the Automatic Diagnostic Repository (ADR) after the execution of the last LIST FAILURE command. Which statement is true for the above ADVISE FAILURE command in this scenario?()A It produces a warning for new failures before advising for CRITICAL and HIGH failures.B It ignores new failures and considers the failures listed in the last LIST FAILURE command only.C It produces an error with recommendation to run the LIST FAILURE command before the ADVISE FAILURE command.D It produces advice only for new failures and the failures listed in the last LIST FAILURE command are ignored.

考题 单选题When you are troubleshooting an ACL issue on a router,which command can help you to verify which interfaces are affected by the ACL?()A show ip access-listB show access-listC list ip interfaceD show interfaceE show ip interface

考题 单选题Examine the following command:   ALTER DISKGROUP data MOUNT FORCE;   In which scenario can you use the above command to mount the disk group?()A  when ASM disk goes offlineB  when one or more ASM files are droppedC  when some disks in a disk group are offlineD  when some disks in a failure group for a disk group are rebalancing

考题 单选题Examine the following command: ALTER DISKGROUP data MOUNT FORCE; In which scenario can you use the above command to mount the disk group? ()A when ASM disk goes offlineB when one or more ASM files are droppedC when some disks in a disk group are offlineD when some disks in a failure group for a disk group are rebalancing

考题 多选题Your database is running in the ARCHIVELOG mode. You have configured RMAN for backup and recovery operations. You execute the following command from the RMAN prompt:   RMAN CONFIGURE CONTROLFILE AUTOBACKUP ON;   After executing this command, in which of the following cases will RMAN make an auto-backup of the control file? ()Awhen you change the name of a datafileBwhen you drop a table from the databaseCwhen you take an export of the databaseDwhen you back up the database using OS utilitiesEwhen you issue an ALTER SYSTEM SWITCH LOGFILE statementFwhen you issue a BACKUP command from inside the RMAN run block

考题 单选题Consider the following scenario: You have a directory, data, under the disk group tdgroupA. You want to create an alias for one of the data files and you execute the following command: ALTER DISKGROUP tdgroupA  ADD ALIAS ’+tdgroupA/data/datafile.dbf’  FOR ’+tdgroupA.231.45678’;  Which task would be accomplished by the command?()A The command drops the file +tdgroupA·231.45678.B The command physically relocates the file to +tdgroupA/data and renames the file to datafile.dbf.C The command creates a copy of the +tdgroupA·231.45678 file and places it in +tdgroupA/data after renaming the file to datafile.dbf.D The command creates an alias, datafile.dbf, and places it in +tdgroupA/data and does not remove the +tdgroupA·231.45678 file.E The command creates a file, datafile.dbf, in +tdgroupA/data and removes the references for +tdgroupA·231.45678 from the data dictionary views.

考题 单选题You discover an out-of-space condition in the database. You decide to suspend a session for five minutes. You issue the following command to suspend the session:   ALTER SESSION ENABLE RESUMABLE;   Which command could you issue to enable the resumable space allocation feature at the session level?()A  ALTER SESSION ENABLE RESUMABLE_TIMEOUT = 5;B  ALTER SYSTEM ENABLE RESUMABLE_TIMEOUT = 5;C  ALTER SESSION ENABLE RESUMABLE_TIMEOUT = 300;D  ALTER SYSTEM ENABLE RESUMABLE TIMEOUT = 300;