For which action can you use the TO_DATE function?（）A、Convert any date literal to a dateB、Convert any numeric literal to a dateC、Convert any character literal to a dateD、Convert any date to a character literalE、Format '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 system administration command you can use to update Id.so.cache after the installation of new shared libraries？（）

• A、 Idconfig
• B、 Idd
• C、 libpath
• D、 newlibs

第3题：

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.

第4题：

For real time event processing, which three clients can you use?（）

• A、Java
• B、C++
• C、.NET
• D、REST

第5题：

You are developing a client that sends several types of SOAP messages to a Windows Communication Foundation (WCF) service method named PostData. PostData is currently defined as follows:[OperationContract]void PostData(Order data);You need to modify PostData so that it can receive any SOAP message. Which code segment should you use？（）

• A、[OperationContract(IsOneWay=true, Action="*", ReplyAction="*")] void PostData(Order data);
• B、[OperationContract(IsOneWay=true, Action="*", ReplyAction = "*")] void PostData(BodyWriter data);
• C、[OperationContract] void PostData(BodyWriter data);
• D、[OperationContract] void PostData(Message data);

第6题：

You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2002 instance. You upgrade this instance to SQL Server 2008. You configure the Agent service to use the LocalSystem account. There is a file named Orderdata on a remote network share. A job accesses this Orderdata file by using a CMDExec step. The job step fails to complete execution after the upgrade. You must make sure that the job can complete execution, so you have to configure the job step. What action should you perform? （） 

• A、You should configure a certificate 
• B、You should configure the SQL Server Agent service to use the NetworkService account.
• C、You should configure the job step to use a proxy account 
• D、You should configure the SQL Server Agent service to use a local Windows account

第7题：

第8题：

第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题：

Which of the following statements are true when creating NETBIOS names？ （）

• A、 NETBIOS names can only use alphanumeric characters.
• B、 You can use a ’.’ in a NETBIOS name.
• C、 You can use an ’_’ （underscore） in a NETBIOS name.
• D、 NETBIOS names must be UPPERCASE
• E、 NETBIOS names can be a maximum of 32 characters

第15题：

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

第16题：

You want to check all the data blocks being written to the datafiles by analyzing the data on each block every time the DBWn process writes.   Which action will you perform to check the data blocks？（）

• A、 Set the value of the DB_BLOCK_CHECKING initialization parameter to TRUE
• B、 Use the ANALYZE utility.
• C、 Use the DBVERIFY utility.
• D、 Use the DBMS_REPAIR package.

第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 work as the enterprise exchange administrator at Xxx .Xxx is using Microsoft Exchange Server 2010 as their messaging solution.Which of the following options can be you in order to change the permissions settings for a public folder？（）

• A、You must use the Active Directory Users and Computers.
• B、You must use the Microsoft Office Outlook.
• C、You must use the Mail Flow Troubleshooter.
• D、You must use the Exchange Server Jetstress 2010.

第19题：

第20题：

第21题：

第22题：

第23题：