Examine the structure of the EMPLOYEES, DEPARTMENTS, and TAX tables. EMPLOYEES NOT NULL, Primary EMPLOYEE_ID NUMBER 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, DEPARTMENT_ID NUMBER Primary Key VARCHAR2 DEPARTMENT_NAME 30 References MGR_ID column MGR_ID NUMBER of the EMPLOYEES table TAX MIN_SALARY NUMBER MAX_SALARY NUMBER TAX_PERCENT NUMBER For which situation would you use a nonequijoin query?()
A. To find the tax percentage for each of the employees.
B. To list the name, job id, and manager name for all the employees.
C. To find the name, salary, and department name of employees who are not working with Smith.
D. To find the number of employees working for the Administrative department and earning less then 4000.
E. To display name, salary, manager ID, and department name of all the employees, even if the employees do not have a department ID assigned.
查看答案
食品污染共分三大类,即()
A. 生物性、化学性、放射性
B. 动物性、植物性、微生物性
C. 动物性、植物性、化学性
D. 生物、农药性、化学性
E. 动物性、生物性、物理性
如何科学理解技术进步的含义?我国技术进步的主要方向应是什么?
While creating a database using Database Configuration Assistant tool, you created a database default temporary tablespace. Which activity would cause the default temporary tablespace of the database to be used?()
A. the CREATE TABL. command
B. sorting of the SYSTEM tablespace’s data
C. sorting of data required by recursive SQL statements
D. the CREATE TABL. ORGANIZATION EXTERNA. command
E. sorting of data if the users have not been allocated temporary tablespace explicitly
F. sorting of data if the users have been allocated temporary tablespace explicitly
电缆在保管期间,应每六个月检查一次木盘的完整、封头的严密等()。
A. 正确
B. 错误