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

题目内容 (请给出正确答案)

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 client  A、 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 the newly appointed system administrator at Certkiller.com. You are in the process ofcreating a Microsoft ASP.NET application using Microsoft .NET Framework v3.5.  The new application will make use of eleven themes. Certkiller clients will be permitted to selecttheir themes from the Web page. You need to make sure that the theme selected by a client isdisplayed when the client returns to the application. This should occur even when the client returnsto log on at a later date or from another workstation.  You should take cognizance of the fact that the application operates on different storage types andin different environments. Management wants you tp store the themes selected by the clients aswell as retrieving the required theme.  What should you do?()A、This can be accomplished using the Response.Cookies collection in order to store the name ofthe theme that is selected by the client.B、This can be accomplished by retrieving the required theme name from the Session object everytime the client visits a page.C、This can be accomplished by retrieving the required theme name every time the client visits apage.D、This can be accomplished by retrieving the required theme name from the Application objectevery time the client visits a page.

考题 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

考题 You are planning the migration of an existing application to Windows Azure and SQL Azure. The current application includes reports that are hosted by SQL Server Reporting Services.  You need to recommend an approach for migrating the reports.  What should you recommend? ()A、 Use SQL Azure to host client report definitions.B、 Use SQL Azure to host server report definitions.C、 Use Windows Azure to host client report definitions in an ASP.NET webpage.D、 Use Windows Azure to host server report definitions in an ASP.NET webpage.

考题 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 are using the Block Media Recovery feature to recover the blocks that are marked corrupt since the last backup. Which view will you query to display information about the data blocks that are marked corrupt since the last backup?()A、 V$BACKUP_CORRUPTIONB、 V$COPY_CORRUPTIONC、 V$DATABASE_BLOCK_CORRUPTIOND、 RC_BACKUP_CORRUPTION

考题 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

考题 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”.

考题 Your company has 1,000 client computers that run Windows 7.   The company uses several custom line-of-business applications that are not compatible with Windows 7.    You need to distribute a Microsoft Enterprise Desktop Virtualization (MED-V) v2 virtual machine (VM) image that includes the custom applications to all Windows 7 client computers.   What should you do?()A、Deploy the VM image from the MED-V server.B、Mount the VM image from the MED-V workspace.C、Deploy the VM image by using Windows Deployment Services (WDS).D、Deploy the VM image by using Windows Server Update Services (WSUS).

考题 You deploy applications by using the Microsoft Application Virtualization (App-V) Full Infrastructure Model You need to recommend a solution to manage the App-V Desktop Client settings. What should you include in the recommendation?()A、The App-V System Deployment SuperFlowB、the App-V Dynamic Suite Composition ToolC、the App-V SequencerD、the App-V Client ADM Template

考题 单选题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

考题 单选题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 deploy applications by using the Microsoft Application Virtualization (App-V) Full Infrastructure Model You need to recommend a solution to manage the App-V Desktop Client settings. What should you include in the recommendation?()A The App-V System Deployment SuperFlowB the App-V Dynamic Suite Composition ToolC the App-V SequencerD the App-V Client ADM Template

考题 多选题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.