网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
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
参考答案
参考解析
解析：
暂无解析
更多 “单选题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” 相关考题
考题
A word is a___free form. of a language that has a given sound and meaning and syntactic function.
考题
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
考题
Given an EL function foo， in namespace func， that requires a long as a parameter and returns a Map，which two are valid invocations of function foo？（）A、${func（1）}B、${foo：func（4）}C、${func：foo（2）}D、${foo（5）：func}E、${func：foo（"easy"）}F、${func：foo（"3"）.name}
考题
Which of the following server types performs the same function as the HOSTS file？（）A、 FTPB、 DHCPC、 DNSD、 WINS
考题
If an external monitor is attached to a laptop and it does not work， which of the following actions should a technician take FIRST？（）A、Re-install the operating system.B、Open and close the cover.C、Use the function key to activate the monitor.D、Install new software for the keyboard.
考题
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
考题
Given an EL function declared with：11. 12.spin 13.com.example.Spinner 14. 15.java.lang.String spinIt（） 16. 17. Which two are true？（）A、The function method must have the signature： public String spin（）.B、The method must be mapped to the logical name "spin" in the web.xml file.C、The function method must have the signature： public String spinIt（）.D、The function method must have the signature public static String spin（）.E、The function method must have the signature： public static String spinIt（）.F、The function class must be named Spinner， and must be in the package com.example.
考题
Which value is valid for the iterate parameter in the CREATE_TIMER built-in function?（）A、CYCLE B、ITERATEC、NO_REPEAT D、REUSE
考题
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.
考题
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") %
考题
单选题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); } });
考题
单选题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.
考题
单选题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) %
考题
单选题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.
考题
多选题Given an EL function declared with：11. 12.spin 13.com.example.Spinner 14. 15.java.lang.String spinIt（） 16. 17. Which two are true？（）AThe function method must have the signature： public String spin（）.BThe method must be mapped to the logical name spin in the web.xml file.CThe function method must have the signature： public String spinIt（）.DThe function method must have the signature public static String spin（）.EThe function method must have the signature： public static String spinIt（）.FThe function class must be named Spinner， and must be in the package com.example.
考题
多选题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？（）ACreate a function that returns a list of values that represent the login times for the given user.BCreate a function that returns a list of values that represent the people who have logged more hours than the current user has logged.CCreate a function that returns a numeric value that represents the number of hours that a user has logged for the current day.DCreate a function that returns a numeric value that represents the number of hours that a user has logged for the current month.
考题
在Oracle 中，下列语句中哪些可以合法地创建一个函数？ (1.0分) [多选]
A. CREATE FUNCTION func_name(cdcode NUMBER) RETURN CHAR IS DECLARE dis_cd CHAR(15);
BEGIN .. END; B. CREATE FUNCTION func_name(cdcode NUMBER) RETURN CHAR IS dis_cd CHAR(15);
BEGIN .. END; C. CREATE FUNCTION func_name(cdcode NUMBER) IS
BEGIN .. END; D. CREATE FUNCTION func_name(cdcode NUMBER) RETURN CHAR IS
BEGIN .. END; E. CREATE FUNCTION func_name(cdcode NUMBER) RETURN CHAR IS DECLARE dis_cd STRING (15);
BEGIN .. END;
热门标签
最新试卷
