出自:Oracle认证
Exhibit 
Examine the data in the EMPLOYEES and DEPARTMENTS tables. You want to retrieve all employees' last names, along with their manager's last names and their department names. Which query would you use?（）
A:SELECT last_name, manager_id, department_name FROM employees e FULL OUTER JOIN department d ON (e.department_id = d.department_id);
B:SELECT e.last_name, m.last_name, department_name FROM employees e LEFT OUTER JOIN employees m on ( e.managaer_id = m.employee_id) LEFT OUTER JOIN department d ON (e.department_id = d.department_id);
C:SELECT e.last_name, m.last_name, department_name FROM employees e RIGT OUTER JOIN employees m on ( e.manager_id = m.employee_id) FULL OUTER JOIN department d ON (e.department_id = d.department_id);
D:SELECT e.last_name, m.last_name, department_name FROM employees e LEFT OUTER JOIN employees m on ( e.manager_id = m.employee_id) RIGT OUTER JOIN department d ON (e.department_id = d.department_id);
E:SELECT e.last_name, m.last_name, department_name FROM employees e RIGHT OUTER JOIN employees m on ( e.manager_id = m.employee_id) RIGHT OUTER JOIN departments d ON (e.department_id = d.department_id)
F:SELECT last_name, manager_id, department_name FROM employees e JOIN department d ON (e.department_id = d.department_id);
Upon starting your database, you receive the following error: 
You can choose from the following steps: 1.Restore the database datafiles. 2.Issue the alter database clear unarchived logfile group 1 command. 3.Issue the alter database open command. 4.Issue the alter database open resetlogs command. 5.Recover the database using point-in-time recovery. 6.Issue the Startup Mount command to mount the database. 7.Back up the database. Which is the correct order of these steps in this case?（）
A:1,6,5,4,7
B:6,5,4
C:6,2,3,7
D:1,6,3
E:The database cannot be recovered
You want to suppress ADDM output relating to Segment Advisor actions on user SCOTT's segments.What would you do to achieve this?（）
The table contains a million rows for zonewise analysis in the DSS system. DML operations areperformed very rarely on the table. You decide to prepare an index on the ZONE column to enhance theperformance of the queries on the ZONE column. Which type of index would you select in this scenario（）
What is the result?（）