多选题For which two actions can you use the TO_DATE function? （）Aconvert any date literal to a dateBconvert any numeric literal to a dateCconvert any date to a character literalDformat 'January 10 1999' for inputEformat '10-JAN-99' to 'January 10 1999'

第1题：

Which two are true about aggregate functions?（）

• A、You can use aggregate functions in any clause of a SELECT statement.
• B、You can use aggregate functions only in the column list of the select clause and in the WHERE clause of a SELECT statement.
• C、You can mix single row columns with aggregate functions in the column list of a SELECT statement by grouping on the single row columns.
• D、You can pass column names, expressions, constants, or functions as parameter to an aggregate function.
• E、You can use aggregate functions on a table, only by grouping the whole table as one single group.
• F、You cannot group the rows of a table by more than one column while using aggregate functions.

第2题：

Which two statements are correct regarding the Flashback Versions Query feature？（）

• A、 You can use this feature to identify the committed versions of the rows， but not the uncommitted versions.
• B、 You can use this feature to identify the versions of V$ views.
• C、 You can use this feature to identify the inserts， deletes， and updates performed on a particular row but not the data definition language （DDL） operations performed on the table.
• D、 You can use this feature for a table only if row movement is enabled for the table.
• E、 You can use this feature to identify the versions of external and fixed tables.

第3题：

You need to calculate the total of all salaries in the accounting department. Which group function should you use?（）

• A、MAX
• B、MIN
• C、SUM
• D、COUNT
• E、TOTAL
• F、LARGEST

第4题：

You need to design a security strategy for the DHCP servers in the Seattle office. Which two actions should you perform？（）

• A、Disable all unnecessary services on each DHCP server
• B、Modify the discretionary access control lists （DACLs） in Active Directory so that only members of the Enterprise Admins security group can authorize additional DHCP servers
• C、Use an IPSec policy that allows only the packets necessary for DHCP and domain membership for each DHCP server
• D、Install a digital certificate for SSL on each DHCP server

第5题：

You are developing a Windows Communication Foundation (WCF) service. You write a method named Submit that accepts messages of the type System.ServiceModel.Channels.Message. You need to process the body of the incoming messages multiple times in the method. Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)（）

• A、Use the GetBody method of the Message class to read the content of the messages.
• B、Use the CreateBufferedCopy method of the Message class to load the messages into memory.
• C、Use the WriteBodyContents method of the BodyWriter class to make a copy of the messages.
• D、Use the CreateMessage method of the MessageBuffer class to make a copy of the messages.

第6题：

You use Microsoft Application Virtualization for Desktops to virtualize applications for client computers.A virtual application that was installed by using a Windows Installer Package (.msi) file has become corrupted. You need to restore access to the virtual application. Which two actions should you perform？（）

• A、Reload the virtual application package.
• B、Reinstall the virtual application package.
• C、Use the Repair function in the Windows Installer Package. Use the Microsoft Application Virtualization (App-V) to re-sequence the application.
• D、Use the Microsoft Application Virtualization (App-V) Sequencer to edit the virtual application package.

第7题：

You discover that a particular group of settings named UserPreferences changes.You need to store the UserPreference settings to prevent affecting other applications. Which two actions should you perform？（）

• A、Use the Properties.USerPreferences object
• B、Use the Properties.Settings.Default.Userprefences object
• C、Use the ConfigurationManager.AppSettings object during runtime
• D、Create the settings by using Application scope
• E、Create the settings by using User scope

第8题：

You need to design the network to support the company’s VPN requirements for mobile users who connect to the network in Seattle. Which two actions should you perform？（）

• A、Use a password generator application to create a preshared key， and distribute it to all mobile users
• B、Use computer autoenrollment to create digital certificates that can be used to authenticate to a VPN server
• C、Acquire a digital certificate that can be used for SSL from a commercial CA for each computer that established a VPN connection
• D、Configure IPSec policies on all Routing and Remote Access servers to require the use of digital certificates

第9题：

第10题：

第11题：

第12题：

第13题：

You are preparing for a new installation of SQL Server 2005. You need to select the protocols that client computers might use to connect to the server.  Which two protocols can you use to achieve this goal？（）

• A、Named Pipes
• B、TCP/IP
• C、Shared Memory
• D、Virtual Interface Adapter （VIA）
• E、Multiprotocol

第14题：

For which of the following can you use Segment Shrink？（）

• A、 Heap tables
• B、 Tables with function-based indexes
• C、 Indexes
• D、 Partitions and subpartitions
• E、 None of the above

第15题：

You have an image that is used to deploy Windows 7 on client computers.   You need to add drivers to the Windows 7 image.   Which two actions should you perform？（）

• A、Use the Deployment Image Servicing and Management （DISM） tool online.
• B、Use the Deployment Image Servicing and Management （DISM） tool offline.
• C、Use INF files for driver packages.
• D、Use executable files for driver packages.
• E、Use Windows Installer files for driver packages.

第16题：

You are developing an application that receives events asynchronously.You create a WqlEventQuery instance to specify the events and event conditions to which the application must respond.You also create a ManagementEventWatcher instance to subscribe to events matching the query.You need to identify the other actions you must perform before the application can receive events asynchronously.Which two actions should you perform？（）

• A、Start listening for events by calling the Start method of the ManagementEventWatcher.
• B、Set up a listener for events by using the EventArrived event of the ManagementEventWatcher.
• C、Use the WaitForNextEvent method of the ManagementEventWatcher to wait for the events.
• D、Create an event handler class that has a method that receives an ObjectReadyEventArgs parameter.
• E、Set up a listener for events by using the Stopped event of the ManagementEventWatcher.

第17题：

You use Microsoft .NET Framework 4 to create a Windows Presentation Foundation (WPF) application. You need to ensure that users can view content in a book-reading format that displays two pages at a time. Which control should you use?（）

• A、 FlowDocument 
• B、 FlowDocumentReader
• C、 FlowDocumentPageViewer
• D、 FlowDocumentScrollViewer

第18题：

You are preparing for a new installation of SQL Server 2005. You need to select the protocols that client computers might use to connect to the server. Which two protocols can you use to achieve this goal?（）

• A、 Named Pipes 
• B、 TCP/IP 
• C、 Shared Memory 
• D、 Virtual Interface Adapter (VIA) 
• E、 Multiprotocol 

第19题：

You are planning to move streaming media content to Windows Azure Storage.   You need to recommend an approach for providing worldwide users the fastest possible access to the content. Which two actions should you recommend？（）

• A、 Use a Shared Access Signature.
• B、 Use Windows Azure page blob storage.
• C、 Use Windows Azure block blob storage.
• D、 Use the Windows Azure Content Delivery Network （CDN）.

第20题：

第21题：

第22题：

第23题：

第24题：