Referring to the exhibit, what contains the proper way to invoke the DEPTEMPLOYEES() user-defined

Click the Exhibit button. CREATE FUNCTION deptemployees (idept VARCHAR(3))RETURNS TABLE (empno CHAR(6),firstname VARCHAR(12),lastname VARCHAR(15))LANGUAGE SQLREADS SQL DATANO EXTERNAL ACTIONDETERMINISTICRETURNSELECT empno, firstnme, lastnameFROM employeeWHERE workdept = deptemployees.idept; Referring to the exhibit, what contains the proper way to invoke the DEPTEMPLOYEES() user-definedfunction to return all of the employees that work in department D11? A. SELECT * FROM […]

Read More

Which additional privilege is required?

The table shown below exists in the database: CREATE TABLE team.workitems ( priority INTEGER, last_update TIMESTAMP, detailsXML ) User USER1 has CREATEIN authority on the TEAM schema and can SELECT from theTEAM.WORKITEMS table. An SQL routine is created that performs a positioned update using a cursordeclared as shown below: DECLARE c_workitem CURSOR FOR SELECT priority, […]

Read More

Which SQL statement does user USER1 have privileges to execute?

A database contains a table and a view declared as shown below: CREATE TABLE s1.t1 ( c1 INTEGER, c2 CHAR(20) );CREATE VIEW s1.v1 AS SELECT * FROM s1.t1;A system administrator successfully executes the following code:GRANT CONNECT, IMPLICIT_SCHEMA ON DATABASE TO user1;GRANT INSERT ON TABLE s1.t1 TO user1;GRANT CONTROL ON s1.v1 TO user1; Which SQL statement […]

Read More

Which statement is true of an application that only uses static SQL?

Which statement is true of an application that only uses static SQL? A. The authorization ID of program creator is used to qualify explicitly qualified table references on a DROP statement. B. Static SQL uses SQLDA to determine the number of rows successfully fetched on a FETCH statement. C. The authorization ID of application creator […]

Read More

When the SELECT statement is executed, what will the result set contain?

Click the Exhibit button. VEMPLOYEE——————-EMPNO CHAR(6)LASTNAME VARCHAR(30)SALARY DEC(9,2)DEPTNO CHAR(3)VDEPARTMENT———————-DEPTNO CHAR(3)DEPTNAME VARCHAR(20)MGRNO CHAR(6)VPROJECT—————-PROJNO CHAR(6)PROJNAME VARCHAR(20)DEPTNO CHAR(6)RESPEMP CHAR(6) A JOIN operation references three views in the exhibit; the SELECT statement used does not contain aWHERE clause. When the SELECT statement is executed, what will the result set contain? A. one row from each table B. no rows […]

Read More