网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
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 avgsal； END get_dept_avg； Which statement is true regarding the above function？（）
A
The cached result becomes invalid when any structural change is done to the EMPLOYEES table.
B
If the function execution results in an unhandled exception，the exception result is also stored in the cache.
C
Each time the function is invoked in a different session，the current result in the result cache gets overwritten.
D
If the function is invoked with a different parameter value，the existing result in the result cache gets overwritten by the latest value.
参考答案
参考解析
解析：
暂无解析
更多 “单选题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 avgsal； END get_dept_avg； Which statement is true regarding the above function？（）A The cached result becomes invalid when any structural change is done to the EMPLOYEES table. B If the function execution results in an unhandled exception，the exception result is also stored in the cache.C Each time the function is invoked in a different session，the current result in the result cache gets overwritten.D If the function is invoked with a different parameter value，the existing result in the result cache gets overwritten by the latest value.” 相关考题
考题
Evaluate the following function code:Which statement is true regarding the above function? ()
A. The cached result becomes invalid when any structural change is done to the EMPLOYEES table.B. If the function execution results in an unhandled exception, the exception result is also stored in the cache.C. Each time the function is invoked in a different session, the current result in the result cache gets overwritten.D. If the function is invoked with a different parameter value, the existing result in the result cache gets overwritten by the latest value.
考题
The following parameter are set for your Oracle 12c database instance:OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES=FALSEOPTIMIZER_USE_SQL_PLAN_BASELINES=TRUEYou want to manage the SQL plan evolution task manually. Examine the following steps:1. Set the evolve task parameters.2. Create the evolve task by using the DBMS_SPM.CREATE_EVOLVE_TASK function.3. Implement the recommendations in the task by using the DBMS_SPM.IMPLEMENT_EVOLVE_TASKfunction.4. Execute the evolve task by using the DBMS_SPM.EXECUTE_EVOLVE_TASK function.5. Report the task outcome by using the DBMS_SPM.REPORT_EVOLVE_TASK function.Identify the correct sequence of steps:（）A.2，4，5B.2，1，4，3，5C.1，2，3，4，5D.1，2，4，5
考题
Which of the following statements describe the use of the keywordstatic?a) Within the body of a function: A static variable maintains its valuebetween function revocationsb) Within a module: A static variable is accessible by all functionswithin that modulec) Within a module: A static function can only be called by otherfunctions within that module
考题
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‘); ENDHow can this function be used in an SQL statement?A.SELECT TABLE(EMPLIST()) FROM EMPLOYEEB.SELECT TABLE(EMPLIST()) AS t FROM EMPLOYEEC.SELECT EMPLIST(id, firstname, lastname) FROM EMPLOYEED.SELECT id, firstname, lastname FROM TABLE(EMPLIST()) AS t
考题
Which of the following are types of routine objects?()
A.Package and functionB.Function and userexitC.Procedure and packageD.Function and procedure
考题
Among the following， ( ) is NOT one of the functions of adult′s language according to Halliday. A.the Ideational Function
B.the Syntactic Function
C.the Interpersonal Function
D.the Textual Function
考题
all of the following are function of crm system except （）A、automation procurementB、automation salesC、automation marketingD、automation customer service
考题
Which of the following server types performs the same function as the HOSTS file？（）A、 FTPB、 DHCPC、 DNSD、 WINS
考题
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 EMPLOYEEB、SELECT TABLE(EMPLIST()) AS t FROM EMPLOYEEC、SELECT EMPLIST(id, firstname, lastname) FROM EMPLOYEED、SELECT id, firstname, lastname FROM TABLE(EMPLIST()) AS t
考题
Which of the following are types of routine objects?（）A、Package and functionB、Function and userexitC、Procedure and packageD、Function and procedure
考题
Which value is valid for the iterate parameter in the CREATE_TIMER built-in function?（）A、CYCLE B、ITERATEC、NO_REPEAT D、REUSE
考题
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 COMC、Export a type library for your managed code.D、Import a type library as an assembly and then create instances of COM object.
考题
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 FunctionB、Add the following method to the CompanyController class. Function Company_Info（） As ActionResult Return View（） End FunctionC、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
考题
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.
考题
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();
考题
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.
考题
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") %
考题
单选题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 COMC
Export a type library for your managed code.D
Import a type library as an assembly and then create instances of COM object.
考题
单选题The following parameter are set for your Oracle 12c database instance: OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES=FALSE OPTIMIZER_USE_SQL_PLAN_BASELINES=TRUE You want to manage the SQL plan evolution task manually. Examine the following steps: 1. Set the evolve task parameters. 2. Create the evolve task by using the DBMS_SPM.CREATE_EVOLVE_TASK function. 3. Implement the recommendations in the task by using the DBMS_SPM.IMPLEMENT_EVOLVE_TASK function. 4. Execute the evolve task by using the DBMS_SPM.EXECUTE_EVOLVE_TASK function. 5. Report the task outcome by using the DBMS_SPM.REPORT_EVOLVE_TASK function. Identify the correct sequence of steps:（）A
2，4，5B
2，1，4，3，5C
1，2，3，4，5D
1，2，4，5
考题
单选题Bob, a support technician, is trying to locate a particular registry key using REGEDIT.EXE, on aWindows 2000 PC. Which of the following is the BEST method of doing this?（）A
Use the import function from the File menu.B
Use the find function in the Edit menu.C
Use the display binary data function in the View menu.D
Navigate through the registry sub-trees.
考题
单选题You create a Web page that contains the span shown in the following line of code. TextYou need replace the contents of the span with HTML that you download from a URL specified by a global variable named localURL. Which code segment should you use？（）A
$.ajax({ type: GET, url: localURL, dataType: jsonp, success: function(htmlText { $(#span1).text(htmlText); } }); B
$.ajax( localURL, {}, function(htmlText) { $(#span1).html(htmlText); },html ); C
$.ajax({ type: GET, url: localURL, dataType: html,success: function(htmlText) { $(#span1).innerHTML = htmlText; }}); D
$.ajax({ type: GET, url: localURL, success: function(htmlText) { $(#span1).html(htmlText); } });
考题
单选题The CALC function is used several times within the sales report. To simplify maintenance you want to store the function in one place and call it from within your PL/SQL trigger code. Which node would you use in object navigator to create a report level programme unit to store the function?（）A
Programme units. B
PL/SQL libraries. C
Database object. D
Built in packages.
考题
单选题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"/ ’ 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.
考题
单选题You create a new ASP.NET MVC 2 Web application. The following default routes are created in the Global.asax.vb file.01 Shared Sub RegisterRoutes（ByVal routes As RouteCollection）02 03 routes.IgnoreRoute（"{resource}.axd/{*pathInfo}"）04 05 routes.MapRoute（ "Default"， "{controller}/{action}/{id}"， New With {.controller = "Home"， .action = "Index"， .id = ""}） 06 End Sub You implement a controller named HomeController that includes methods with the following signatures.Function Index（） As ActionResult Function Details（ByVal id As Integer） As ActionResultFunction DetailsByUsername（ ByVal username As String） As ActionResult You need to add a route to meet the following requirements. The details for a user must be displayed when a user name is entered as the path by invoking the DetailsByUsername action. User names can contain alphanumeric characters and underscores， and can be between 3 and 20 characters long.What should you do？（）A
Replace line 05 with the following code segment. routes.MapRoute（ "Default"， "{controller}/{action}/{id}"， New With {.controller = "Home"， .action = "DetailsByUsername"， .id = ""}）B
Replace line 05 with the following code segment. routes.MapRoute（"Default"， "{controller}/{action}/{username}"， New With {.controller = "Home"， .action = "DetailsByUsername"， .username = ""}， New With {.username = "/w{3，20}"} ）C
At line 04， add the following code segment.routes.MapRoute（ "Details byUsername""{username}"， New With {.controller = "Home"， .action = "DetailsByUsername"}， New With {.username = "/w{3，20}"}）D
At line 04， add the following code segment. routes.MapRoute（ "Details by Username"， "{id}"， New With {.controller = "Home"， .action = "DetailsByUsername"}， New With {.id = "/w{3，20}"} ）
考题
单选题Which value is valid for the iterate parameter in the CREATE_TIMER built-in function?（）A
CYCLE B
ITERATEC
NO_REPEAT D
REUSE
考题
单选题Which of the following BEST describes the function of hyperthreading support within a CPU?（）A
Allows the core to create a separate space to process threadsB
Allows the processor to handle multiple threads per coreC
Allows the core to shift to a higher clock speed based on thread countD
Allows the processor to reject certain threads to increase performance
考题
单选题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) %
热门标签
最新试卷
