单选题Evaluate the following function code：   CREATE FUNCTION get_dept_avg（dept_id NUMBER） RETURN NUMBER RESULT_CACHE RELIES_ON （EMPLOYEES） IS avgsal NUMBER（6）； BEGIN  SELECT AVG（SALARY）INTO avgsal FROM EMPLOYEES   WHERE DEPARTMENT_ID = dept_id； RETURN avgsa

第1题：

第2题：

all of the following are function of crm system except （）

• A、automation procurement
• B、automation sales
• C、automation marketing
• D、automation customer service

第3题：

Given the following function: CREATE FUNCTION emplist （　） RETURNS TABLE ( id CHAR(6) , firstname VARCHAR(12) , lastname VARCHAR(15) ) LANGUAGE SQL BEGIN ATOMIC RETURN SELECT EMPNO, FIRSTNME, LASTNAME FROM EMPLOYEE WHERE WORKDEPT IN ('A00', 'B00'); END How can this function be used in an SQL statement?

• A、SELECT TABLE(EMPLIST()) FROM EMPLOYEE
• B、SELECT TABLE(EMPLIST()) AS t FROM EMPLOYEE
• C、SELECT EMPLIST(id, firstname, lastname) FROM EMPLOYEE
• D、SELECT id, firstname, lastname FROM TABLE(EMPLIST()) AS t

第4题：

Which value is valid for the iterate parameter in the CREATE_TIMER built-in function?（）

• A、CYCLE 
• B、ITERATE
• C、NO_REPEAT 
• D、REUSE

第5题：

You are implementing an ASP. NET MVC 2 Web application. You add a controller named Company Controller. You need to modify the application to handle the URL path /company/info. Which two actions should you perform？（）

• A、Add the following method to the CompanyController class. Function Info（） As ActionResult   Return View（） End Function
• B、Add the following method to the CompanyController class. Function Company_Info（） As ActionResult  Return View（） End Function
• C、Right-click the Views folder， and select View from the Add submenu to create the view for the action.
• D、Right-click inside the action method in the CompanyController class， and select Add View to create a view for the action

第6题：

You use Microsoft .NET Framework 4 to create a Windows Presentation Foundation (WPF) application. You want to add an audio player that plays .wav or .mp3 files when the user clicks a button. You plan to store the name of the file to a variable named SoundFilePath. You need to ensure that when a user clicks the button, the file provided by SoundFilePath plays. What should you do?（）

• A、 Write the following code segment in the button onclick event.     System.Media.    SoundPlayer player = new System.Media.    SoundPlayer(SoundFilePath); player.play();
• B、 Write the following code segment in the button onclick event.    MediaPlayer player = new MediaPlayer();     player.Open(new URI(SoundFilePath),    UriKind.Relative)); player.play();
• C、 Use the following code segment from the PlaySound()    Win32 API function and call the PlaySound function in the button onclick event.    [sysimport(dll="winmm.dll")]     public static extern long PlaySound(String SoundFilePath, long hModule, long dwFlags);
• D、 Reference the Microsoft.DirectX Dynamic Link Libraries.     Use the following code segment in the button onclick event.     Audio song = new Song(SoundFilePath);     song.CurrentPosition = song.Duration; song.Play();

第7题：

You are implementing an ASP.NET MVC 2 Web application that contains the following class.  Public Class DepartmentControllerInherits Controller   Shared departments As List（Of Department） =  New List（Of Department）   Function Index（） As ActionResultReturn View（departments）End Function   Function Details（ByVal id As Integer） As ActionResultReturn View（departments.Find（Function（x） x.ID = id））End Function   Function ListEmployees（ByVal d As Department） As ActionResultDim employees As List（Of Employee） = GetEmployees（d）Return View （employees）End FunctionEnd Class  You create a strongly typed view that displays details for a Department instance. You want the view to also include a listing of department employees.  You need to write a code segment that will call the ListEmployees action method and output the results in place. Which code segment should you use？（）

• A、<%= Html.Action("ListEmployees", Model) %> 
• B、<%= Html.ActionLink("ListEmployees", "Department", "DepartmentController") %> 
• C、<% Html.RenderPartial("ListEmployees", Model) %>
• D、<%= Html.DisplayForModel("ListEmployees") %>

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

第14题：

Which of the following server types performs the same function as the HOSTS file？（）

• A、 FTP
• B、 DHCP
• C、 DNS
• D、 WINS

第15题：

Which of the following are types of routine objects?（）

• A、Package and function
• B、Function and userexit
• C、Procedure and package
• D、Function and procedure

第16题：

You need to call an unmanaged function from your managed code by using platform invoke services. What should you do？（）

• A、Create a class to hold DLL functions and then create prototype methods by using managed code.
• B、Register your assembly by using COM and then reference your managed code from COM
• C、Export a type library for your managed code.
• D、Import a type library as an assembly and then create instances of COM object.

第17题：

You create a Microsoft ASP.NET application by using the Microsoft .NET Framework version 3.5.  You create a Web page to display photos and captions. The caption of each photo in the database can be modified by using the application.  You write the following code fragment.      ’ runat="server"/>  | English | Chinese | Japan | Korean | - 124 - Test Information Co.， Ltd. All rights reserved.         ’ runat="server" />        When you access the Web page， the application throws an error.  You need to ensure that the application successfully updates each caption and stores it in the database.  What should you do？（）

• A、Add the ID attribute to the Label control.
• B、Add the ID attribute to the TextBox control.
• C、Use the Bind function for the Label control instead of the Eval function.
• D、Use the Eval function for the TextBox control instead of the Bind function.

第18题：

TestKing.com has a SQL Server 2005 computer. You have been assigned the task of retrieving information about a user who is currently logged in. You need to create a function that returns scalar information about the activity time for a particular user. What are two possible ways to achieve this goal？（）

• A、Create a function that returns a list of values that represent the login times for the given user.
• B、Create a function that returns a list of values that represent the people who have logged more hours than the current user has logged.
• C、Create a function that returns a numeric value that represents the number of hours that a user has logged for the current day.
• D、Create a function that returns a numeric value that represents the number of hours that a user has logged for the current month.

第19题：

第20题：

第21题：

第22题：

第23题：