Right.
Wrong.
Doesn’t say.
第1题:
A、That's all right.
B、Thank you.
C、It doesn't matter.
第2题:
Which department do you work in on board?()
第3题:
Click the Exhibit button and examine the data in the EMPLOYEES and DEPARTMENTS tables.You want to retrieve all employees, whether or not they have matching departments in the departments table. Which query would you use?()
第4题:
Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) DEPARTMENT_ID NUMBER SALARY NUMBER What is the correct syntax for an inline view? ()
第5题:
ALTER VIEW emp_dept_vu (ADD manager_id NUMBER);
MODIFY VIEW emp_dept_vu (ADD manager_id NUMBER);
ALTER VIEW emp_dept_vu AS SELECT employee_id, employee_name, department_name, manager_id FROM employee e, departments d WHERE e.department_id = d.department_id;
MODIFY VIEW emp_dept_vu AS SELECT employee_id, employee_name, department_name, manager_id FROM employees e, departments d WHERE e.department_id = d.department_id;
CREATE OR REPLACE VIEW emp_dept_vu AS SELECT employee_id, employee_name, department_name, manager_id FROM employees e, departments d WHERE e.department_id = d.department_id;
You must remove the existing view first, and then run the CREATE VIEW command with a new column list to modify a view.
第6题:
SELECT employee_id, department_id, department_name, salary FROM employees WHERE department_id IN (SELECT department_id FROM departments);
SELECT employee_id, department_id, department_name, salary FROM employees NATURAL JOIN departments;
SELECT employee_id, d.department_id, department_name, salary FROM employees e JOIN departments d ON e.department _ id = d. department_id;
SELECT employee_id, department_id, department_name, Salary FROM employees JOIN departments USING (e.department_id, d.department_id);
第7题:
Right.
Wrong.
Doesn’t say.
第8题:
CFOs’ hard work leads to their increasing chances of promotion.
CFOs usually have no experience in management.
Marketing directors no longer have the chance to get a top position.
Chief executives used to be promoted mainly from the marketing department.
第9题:
ARPANET, it was created by the United States Department of Defense
ARPANET; it was created by the United States Department of Defense
ARPANET, which was created by the United States Department of Defense
ARPANET, being created by the United States Department of Defense
ARPANET; the United States Department of Defense created it
第10题:
SELECT last_name, department_name FROM employees NATURAL JOIN departments;
SELECT last_name, department_name FROM employees JOIN departments ;
SELECT last_name, department_name FROM employees e JOIN departments d ON (e.department_id = d.department_id);
SELECT last_name, department_name FROM employees e RIGHT OUTER JOIN departments d ON (e.department_id = d.department_id);
SELECT last_name, department_name FROM employees FULL JOIN departments ON (e.department_id = d.department_id);
SELECT last_name, department_name FROM employees e LEFT OUTER JOIN departments d ON (e.department_id = d.department_id);
第11题:
net rpc join -m localhost -ldap=ldap.ldapserver.comComputers/BusinessUnit/Department/Servers
rpcclient -c join Computers/BusinessUnit/Department/Servers
net ads join ou=Computers/BusinessUnit/Department/Servers
net ads join Computers/BusinessUnit/Department/Servers
第12题:
SELECT employee_id, department_id, department_name, salary FROM employees WHERE department_id IN (SELECT department_id FROM departments);
SELECT employee_id, department_id, department_name, salary FROM employees NATURAL JOIN departments;
SELECT employee_id, d.department_id, department_name, salary FROM employees e JOIN departments d ON e.department _ id = d. department_id;
SELECT employee_id, department_id, department_name, Salary FROM employees JOIN departments USING (e.department_id, d.department_id);
第13题:
A.netrpcjoin-mlocalhost-ldap="ldap.ldapserver.comComputers\BusinessUnit\Department\Servers"
B.rpcclient-c"joinComputers\BusinessUnit\Department\Servers"
C.netadsjoinou="Computers\BusinessUnit\Department\Servers"
D.netadsjoin"Computers\BusinessUnit\Department\Servers"
第14题:
船上的船员属于三个部门:甲板部、轮机部和事务部。()
第15题:
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? ()
第16题:
Deck department.
Engine department.
Service department.
Sorry.
第17题:
SELECT a.last_name, a.salary, a.department_id,
maxsal FROM employees a, (SELECT department_id, max(salary)maxsal FROM employees GROUP BY department_id) b WHERE a.department_id = b.department_id AND a.salary < b.maxsal;
SELECT a.last name, a.salary, a.department_id FROM employees a WHERE a.department_id IN (SELECT department_id FROM employees b GROUP BY department_id having salary = (SELECT max(salary) from employees))
SELECT a.last_name, a.salary, a.department_id FROM employees a WHERE a.salary = (SELECT max(salary) FROM employees b WHERE a.department _ id = b.department _ id);
SELECT a.last_name, a.salary, a.department_id FROM employees a WHERE (a.department_id, a.salary) IN (SELECT department_id, a.salary) IN (SELECT department_id max(salary) FROM employees b GROUP BY department_id ORDER BY department _ id);
第18题:
Seamen on board the ship are in two departments: Deck Department, Engine Department.
Seaman on board the ship are in two department: Deck Department, Engine Department and Service Department.
The Deck Department and the Engine Department are the two departments.
Seamen on board the ship are in three departments: the Deck Department, the Engine Department and the Service Department.
第19题:
sweep flames away with water spray
shut off the leak
use a chemical foam fire extinguisher
call t e local fire department
第20题:
Selection, projection, join
Difference, projection, join
Selection, intersection, join
Intersection, projection, join
Difference, projection, product
第21题:
没有给表employees和表departments加别名
没有给列department_id加别名
不能用employees.department_id=departments.department_id作为条件
SELECT后面的department_id没有指定是哪个表
第22题:
Right.
Wrong.
Doesn’t say.
第23题:
the chief engineer
the second engineer
the third engineer
the fourth engineer