The EMPLOYEE table contains the following information: EMPNO NAME WORKDEPT101 SAM A11 102

The EMPLOYEE table contains the following information: EMPNO NAME WORKDEPT101 SAM A11 102 JOHN C12 103 JANE -104 PAT Remote105 ANNE -106 BOB A11The MANAGER table contains the following information: MGRID NAME DEPTNO EMPCOUNT1 WU B01 - 2 JONES A11 - 3 CHEN - - 4 SMITH - -5 THOMAS C12 -After this statement is executed: UPDATE manager m SET empcount = (SELECT COUNT(workdept) FROM employee e WHERE workdept=m.deptno)What is the result of the following query？（）SELECT mgrid, empcount FROM MANAGER WHERE empcount IS NOT NULL ORDER BY mgrid

A. MGRID EMPCOUNT ----- -------- 1 0 2 2 5 1

B. MGRID EMPCOUNT ----- -------- 1 0 2 2 3 0 4 0 5 1

C. MGRID EMPCOUNT ----- -------- 1 3 2 3 3 3 4 3 5 3

D. MGRID EMPCOUNT ----- -------- 1 0 2 2 3 2 4 2 5 1

您可能感兴趣的试题

Which of the following words does NOT contain one morpheme？A．Table.B．Often.C．Desirable.D．L

答案解析
●To determine whether or not the employee correctly understands the message, the project m

答案解析
Given that tables T1 and T2 contain the following rows: Table T1:C1 C25 4 5 2 5 5Table T2: C1 C2 5 1 5 2 5 3Which of the following queries will return only those rows that exist in T1 and not in T2?()

答案解析
Given that tables T1 and T2 contain the following rows:Table T1: C1 C2 1 4 1 3 1 2Table T2: C1 C2 1 1 1 2 1 3Which of the following queries will return only those rows that exist in both T1 and T2?()

答案解析
Given the following requirements:Create a table to contain employee data with a unique nu

答案解析
Examine the data of the EMPLOYEES table.EMPLOYEES (EMPLOYEE_ID is the primary key. MGR_ID

答案解析
A table was created using the following DDL:CREATE TABLE employee (id SMALLINT NOT NULL n

答案解析