Examine the structure of the EMPLOYEES and DEPARTMENTS tables: EMPLOYEESColumn name Data type Remarks EMPLOYEE_ID NUMBER NOT NULL, Primary Key EMP_NAME VARCHAR2 (30) JOB_ID VARCHAR2 (20) SALARY NUMBER MGR_ID NUMBER References EMPLOYEE_ID COLUMN DEPARTMENT ID NUMBER Foreign key to DEPARTMENT ID column of the DEPARTMENTS table DEPARTMENTSColumn name Data type Remarks DEPARTMENT_ID NUMBER NOT NULL, Primary Key DEPARTMENT_NAME VARCHAR2(30) MGR_ID NUMBER References MGR_ID column of the EMPLOYEES table Evaluate this SQL statement: SELECT employee_id, e.department_id, department_name, salary FROM employees e, departments d WHERE e. department_id = d.department_id; Which SQL statement is equivalent to the above SQL statement? ()
第1题:
A、数字量扩展模块:EM 221、EM222、EM223
B、模拟量扩展模块:EM 231、EM232、EM235
C、通信模块:EM227
D、现场设备扩展模块:CP243;
第2题:
A.
B.
C.
D.
第3题:
M.Jackson suggested the data structure oriented software design method.Which of the following structure can be introduced by using input data structure?
A.algorithm structure
B.procedure structure
C.code structure
D.program structure
第4题:
A.
B.
C.
D.
第5题:
A.
B.
C.
D.
第6题:
Examine the structure of the EMPLOYEES table:You need to update the records of employees 103 and 115. The UPDATE statement you specify should update the rows with the values specified below:Which UPDATE statement meets the requirements?()
A.
B.
C.
D.
E.
第7题:
A. You have no rows in the table.
B. You have an employee with the name of James.
C. You cannot roll back to the same savepoint more than once.
D. Your last update fails to update any rows because employee ID 180 was already eleted.
第8题:
合法的电子邮件地址是( )。
A.Wang.em.hxing.com.cn
B.em.hxing.com.cn.wang
C.em.hxing.com.on@wang
D.wang@em.hxig.com.cn
第9题:
A.
B.
C.
D.
第10题:
A.
B.
C.
D.