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
第1题:
A.V$SESSION_EVENT
B.V$SESSION
C.V$WAITS
D.V$WAITSTAT
E.V$SYSSTAT
第2题:
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.0
B.1
C.2
D.3
第3题:
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.
第4题:
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?()
第5题:
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?()
第6题:
A.When view V1 is created
B.Each time the REFRESH VIEW v1 statement is executed
C.Each time an SQL statement is executed against view V1
D.Only the first time an SQL statement is executed against view V1
第7题:
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?()
第8题:
A.V$SESSION_EVENT
B.V$SESSION
C.V$WAITS
D.V$WAITSTAT
E.V$SESSION_LONGOPS
第9题:
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? ()
第10题:
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?()