SELECT TABLE(EMPLIST()) FROM EMPLOYEE
SELECT TABLE(EMPLIST()) AS t FROM EMPLOYEE
SELECT EMPLIST(id, firstname, lastname) FROM EMPLOYEE
SELECT id, firstname, lastname FROM TABLE(EMPLIST()) AS t
第1题:
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,5
B.2,1,4,3,5
C.1,2,3,4,5
D.1,2,4,5
第2题:
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 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
第3题:
第4题:
Which of the following server types performs the same function as the HOSTS file?()
第5题:
第6题:
Which of the following statements describe the use of the keyword
static?
a) Within the body of a function: A static variable maintains its value
between function revocations
b) Within a module: A static variable is accessible by all functions
within that module
c) Within a module: A static function can only be called by other
functions within that module
第7题:
A.Package and function
B.Function and userexit
C.Procedure and package
D.Function and procedure
第8题:
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.
第9题:
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?()
第10题:
If an external monitor is attached to a laptop and it does not work, which of the following actions should a technician take FIRST?()