单项选择题
A.The CONNECT statement B.The first FETCH of a cursor C.The BEGIN TRANSACTION statement D.The first executable SQL statement
Given that tables T1 and T2 contain the following rows:...
Given that tables T1 and T2 contain the following rows: Table T1: C1 C2 1 4 1 3 1 2 Table T2: C1 C2 1 1 1 2 1 3 Which of the following queries will return only those rows that exist in both T1 and T2?（）
A.SELECT * FROM t1 UNION SELECT * FROM t2 B.SELECT * FROM t1 UNION DISTINCT SELECT * FROM t2 C.SELECT * FROM t1 INTERSECT SELECT * FROM t2 D.SELECT * FROM t1 WHERE (c1,c2)= (SELECT c1,c2 FROM t2)
Which kind of non-sourced UDF can be created so that it...
单项选择题Which kind of non-sourced UDF can be created so that it only returns a single value?（）
A.Row B.Table C.Scalar D.Column
Given the following stored procedure:CREATE PROCEDURE i...
单项选择题Given the following stored procedure:CREATE PROCEDURE increase_salary ( IN p_workdept CHAR(6), OUT p_sum DECIMAL(9,2) ) SET p_sum = (SELECT SUM(salary) FROM employee WHERE workdept=p_workdept);How can this stored procedure be called from the Command Line Processor?（）
A.CALL increase_salary('A00') B.VALUES increase_salary('A00') C.CALL increase_salary('A00', ?) D.VALUES increase_salary('A00', ?)
