Examine the structure of the EMPLOYEES, DEPARTMENTS, and LOCATIONS tables. EMPLOYEES NOT NULL, EMPLOYEE_ID NUMBER Primary Key VARCHAR2 EMP_NAME (30) VARCHAR2 JOB_ID (20) SALARY NUMBER References MGR_ID NUMBER EMPLOYEE_ID column DEPARTMENT_ID NUMBER Foreign key to DEPARTMENT_ID column of the DEPARTMENTS table DEPARTMENTS NOT NULL, Primary DEPARTMENT_ID NUMBER Key VARCHAR2 DEPARTMENT_NAME (30) References NGR_ID MGR_ID NUMBER column of the EMPLOYEES table Foreign key to LOCATION_ID NUMBER LOCATION_ID column of the LOCATIONS table LOCATIONS NOT NULL, Primary LOCATION_ID NUMBER Key VARCHAR2 CITY |30) Which two SQL statements produce the name, department name, and the city of all the employees who earn more then 10000?()
第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.