网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
In which scenario is a Database Administrator NOT required to perform an incomplete recovery？（）
A
when all the online redo log groups are multiplexed and one of the members of a group is missing
B
when all the online redo log groups are not multiplexed and one log group is missing
C
when all the control files are missing
D
when some important tables are deleted from the database and purged from the Recycle Bin
参考答案
参考解析
解析：
暂无解析
更多 “单选题In which scenario is a Database Administrator NOT required to perform an incomplete recovery？（）A when all the online redo log groups are multiplexed and one of the members of a group is missingB when all the online redo log groups are not multiplexed and one log group is missingC when all the control files are missingD when some important tables are deleted from the database and purged from the Recycle Bin” 相关考题
考题
Which of the following is not responsibility of DBA(Data Base Administrator)?A．Database management system designB．Database schema definitionC．Database schema modificationD．Integrity constraint specification
考题
Which three actions are required to configure the Flashback Database? ()
A. set Flash Recovery AreaB. enable Flashback loggingC. create FLASHBACK tablespaceD. start the database in the ARCHIVELOG modeE. start the database in the NOARCHIVELOG mode
考题
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
考题
A route－based VPN is required for which scenario? ()
A. when the remote VPN peer is behind a NAT deviceB. when multiple networks need to be reached across the tunnelC. when the remote VPN peer is a dialup or remote access clientD. when a dynamic routing protocol such as OSPF is required across the VPN
考题
An administrator has added a new device to a system and wants to determine if it has been correctly added to the ODM database. Which command would the system administrator use？（）A、odmgetB、odmaddC、odmshowD、odmcreate
考题
An administrator is setting up a security camera that will send the same feed to twelve of the twenty workstations on the network. Which of the following addressing schemes was designed for this scenario?（）A、MulticastB、UnicastC、BroadcastD、Peer-to-peer
考题
A route-based VPN is required for which scenario？（）A、when the remote VPN peer is behind a NAT deviceB、when multiple networks need to be reached across the tunnel and GRE cannot be usedC、when the remote VPN peer is a dialup or remote access clientD、when a dynamic routing protocol is required across the VPN and GRE cannot be used
考题
You work as a database administrator for Supportcenter.cn. The database is open. A media failure has occurred， resulting in loss of all the control files in your database. Which statement regarding the database instance is true in this scenario？（）A、The instance would hang.B、The instance needs to be shut down.C、The instance would be in the open state.D、The instance would abort in such cases.E、The instance would be in the open and invalid state.F、The instance would in the open state， but all the background processes will be restarted.
考题
Your database is running in the ARCHIVELOG mode. You placed a tablespace， tbs_1， offline with the immediate option. Which statement is correct in this scenario？ （）A、The operation would fail if tbs_1 were a read-only tablespace.B、The operation would fail if tbs_1 were a read/write tablespace.C、The operation would fail if tbs_1 were the default tablespace for the database.D、If the above operation were successful， media recovery would be required to bring the tablespace online.E、If the above operation were successful， instance recovery would be required to bring the tablespace online.
考题
In which scenario will you perform a cancel-based recovery？（）A、 when a tablespace is dropped and you have only RMAN-based backup of the databaseB、 when a table is dropped and stored in the Recycle BinC、 when you are required to recover an existing table to its previous stateD、 when a tablespace is dropped and you have only a user-managed full backup of the database
考题
You are maintaining the SALES database for an organization. You have enabled the Flashback Database feature and want to estimate the flashback space required for future operations. Which view would you query to estimate the flashback space required？（）A、 V$DATABASEB、 V$FLASHBACK_DATABASE_STATC、 V$FLASHBACK_DATABASE_LOGD、 V$RECOVERY_FILE_DEST
考题
Identify two situations in which you can use Data Recovery Advisor for recovery.（） A、 The user has dropped an important table that needs to be recovered.B、 The database files are corrupted when the database is open.C、 You are not able to start up the database instance because the required database files are missing.D、 The archived log files are missing for which backup is not available.
考题
Which files are required for a full recovery of the database in ARCHIVELOG mode？（）A、 Database datafilesB、 Online redo logsC、 Archived redo logsD、 Backup control fileE、 Control file from a backup
考题
Which three actions are required to configure the Flashback Database？（） A、 set Flash Recovery AreaB、 enable Flashback loggingC、 create FLASHBACK tablespaceD、 start the database in the ARCHIVELOG modeE、 start the database in the NOARCHIVELOG mode
考题
In which scenario is a Database Administrator NOT required to perform an incomplete recovery？（）A、 when all the online redo log groups are multiplexed and one of the members of a group is missingB、 when all the online redo log groups are not multiplexed and one log group is missingC、 when all the control files are missingD、 when some important tables are deleted from the database and purged from the Recycle Bin
考题
You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 Enterprise Edition instance. There is a database named DB1 in the instance. A backup of DB1 is performed every day. You have to minimize the size of the full database backup files of DB1. In the options below, which Transact-SQL statement should you use? （） A、BACKUP DATABASE DB1 TO DISK = apos;t:/backups/db1.bakapos;; B、BACKUP DATABASE DB1 TO DISK = apos;t:/backups/db1.bakapos; WITH COMPRESSION; C、BACKUP DATABASE DB1 TO DISK = apos;t:/backups/db1.bakapos; WITH DIFFERENTIAL; D、BACKUP DATABASE DB1 TO DISK = apos;t:/backups/db1.bakapos; WITH COMPRESSION,DIFFERENTIAL;
考题
单选题In which scenario will you perform a cancel-based recovery？（）A
when a tablespace is dropped and you have only RMAN-based backup of the databaseB
when a table is dropped and stored in the Recycle BinC
when you are required to recover an existing table to its previous stateD
when a tablespace is dropped and you have only a user-managed full backup of the database
考题
多选题Which three actions are required to configure the Flashback Database？（）Aset Flash Recovery AreaBenable Flashback loggingCcreate FLASHBACK tablespaceDstart the database in the ARCHIVELOG modeEstart the database in the NOARCHIVELOG mode
考题
单选题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
考题
多选题Your database operates in ARCHIVELOG mode and all the tablespaces are online. Due to a user error， you decided to perform an incomplete recovery. Which two tasks would you be required to perform in the recovery process？ （）Aopen the database with the RESETLOGS optionBopen the database with the RESTRICTED optionCrecover all the data files to the same system change number （SCN）Drecover to the required SCN only that data file in which the error occurred
考题
单选题In which scenario is a Database Administrator NOT required to perform an incomplete recovery？（）A
when all the online redo log groups are multiplexed and one of the members of a group is missingB
when all the online redo log groups are not multiplexed and one log group is missingC
when all the control files are missingD
when some important tables are deleted from the database and purged from the Recycle Bin
考题
单选题You work as a database administrator for Supportcenter.cn. The database is open. A media failure has occurred， resulting in loss of all the control files in your database. Which statement regarding the database instance is true in this scenario？（）A
The instance would hang.B
The instance needs to be shut down.C
The instance would be in the open state.D
The instance would abort in such cases.E
The instance would be in the open and invalid state.F
The instance would in the open state， but all the background processes will be restarted.
考题
单选题A route-based VPN is required for which scenario? （）A
when the remote VPN peer is behind a NAT deviceB
when multiple networks need to be reached across the tunnelC
when the remote VPN peer is a dialup or remote access clientD
when a dynamic routing protocol such as OSPF is required across the VPN
考题
单选题You are maintaining the SALES database for an organization. You have enabled the Flashback Database feature and want to estimate the flashback space required for future operations. Which view would you query to estimate the flashback space required？（）A
V$DATABASEB
V$FLASHBACK_DATABASE_STATC
V$FLASHBACK_DATABASE_LOGD
V$RECOVERY_FILE_DEST
考题
多选题Your database operates in ARCHIVELOG mode and all the tablespaces are online. Due to a user error， you decided to perform an incomplete recovery. Which two tasks would you be required to perform in the recovery process？（）Aopen the database with the RESTRICTED optionBopen the database with the RESETLOGS optionCrecover to the required SCN only that data file in which the error occurredDrecover all the data files to the same system change number （SCN）
考题
单选题Management has decided that the database must be available 24 hours a day， 7 days a week. Given this requirement， which type of backup is required？（）A
user-managed backups.B
partial database backups.C
consistent database backups.D
inconsistent database backups.
考题
单选题Your database is running in the ARCHIVELOG mode. You placed a tablespace， tbs_1， offline with the immediate option. Which statement is correct in this scenario？ （）A
The operation would fail if tbs_1 were a read-only tablespace.B
The operation would fail if tbs_1 were a read/write tablespace.C
The operation would fail if tbs_1 were the default tablespace for the database.D
If the above operation were successful， media recovery would be required to bring the tablespace online.E
If the above operation were successful， instance recovery would be required to bring the tablespace online.
考题
多选题You work as a database administrator for Certkiller .com. In the middle of a transaction， a user session was abnormally terminated but the instance is still up and the database is open. Which two statements are true in this scenario？（）AEvent Viewer gives more details on the failure.BThe alert log file gives detailed information about the failure.CPMON rolls back the transaction and releases the locks.DSMON rolls back the transaction and releases the locks.EThe transaction is rolled back by the next session that refers to any of the blocks updates by the failed transaction.FData modified by the transaction up to the last commit before the abnormal termination is retained in the database.
热门标签
最新试卷
