1:
Q: 35 Which are iSQL*Plus commands? (Choose all that apply.)
A. INSERT
B. UPDATE
C. SELECT
D. DESCRIBE
E. DELETE
F. RENAME
Q: 35 Which are iSQL*Plus commands? (Choose all that apply.)
A. INSERT
B. UPDATE
C. SELECT
D. DESCRIBE
E. DELETE
F. RENAME
是问哪些命令可以在isqplus中执行?还是说那些命令是属于isqlplus独有的?
标准答案是d
那么就是ISQLPLUS特有的了
Q: 26 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?A. SELECT last_name, department_name
FROM employees NATURAL JOIN departments;B. SELECT last_name, department_name
FROM employees JOIN departments ;C. SELECT last_name, department_name
FROM employees e JOIN departments d
ON (e.department_id = d.department_id);D. SELECT last_name, department_name
FROM employees e
RIGHT OUTER JOIN departments d ON (e.department_id = d.department_id);E. SELECT last_name, department_name
FROM employees FULL JOIN departments
ON (e.department_id = d.department_id);F. SELECT last_name, department_name
FROM employees e LEFT OUTER
JOIN departments d ON (e.department_id = d.department_id);
即便员工的部门号在DEPARTMENTS表中不存在
那么就是左外连接呀
做ORACLE这个题就和英文阅读理解一样
没关系
不理解就来论坛大家商量商量呗