An SQL function named DEPT_INFO was created as follows:  CREATE FUNCTION dept_info()  RETURNS TABLE(dept_id INTEGER,dept_name VARCHAR(20))  LANGUAGE SQL  READS SQL DATA  BEGIN ATOMIC  RETURN    SELECT deptno,deptname FROM department WHERE deptname LIKE 'S%';  END What is the correct way to use this function in a query、

试卷相关题目

• 1If a table named MY_TAB contains 100 rows and the following statement is executed:  UPDATE  (SELECT * FROM my_tab   ORDER BY col1 DESC   FETCH FIRST 10 ROWS ONLY) AS temp   SET col3 = 99; How many rows will be updated、

  A.0

  B.1

  C.10

  D.99

  开始考试点击查看答案
• 2Which SQL statement should be used to retrieve the minimum and maximum salaries (SALARY) for each job code (JOB), sorted by job code, from a table named EMPLOYEE、

  A.SELECT job, MIN(salary), MAX(salary) FROM employee GROUP BY job ORDER BY job;

  B.SELECT job, MIN(salary), MAX(salary) FROM employee ORDER BY job;

  C.SELECT job, MIN(salary), MAX(salary) FROM employee GROUP BY SALARY ORDER BY job;

  D.SELECT job, MIN(salary), MAX(salary) FROM employee GROUP BY MIN(salary), MAX(salary)ORDER BY job;

  开始考试点击查看答案
• 3Which SQL statement would be used to retrieve only salaries that are greater than $100,000.00 from a table named EMPLOYEE、

  A.SELECT * FROM employee WHERE salary < 100000

  B.SELECT salary FROM employee WHERE salary > 100000

  C.SELECT salary FROM employee WHERE salary > 100,000.00

  D.SELECT * FROM employee WHERE salary GREATER THAN 100000

  开始考试点击查看答案
• 4When a COMMIT statement is executed, what happens、

  A.All locks held on the database are automatically released.

  B.Data stored in global temporary tables is automatically deleted.

  C.Open cursors defined WITH HOLD are closed, but their data is retaine

  D.D. The current transaction is terminated and a new transaction boundary is started.

  开始考试点击查看答案
• 5Which statement about roll back operations is correct、

  A.When a ROLLBACK statement is executed, all locks held by the terminating transaction are released.

  B.When a ROLLBACK TO SAVEPOINT statement is executed, all locks acquired up to the savepoint are released.

  C.When a ROLLBACK TO SAVEPOINT statement is executed, all locks acquired after the savepoint are release

  D.D. When a ROLLBACK statement is executed, all locks acquired for open cursors that were declared WITH HOLD, are held.

  开始考试点击查看答案
• 6Which type of stored procedure is not associated with an external application program、

  A.A Java stored procedure.

  B.A REXX stored procedure.

  C.A native SQL stored procedure.

  D.An external SQL stored procedur

  开始考试点击查看答案
• 7Which SQL statement will retrieve the department number (WORKDEPT) and average departmentalsalary (SALARY) for all departments in a table named EMPLOYEE and arrange the result set inascending order by average departmental salary、

  A.SELECT workdept, AVG(salary) FROM employee ORDER BY workdept GROUP BY 2

  B.SELECT workdept, AVG(salary) FROM employee ORDER BY workdept ARRANGE BY 2

  C.SELECT workdept, AVERAGE(salary) FROM employee GROUP BY workdept ORDER BY 2

  D.SELECT workdept, AVG(salary) FROM employee GROUP BY workdept ORDER BY 2

  开始考试点击查看答案
• 8Which statement about system-period temporal tables is true、

  A.They store user-based period information.

  B.They do not have a separate history table.

  C.They can be queried without a time period specification.

  D.They manage data based on time criteria specified by users or applications.

  开始考试点击查看答案
• 9A table named DEPARTMENT contains the following data:  DEPTNO     DEPTNAME          MGRNO      ADMRDEPT -----      --------          -----      -------- A01        PLANNING          000020     A00 B02        BRANCH OFFICE 1   -          E01 C22        BRANCH OFFICE 2   -          E01 D22        BRANCH OFFICE 3   -          E01 E22        BRANCH OFFICE 4   -          E01 If a user attempts to execute the following statement UPDATE employee SET workdept=   (SELECT deptno FROM department WHERE admrdept LIKE 'E%') WHERE workdept IS NULL; What will happen、

  A.The statement will fail because a subquery cannot be used in an UPDATE statement.

  B.The statement will fail because the result set produced by the subquery will contain more than one row.

  C.The statement will succeed; the last record retrieved by the subquery will be used to provide a WORKDEPT value for the update operation.

  D.The statement will succeed; the first record retrieved by the subquery will be used to provide a WORKDEPT value for the update operation.

  开始考试点击查看答案
• 10Which statement about UPDATE processing is FALSE、

  A.The UPDATE statement logs the before and after value of every column it modifies.

  B.A searched UPDATE is used to update one or more rows and a positioned UPDATE is used to update exactly one row.

  C.When the UPDATE statement modifies parent key columns, the value of corresponding foreign key columns are also modifie

  D.D. The UPDATE statement modifies the values of specified columns in the rows of a table, view, or underlying table(s) of a specified fullselect.

  开始考试点击查看答案