网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
In which situation are you NOT required to perform an incomplete recovery？（）
A
when all the control files are lost
B
when all the members of a redo log group are lost
C
when a table is dropped and purged from the Recycle Bin
D
when a temporary file of the default temporary tablespace is lost
参考答案
参考解析
解析：
暂无解析
更多 “单选题In which situation are you NOT required to perform an incomplete recovery？（）A when all the control files are lostB when all the members of a redo log group are lostC when a table is dropped and purged from the Recycle BinD when a temporary file of the default temporary tablespace is lost” 相关考题
考题
Examine the CREATE DISKGROUP command used to create a disk group:In which situation would you use this method of disk group creation?()
A. When two-way disk mirroring is required for the allocation unitsB. When three-way disk mirroring is required for the allocation unitsC. When using hardware mirroring or RAIDD. When disk mirroring is required for the Automatic Storage Management (ASM) disks
考题
As a network administrator, you are required to configure a switch port for a private Virtual LAN. In such a situation, which three of the following connection modes will be available during the configuration process? （）(Choose three.)A. isolated modeB. modular modeC. community modeD. promiscuous modeE. non-isolatedF. permanent
考题
As an experienced technician, you are required to configure and verify SRM with SSO redundancy. In such a situation, you have to issue several commands in proper orders. Which of the following is correct?（）A. show redundancy states, redundancy, mode ssoB. show redundancy states, mode sso, redundancyC. redundancy, mode sso, show redundancy statesD. mode sso, redundancy, show redundancy states
考题
You are employed as a DBA in an organization. You are informed that the record of EMP_NO 1000 is missing from the SCOTT.EMP table. You are required to identify the user who deleted the record， the SQL statement that will undo the deletion， and the transaction ID of the transaction that deleted the employee record. Which feature will you use to perform the tasks？（）A、 Only the Flashback TableB、 Both the Flashback Transaction Query and the Flashback Version QueryC、 Only the Flashback DropD、 Only the Flashback Version
考题
As a network administrator, you are required to configure a switch port for a private Virtual LAN. In such a situation, which three of the following connection modes will be available during the configuration process? （）(Choose three.)A、isolated modeB、modular modeC、community modeD、promiscuous modeE、non-isolatedF、permanent
考题
As an experienced Network Engineer, you are required to characterize an existing CIS network. In such a situation, what is the last step to take?（）A、Perform a network audit.B、Form an impression about the network.C、Use traffic analysis to augment organizational input.D、Prepare and add to the network description.
考题
You are in the middle of a transaction updating a very important table. The machine on which a database wasrunning reboots because of power outage. This caused a database instance failure. Which statement is true inthis situation（）A、The online redo log files and archived redo log files are required to accomplish the recovery.B、The uncommitted transaction will be committed at the next startup of the database instance.C、The uncommitted transaction is rolled back automatically at the next opening of the database.D、The DBA has to perform the recovery on the database to recover the uncommitted transaction
考题
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 of the following restrictions are not true with respect to tablespace point-in-time recovery？（）A、 The target database must be in NOARCHIVELOG mode.B、 No backup is required of the database before you perform a TSPITR.C、 You must have all archived redo logs generated since the last backup up to the point to which you want to restore the transport set.D、 If you rename a tablespace， you can not perform a TSPITR to any point in time before that rename operation occurred.E、 If you have tables in tablespace_1 that have associated constraints in tablespace_2，then you must transport both tablespaces.
考题
In which scenario will you perform a user-managed incomplete recovery？（）A、 when a table is dropped and stored in the Recycle BinB、when a table is dropped and purged from the Recycle BinC、 when you are required to recover an existing table to its previous stateD、 when you are required to view all the versions of a row of an existing table between a specific time period
考题
You are required to flashback your database. You want to find the amount of flashback data generated since the database was opened. Which task will you perform to obtain the required information？（）A、 Query the V$FLASHBACK_DATABASE_LOG view.B、 Query the V$FLASHBACK_DATABASE_STAT view.C、 Check the value of the DB_FLASHBACK_RETENTION_TARGET initialization parameter.D、 Query the V$RECOVERY_FILE_DEST view.
考题
In which scenario will you perform an incomplete recovery？（）A、 when a table is dropped and stored in the Recycle BinB、 when all the control files are deletedC、 when a member of a multiplexed redo log group is droppedD、 when you are required to recover a table to its previous state
考题
In which situation are you NOT required to perform an incomplete recovery？（）A、 when all the control files are lostB、 when all the members of a redo log group are lostC、 when a table is dropped and purged from the Recycle BinD、 when a temporary file of the default temporary tablespace is lost
考题
You have a server named Server1 that runs Windows Server 2003 Service Pack 2 (SP2). You perform a normal backup of Server1 every Saturday. You need to implement a backup strategy for Server1 to meet the following requirements: ·Minimize the time required to restore files. ·On weekdays, back up only files that have changed since the Saturday backup. Which type of backup should you perform on weekdays? （）A、copyB、dailyC、differentialD、incremental
考题
单选题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 want to back up your 100-GB database on a remote tape device. You are required to ensure that minimum network bandwidth is consumed while transferring the backups to the tape device. The current consumption of your CPU is approximately 40 percent.Which type of backup should you perform?（）A
standard backup setB
image copyC
compressed backupD
user-managed backup
考题
多选题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
考题
问答题Practice 3You are required to write a letter to the post office in your university or in the nearby neighborhood to tell them that you haven't received a parcel which your friend send you for your birthday. In the letter you should cover the following information:(1) explain your situation,(2) tell them what are there in the parcel, and(3) tell them what you want them to do about it.Write at least 150 words.You do NOT need to write any addresses.
考题
单选题As an experienced technician, you are required to configure and verify SRM with SSO redundancy. In such a situation, you have to issue several commands in proper orders. Which of the following is correct?（）A
show redundancy states, redundancy, mode ssoB
show redundancy states, mode sso, redundancyC
redundancy, mode sso, show redundancy statesD
mode sso, redundancy, show redundancy states
考题
单选题You are in the middle of a transaction updating a very important table. The machine on which a database wasrunning reboots because of power outage. This caused a database instance failure. Which statement is true inthis situation（）A
The online redo log files and archived redo log files are required to accomplish the recovery.B
The uncommitted transaction will be committed at the next startup of the database instance.C
The uncommitted transaction is rolled back automatically at the next opening of the database.D
The DBA has to perform the recovery on the database to recover the uncommitted transaction
考题
单选题You want to back up your 100-GB database on a remote tape device. You are required to ensure that minimum network bandwidth is consumed while transferring the backups to the tape device. The current consumption of your CPU is approximately 40 percent. Which type of backup should you perform？（）A
standard backup setB
image copyC
compressed backupD
user-managed backup
考题
多选题As a network administrator, you are required to configure a switch port for a private Virtual LAN. In such a situation, which three of the following connection modes will be available during the configuration process? （）(Choose three.)Aisolated modeBmodular modeCcommunity modeDpromiscuous modeEnon-isolatedFpermanent
考题
单选题In which scenario will you perform a user-managed incomplete recovery？（）A
when a table is dropped and stored in the Recycle BinB
when a table is dropped and purged from the Recycle BinC
when you are required to recover an existing table to its previous stateD
when you are required to view all the versions of a row of an existing table between a specific time period
考题
多选题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）
考题
单选题In which scenario will you perform an incomplete recovery？（）A
when a table is dropped and stored in the Recycle BinB
when all the control files are deletedC
when a member of a multiplexed redo log group is droppedD
when you are required to recover a table to its previous state
考题
单选题In which situation are you NOT required to perform an incomplete recovery？（）A
when all the control files are lostB
when all the members of a redo log group are lostC
when a table is dropped and purged from the Recycle BinD
when a temporary file of the default temporary tablespace is lost
考题
多选题Which of the following restrictions are not true with respect to tablespace point-in-time recovery？（）AThe target database must be in NOARCHIVELOG mode.BNo backup is required of the database before you perform a TSPITR.CYou must have all archived redo logs generated since the last backup up to the point to which you want to restore the transport set.DIf you rename a tablespace， you can not perform a TSPITR to any point in time before that rename operation occurred.EIf you have tables in tablespace_1 that have associated constraints in tablespace_2，then you must transport both tablespaces.
考题
单选题You are required to flashback your database. You want to find the amount of flashback data generated since the database was opened. Which task will you perform to obtain the required information？（）A
Query the V$FLASHBACK_DATABASE_LOG view.B
Query the V$FLASHBACK_DATABASE_STAT view.C
Check the value of the DB_FLASHBACK_RETENTION_TARGET initialization parameter.D
Query the V$RECOVERY_FILE_DEST view.
热门标签
最新试卷