单项选择题
Examine the structure of the EMPLOYEES and DEPARTMENTS tables:
EMPLOYEES
EMPLOYEE_ID NUMBER
DEPARTMENT_ID NUMBER
MANAGER_ID NUMBER
LAST_NAME VARCHAR2(25)
DEPARTMENTS
DEPARTMENT_ID NUMBER
MANAGER_ID NUMBER
DEPARTMENT_NAME VARCHAR2(35)
LOCATION_ID NUMBER
You want to create a report displaying employee last names, department names, and locations. Which query should you use?（）
A.SELECT e.last_name, d. department_name, d.location_id FROM employees e NATURAL JOIN departments D USING department_id ;
B.SELECT last_name, department_name, location_id FROM employees NATURAL JOIN departments WHERE e.department_id =d.department_id;
C.SELECT e.last_name, d.department_name, d.location_id FROM employees e NATURAL JOIN departments d;
D.SELECT e.last_name, d.department_name, d.location_id FROM employees e JOIN departments d USING (department_id );
相关考题
-
单项选择题
What is true about sequences?（）
A.Once created, a sequence belongs to a specific schema.
B.Once created, a sequence is linked to a specific table.
C.Once created, a sequence is automatically available to all users.
D.Only the DBA can control which sequence is used by a certain table.
E.Once created, a sequence is automatically used in all INSERT and UPDATE statements. -
多项选择题
Which two are true about aggregate functions? （）
A.You can use aggregate functions in any clause of a SELECT statement.
B.You can use aggregate functions only in the column list of the SELECT clause and in the WHERE clause of a SELECT statement.
C.You can mix single row columns with aggregate functions in the column list of a SELECT statement by grouping on the single row columns.
D.You can pass column names, expressions, constants, or functions as parameters to an aggregate function.
E.You can use aggregate functions on a table, only by grouping the whole table as one single group.
F.You cannot group the rows of a table by more than one column while using aggregate functions. -
单项选择题
Evaluate the SQL statement: SELECT LPAD(salary,10,*) FROM EMP WHERE EMP_ID = 1001; If the employee with the EMP_ID 1001 has a salary of 17000, what is displayed?（）
A. 17000.00
B. 17000*****
C. ****170.00
D. **17000.00
E.an error statement
