网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
In what view are you likely to see the following output？（） SID SERIAL# EVENT SECONDS_IN_WAIT 121 269 RMAN backup & recovery I/O 2 129 415 SQL*Net message from client 63 130 270 SQL*Net message from client
A
V$SESSION_EVENT
B
V$SESSION
C
V$WAITS
D
V$WAITSTAT
E
V$SYSSTAT
参考答案
参考解析
解析：
暂无解析
更多 “单选题In what view are you likely to see the following output？（） SID SERIAL# EVENT SECONDS_IN_WAIT 121 269 RMAN backup recovery I/O 2 129 415 SQL*Net message from client 63 130 270 SQL*Net message from clientA V$SESSION_EVENTB V$SESSIONC V$WAITSD V$WAITSTATE V$SYSSTAT” 相关考题
考题
A Windows Communication Foundation (WCF) service only accepts messages that are signed and encrypted. A client application is not receiving expected responses from the service. You need to enable logging to verify that the messages from the client are signed and encrypted. You also need to see what each message looks like before the message body is deserialized into a NET object. What should you do?（）A.B.C.D.
考题
Whatviewmightyouusetotrytodeterminehowlongaparticularbackupwilltake?()
A.V$SESSION_EVENTB.V$SESSIONC.V$WAITSD.V$WAITSTATE.V$SESSION_LONGOPS
考题
Inwhatviewareyoulikelytoseethefollowingoutput?()SIDSERIALEVENTSECONDS_IN_WAIT121269RMANbackuprecoveryI／O2129415SQL*Netmessagefromclient63130270SQL*Netmessagefromclient
A.V$SESSION_EVENTB.V$SESSIONC.V$WAITSD.V$WAITSTATE.V$SYSSTAT
考题
A view is created with the following statement:CREATE VIEW v1 AS SELECT col1, col2, col3 FROM t1 WHERE col4 > 1000 ; When will DB2 access the data from table T1 for view V1?()
A.When view V1 is createdB.Each time the REFRESH VIEW v1 statement is executedC.Each time an SQL statement is executed against view V1D.Only the first time an SQL statement is executed against view V1
考题
Given the following DDL and INSERT statements:CREATE VIEW v1 AS SELECT col1 FROM t1 WHERE col1 10; CREATE VIEW v2 AS SELECT col1 FROM v1 WITH CASCADED CHECK OPTION; CREATE VIEW v3 AS SELECT col1 FROM v2 WHERE col1 100; INSERT INTO v1 VALUES(5); INSERT INTO v2 VALUES(5); INSERT INTO v3 VALUES(20); INSERT INTO v3 VALUES(100);How many of these INSERT statements will be successful?（）A.0B.1C.2D.3
考题
You are evaluating the use of pass-through disks for the database servers. You need to recommend a backup solution for the database servers that meets the following requirements： - Minimizes costs. - Provides for the recovery of the databases if a hardware failure occurs. What should you include in the recommendation？（）A、Create full backups of the Hyper-V host by using Windows Server BackupB、Create snapshots of the VMs from Hyper-V ManagerC、Create full backups of the Hyper-V host by using Microsoft System Center Data Protection ManagerD、Create full backups of the VMs by using Windows Server Backup from within the VMs
考题
Your network contains Microsoft System Center Virtual Machine Manager and 10 Hyper-V hosts. You plan to convert all of the domain controllers to virtual machines （VMs）. You need to recommend a recovery solution for the domain controllers. The solution must meet the following requirements： - Prevent inconsistencies in the Active Directory database. - Provide for the recovery of accidentally deleted Active Directory objects. - Provide for recovery if an administrator incorrectly modifies system settings. What should you include in the recommendation？（）A、VM snapshotsB、a VM checkpointC、Windows Server Backup from within the VMsD、Windows Server Backup from the Hyper-V hosts
考题
You defined the Recovery Manager （RMAN） retention policy to recovery window of 7 days by executing the following command： RMAN CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS； When a backup is performed， what would be the status of this backup after seven days？（）A、 The backup would be marked as invalid.B、 The backup would be marked as obsolete.C、 The backup would be removed from the media.D、 The backup would be removed from the RMAN repository.
考题
You used the following command in Recovery Manager （RMAN） as part of the recovery process： RESTORE CONTROLFILE FROM AUTOBACKUP； How does RMAN find the control file autobackup？（）A、 By using the trace file.B、 By using the alert log file.C、 By using the database IDD、 By using the server parameter file.E、 By using the V$CONTROLFILE view.F、 By using the autobackup format configuration setting.
考题
What view might you use to try to determine how long a particular backup will take?（）A、V$SESSION_EVENT B、V$SESSION C、V$W0041ITSD、V$WAITSTAT E、V$SESSION_LONGOPS
考题
When tuning Automatic PGA Memory Management， which of the following views will provide the information specified？（） A、 The V$PGA_TARGET_ADVICE view shows the predicted cache hit-ratio improvement if you increase PGA_AGGREGATE_TARGETB、 The V$PGA_TARGET_ADVICE view shows how the V$SQL_WORKAREA histogram will change if you change the value of PGA_AGGREGATE_TARGETC、 The V$PGA_TARGET_ADVICE_HISTOGRAM view shows how the V$SQL_WORKAREA_HISTOGRAM will change if you switch between Manual and Automatic PGA Memory ManagementD、 The V$PGA_TARGET_ADVICE view shows how performance will improve for the different work areas if you switch from Manual to Automatic PGA Memory Management
考题
A database user SMITH tries to query the V$SESSION view and fails to access it as follows： SQL connect smith/smith Connected. SQL SELECT * FROM v$session； SELECT * FROM v$session * ERROR at line 1： ORA-00942： table or view does not exist Which are the two possible solutions to enable SMITH to query the data in V$SESSION（）A、granting SELECT privilege to SMITH on V$SESSIONB、granting SELECT privilege to SMITH on V_$SESSIONC、asking the user SMITH to run the catalog.sql scriptD、granting SELECT privilege to SMITH on V$FIXED_TABLESE、setting the O7_DICTIONARY_ACCESSIBILITY parameter to TRUEF、creating a view based on V$SESSION and granting SELECT privilege to SMITH on the view that was created
考题
In what view are you likely to see the following output？（） SID SERIAL# EVENT SECONDS_IN_WAIT 121 269 RMAN backup recovery I/O 2 129 415 SQL*Net message from client 63 130 270 SQL*Net message from client A、 V$SESSION_EVENTB、 V$SESSIONC、 V$WAITSD、 V$WAITSTATE、 V$SYSSTAT
考题
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.
考题
What view might you use to try to determine how long a particular backup will take？（） A、 V$SESSION_EVENTB、 V$SESSIONC、 V$WAITSD、 V$WAITSTATE、 V$SESSION_LONGOPS
考题
If you find errors in the view V$DATABASE_BLOCK_CORRUPTION with a status of MEDIA_CORRUPT， what RMAN command would you run to correct the problem？（）A、 recover lost blocksB、 recover corrupt blocksC、 recover media corrupt blocks from listD、 recover corrupt blocks from listE、 recover corruption list
考题
You have a Web server that runs Windows Server 2003 Service Pack 2 （SP2）.You attempt to start the World Wide Publishing Service and receive the following error message.You need to identify which services must be started before you can start the World Wide Web Publishing Service. What should you do？（）A、From Event Viewer， view the application log.B、From Windows Explorer， open the %systemroot%/system32/drivers/etc/services file.C、From the Services snap-in， view the properties of the World Wide Web Publishing Service.D、From the command prompt， run Net config server /srvcomment：”World Wide Web Publishing Service”.
考题
单选题You are evaluating the use of pass-through disks for the Exchange servers. You need to recommend a backup solution for the Exchange servers that meets the following requirements： - Minimizes costs. - Provides for the recovery of the Exchange databases if a hardware failure occurs. What should you include in the recommendation？（）A
Create snapshots of the VMs from Hyper-V ManagerB
Create full backups of the Hyper-V host by using Windows Server BackupC
Create full backups of the VMs by using Windows Server Backup from within the VMsD
Create full backups of the Hyper-V host by using Microsoft System Center Data Protection manager
考题
单选题What view might you use to try to determine how long a particular backup will take？（）A
V$SESSION_EVENTB
V$SESSIONC
V$WAITSD
V$WAITSTATE
V$SESSION_LONGOPS
考题
单选题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.
考题
单选题When tuning Automatic PGA Memory Management， which of the following views will provide the information specified？（）A
The V$PGA_TARGET_ADVICE view shows the predicted cache hit-ratio improvement if you increase PGA_AGGREGATE_TARGETB
The V$PGA_TARGET_ADVICE view shows how the V$SQL_WORKAREA histogram will change if you change the value of PGA_AGGREGATE_TARGETC
The V$PGA_TARGET_ADVICE_HISTOGRAM view shows how the V$SQL_WORKAREA_HISTOGRAM will change if you switch between Manual and Automatic PGA Memory ManagementD
The V$PGA_TARGET_ADVICE view shows how performance will improve for the different work areas if you switch from Manual to Automatic PGA Memory Management
考题
单选题You execute the following RMAN commands in the order shown below： BACKUP VALIDATE DATABASE; BLOCKRECOVER CORRUPTION LIST; What will these commands do？（）A
create a backup of the database and recover all corrupted blocks found in the backupB
run a backup validation and list all the logically corrupt blocks as well as physically corrupt blocks in the databaseC
run a backup validation to populate V$COPY_CORRUPTION view， and then list any corrupt blocks recorded in the viewD
run a backup validation to populate V$DATABASE_BLOCK_CORRUPTION view， and then repair any corrupt blocks recorded in the viewE
run a backup validation， repair any corrupt blocks found during the validation process， and then update V$DATABASE_BLOCK_CORRUPTION view to indicate which corrupt blocks have been repaired
考题
单选题A view is created with the following statement:CREATE VIEW v1 AS SELECT col1, col2, col3 FROM t1 WHERE col4 1000 ; When will DB2 access the data from table T1 for view V1?（）A
When view V1 is createdB
Each time the REFRESH VIEW v1 statement is executedC
Each time an SQL statement is executed against view V1D
Only the first time an SQL statement is executed against view V1
考题
单选题You are evaluating the use of pass-through disks for the database servers. You need to recommend a backup solution for the database servers that meets the following requirements： - Minimizes costs. - Provides for the recovery of the databases if a hardware failure occurs. What should you include in the recommendation？（）A
Create full backups of the Hyper-V host by using Windows Server BackupB
Create snapshots of the VMs from Hyper-V ManagerC
Create full backups of the Hyper-V host by using Microsoft System Center Data Protection ManagerD
Create full backups of the VMs by using Windows Server Backup from within the VMs
考题
多选题A database user SMITH tries to query the V$SESSION view and fails to access it as follows： SQL connect smith/smith Connected. SQL SELECT * FROM v$session； SELECT * FROM v$session * ERROR at line 1： ORA-00942： table or view does not exist Which are the two possible solutions to enable SMITH to query the data in V$SESSION（）Agranting SELECT privilege to SMITH on V$SESSIONBgranting SELECT privilege to SMITH on V_$SESSIONCasking the user SMITH to run the catalog.sql scriptDgranting SELECT privilege to SMITH on V$FIXED_TABLESEsetting the O7_DICTIONARY_ACCESSIBILITY parameter to TRUEFcreating a view based on V$SESSION and granting SELECT privilege to SMITH on the view that was created
考题
单选题You defined the Recovery Manager （RMAN） retention policy to recovery window of 7 days by executing the following command： RMAN CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS； When a backup is performed， what would be the status of this backup after seven days？（）A
The backup would be marked as invalid.B
The backup would be marked as obsolete.C
The backup would be removed from the media.D
The backup would be removed from the RMAN repository.
考题
单选题Your network contains Microsoft System Center Virtual Machine Manager and 10 Hyper-V hosts. You plan to convert all of the domain controllers to virtual machines （VMs）. You need to recommend a recovery solution for the domain controllers. The solution must meet the following requirements： - Prevent inconsistencies in the Active Directory database. - Provide for the recovery of accidentally deleted Active Directory objects. - Provide for recovery if an administrator incorrectly modifies system settings. What should you include in the recommendation？（）A
VM snapshotsB
a VM checkpointC
Windows Server Backup from within the VMsD
Windows Server Backup from the Hyper-V hosts
热门标签
最新试卷
