网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
What type of protection is implemented when the DBA issues the ALTER DATABASE SET STANDBY DATABASE PROTECTED； command？（）
A
The standby database is protected against write operations.
B
The primary database is protected against write operations.
C
The primary database is protected against data loss and data divergence.
D
The standby database is protected against data loss and data divergence.
参考答案
参考解析
解析：
暂无解析
更多 “单选题What type of protection is implemented when the DBA issues the ALTER DATABASE SET STANDBY DATABASE PROTECTED； command？（）A The standby database is protected against write operations. B The primary database is protected against write operations. C The primary database is protected against data loss and data divergence. D The standby database is protected against data loss and data divergence. ” 相关考题
考题
What are three purposes of the RMAN “FROM” clause?()
A. to support PUSH-based active database duplicationB. to support synchronization of a standby database with the primary database in a Data environmentC. To support PULL-based active database duplicationD. To support file restores over the network in a Data Guard environmentE. To support file recovery over the network in a Data Guard environment
考题
Which three attributes of the LOG_ARCHIVE_DEST_n initialization parameter control the data availability mode of a Data Guard standby database？ （）A、SYNC or ASYNC to identify the network transmission mode. B、LGWR or ARCH to identify the primary database process responsible for sending redo information to the standby. C、AFFIRM or NOAFFIRM to control whether log archiving disk write operations are to be performed synchronously or asynchronously. D、PROTECTED or UNPROTECTED to control the degree of divergence and data loss at the standby database.
考题
While an electrician was adding additional circuits for the Data Center， the system running the Database inadvertently powered down. The fallover of the service IP labels and volume groups to the hot standby node completed as expected； however， the database did not start. The database log file indicated that the database was already started. What is the most likely cause of this problem？（） A、 The shared logical volumes and filesystems did not have database permissions.B、 There was a test instance running on the standby system that must be shutdown.C、 The tablespaces had an indicator indicating that the database had not shutdown properly.D、 The startup script for the highly available instance did not first perform cleanup operations.
考题
You find today’s performance of your production database to be the best ever. Therefore， you want to be notified in the future whenever the performance degrades by 10% of today’s performance. What is the first step that you would take to ensure this？（）A、create baseline metrics for today’s performanceB、write the current database metrics to a database table and create a trigger to compare with future database statisticsC、write the current database metrics to a flat file and create an operating script to compare with future database statisticsD、write the current database metrics to a database table and create a procedure to compare with future database statisticsE、write the current database metrics to a database table and submit a job using DBMS_JOB to compare with future database statistics
考题
The list below displays four steps that you need to execute in order to switch from the primary database role to the standby database role. Choose the correct order of execution for the steps.（） 1. Shot down and start up the former primary instance without mounting the instance. 2. Issue the ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY command. 3. Issue the ALTER DATABASE MOUNTS STANDBY DATABASE command. 4. End read or update activity on the former primary and standby database.A、1，2，3，4B、3，2，4，1C、4，2，1，3D、4，3，2，1
考题
RMAN enables you to open the target database when it is already mounted. Which command must you execute at the RMAN prompt to open the database？（）A、’SQL ALTER DATABASE OPEN’；B、SQL ALTER DATABASE ’OPEN’；C、OPEN DATABASE；D、DATABASE OPEN
考题
Which command is used to open the database after an incomplete recovery？（）A、 alter database openB、 alter database open repairlogC、 alter database open resetlogsD、 alter database open resetlogE、 alter database resetlogs open
考题
The database is currently running in the NOARCHIVELOG mode. What would be the first step to configure Flashback Database？（）A、 Enable flashback logging.B、 Start the database in the ARCHIVELOG mode.C、 Issue the ALTER DATABASE FLASHBACK ON； command.D、 Set the FAST_START_MTTR_TARGET initialization parameter.
考题
What type of protection is implemented when the DBA issues the ALTER DATABASE SET STANDBY DATABASE PROTECTED； command？（）A、The standby database is protected against write operations. B、The primary database is protected against write operations. C、The primary database is protected against data loss and data divergence. D、The standby database is protected against data loss and data divergence.
考题
When performing a full database disaster recovery with RMAN， in what order would you execute these steps？（） a. Restore the control file from autobackups. b. Run the RMAN restore and recover command. c.Restore the database spfile from autobackups. d. Make the RMAN backup set pieces available. e. Open the database with the alter database open resetlogs command. f.Open the database with the alter database open command. A、 a， b， c， d， e， fB、 c， d， a， b， fC、 d， c， a， b， fD、 d， b， d， c， eE、 d， c， a， b， e
考题
You are managing a single instance Oracle 10g database that utilizes the following parameters： Which of the following set of commands must you execute to enable Flashback Database？（）A、 STARTUP MOUNT EXCLUSIVE ALTER DATABASE FLASHBACK ON； ALTER DATABASE OPEN；B、 STARTUP MOUNT ALTER DATABASE FLASHBACK ON； ALTER DATABASE OPEN RESETLOGS；C、 STARTUP MOUNT EXCLUSIVE ATLER DATABASE ARCHIVELOG； ALTER DATABASE FLASHBACK ON； ALTER DATABASE OPEN RESETLOGS；D、 STARTUP MOUNT ALTER DATABASE ARCHIVELOG； ALTER DATABASE FLASHBACK ON； ALTER DATABASE OPEN；
考题
Adam is working as a Database Administrator （DBA） for TeleSoft Corporation. His database is running in the ARCHIVELOG mode. During database startup， he discovers that one of the disks crashed， resulting in the permanent loss of a read-write USERS tablespace. The USERS01.dbf datafile belongs to the USERS tablespace and is 500 MB in size. He needs to recover the USERS tablespace from the backup. While reviewing the backup details， he discovers that the most recent available backup is five days old. This backup was taken when the USERS tablespace was read-only. After correcting the hardware problem that caused the failure， what should Adam do to recover the USERS tablespace？（）A、 Restore the USERS01.dbf file from the backup， and open the database using the STARTUP command.B、 Restore the USERS01.dbf file using the RECOVER TABLESPACE command， and open the database using the ALTER DATABASE OPEN statement.C、 Restore the USERS01.dbf file from the backup， recover the USERS tablespace using the RECOVER TABLESPACE command， and open the database using the ALTER DATABASE OPEN statement.D、 Restore the USERS01.dbf file from the backup and change the status of the USERS tablespace from read-only to read-write using the ALTER TABLESPACE USERS READ WRITE statement. Then， recover the USERS tablespace using the RECOVER TABLESPACE command， and open the database using the ALTER DATABASE OPEN statement.
考题
A user issues a SELECT command against the Oracle database. Which of the following choices describes a step that Oracle will execute in support of this statement?（）A、Acquire locks on table queried B、Generate redo for statement C、Fetch data from disk into memory D、Write changes to disk
考题
What are three purposes of the RMAN “FROM” clause?（）A、to support PUSH-based active database duplicationB、to support synchronization of a standby database with the primary database in a Data environmentC、To support PULL-based active database duplicationD、To support file restores over the network in a Data Guard environmentE、To support file recovery over the network in a Data Guard environment
考题
You are a database administrator for your company. The company uses a vendor company’s application that is based on a proprietary database. You query data from the application database and import the data into a SQL Server 2005 database. The application vendor provides you with a new OLE DB driver to be used when querying the application database. Company policy prohibits connections between the SQL Server database and the application database， except when querying this data. You need to provide a way to query data from the application database. What should you？（）A、Configure a Linked Server connection to the application database.B、Write a query that uses an OPENDATASOURCE command.C、Write a query that uses an OPENQUERY command.D、Configure a Remote Server connection to the application database.
考题
单选题While an electrician was adding additional circuits for the Data Center， the system running the Database inadvertently powered down. The fallover of the service IP labels and volume groups to the hot standby node completed as expected； however， the database did not start. The database log file indicated that the database was already started. What is the most likely cause of this problem？（）A
The shared logical volumes and filesystems did not have database permissions.B
There was a test instance running on the standby system that must be shutdown.C
The tablespaces had an indicator indicating that the database had not shutdown properly.D
The startup script for the highly available instance did not first perform cleanup operations.
考题
单选题Which command will result in a trace file being created with the create controlfile command contained in it？（）A
alter database backup controlfileB
alter database backup controlfile to traceC
alter database controlfile backupD
alter database controlfile backup to ’/ora01/oracle/ctrl_backup.ctl’E
alter database begin controlfile backup
考题
单选题The database is currently running in the NOARCHIVELOG mode. What would be the first step to configure Flashback Database？（）A
Enable flashback logging.B
Start the database in the ARCHIVELOG mode.C
Issue the ALTER DATABASE FLASHBACK ON； command.D
Set the FAST_START_MTTR_TARGET initialization parameter.
考题
单选题What type of protection is implemented when the DBA issues the ALTER DATABASE SET STANDBY DATABASE PROTECTED； command？（）A
The standby database is protected against write operations. B
The primary database is protected against write operations. C
The primary database is protected against data loss and data divergence. D
The standby database is protected against data loss and data divergence.
考题
单选题The list below displays four steps that you need to execute in order to switch from the primary database role to the standby database role. Choose the correct order of execution for the steps.（） 1. Shot down and start up the former primary instance without mounting the instance. 2. Issue the ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY command. 3. Issue the ALTER DATABASE MOUNTS STANDBY DATABASE command. 4. End read or update activity on the former primary and standby database.A
1，2，3，4B
3，2，4，1C
4，2，1，3D
4，3，2，1
考题
单选题Adam is working as a Database Administrator （DBA） for TeleSoft Corporation. His database is running in the ARCHIVELOG mode. During database startup， he discovers that one of the disks crashed， resulting in the permanent loss of a read-write USERS tablespace. The USERS01.dbf datafile belongs to the USERS tablespace and is 500 MB in size. He needs to recover the USERS tablespace from the backup. While reviewing the backup details， he discovers that the most recent available backup is five days old. This backup was taken when the USERS tablespace was read-only. After correcting the hardware problem that caused the failure， what should Adam do to recover the USERS tablespace？（）A
Restore the USERS01.dbf file from the backup， and open the database using the STARTUP command.B
Restore the USERS01.dbf file using the RECOVER TABLESPACE command， and open the database using the ALTER DATABASE OPEN statement.C
Restore the USERS01.dbf file from the backup， recover the USERS tablespace using the RECOVER TABLESPACE command， and open the database using the ALTER DATABASE OPEN statement.D
Restore the USERS01.dbf file from the backup and change the status of the USERS tablespace from read-only to read-write using the ALTER TABLESPACE USERS READ WRITE statement. Then， recover the USERS tablespace using the RECOVER TABLESPACE command， and open the database using the ALTER DATABASE OPEN statement.
考题
单选题Which is the correct command to put the database in ARCHIVELOG mode？（）A
alter database archivelogB
alter system enable archivelog modeC
alter database enable archiveD
alter database archivelog enableE
None of the above
考题
单选题RMAN enables you to open the target database when it is already mounted. Which command must you execute at the RMAN prompt to open the database？（）A
’SQL ALTER DATABASE OPEN’；B
SQL ALTER DATABASE ’OPEN’；C
OPEN DATABASE；D
DATABASE OPEN
考题
单选题Which command is used to open the database after an incomplete recovery？（）A
alter database openB
alter database open repairlogC
alter database open resetlogsD
alter database open resetlogE
alter database resetlogs open
考题
单选题When performing a full database disaster recovery with RMAN， in what order would you execute these steps？（） a. Restore the control file from autobackups. b. Run the RMAN restore and recover command. c.Restore the database spfile from autobackups. d. Make the RMAN backup set pieces available. e. Open the database with the alter database open resetlogs command. f.Open the database with the alter database open command.A
a， b， c， d， e， fB
c， d， a， b， fC
d， c， a， b， fD
d， b， d， c， eE
d， c， a， b， e
考题
单选题You are managing a single instance Oracle 10g database that utilizes the following parameters： Which of the following set of commands must you execute to enable Flashback Database？（）A
STARTUP MOUNT EXCLUSIVE ALTER DATABASE FLASHBACK ON； ALTER DATABASE OPEN；B
STARTUP MOUNT ALTER DATABASE FLASHBACK ON； ALTER DATABASE OPEN RESETLOGS；C
STARTUP MOUNT EXCLUSIVE ATLER DATABASE ARCHIVELOG； ALTER DATABASE FLASHBACK ON； ALTER DATABASE OPEN RESETLOGS；D
STARTUP MOUNT ALTER DATABASE ARCHIVELOG； ALTER DATABASE FLASHBACK ON； ALTER DATABASE OPEN；
考题
单选题If you issue the command shutdown abort prior to trying to put the database in ARCHIVELOG mode， what will be the result when you issue the command alter database archivelog？（）A
The alter database archivelog command will failB
The alter database archivelog inconsistent command must be used to put the database in ARCHIVELOG modeC
The alter database archivelog command will succeedD
The alter database archivelog command will ask if you want to make the database consistent firstE
There is no alter database archivelog command. The correct command is alter database alterlogging
考题
多选题Which three attributes of the LOG_ARCHIVE_DEST_n initialization parameter control the data availability mode of a Data Guard standby database？ （）ASYNC or ASYNC to identify the network transmission mode.BLGWR or ARCH to identify the primary database process responsible for sending redo information to the standby.CAFFIRM or NOAFFIRM to control whether log archiving disk write operations are to be performed synchronously or asynchronously.DPROTECTED or UNPROTECTED to control the degree of divergence and data loss at the standby database.
热门标签
最新试卷