Evaluate this SQL statement: SELECT e.EMPLOYEE_ID,e.LAST_NAME,e.DEPARTMENT_ID, d.DEPARTMENT_NAME FROM EMP e, DEPARTMENT d WHERE e.DEPARTMENT_ID = d.DEPARTMENT_ID; In the statement, which capabilities of a SELECT statement are performed?（）
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?（）
In the statement, which capabilities of a SELECT statement are performed?（）
Which statement is true regarding the evaluation of rows returned by the subquery in the INSERT statement？（）
What is the result of the statement?（）
You use this statement to retrieve data from a data table for（）。
The EMP table contains these columns:
LAST NAME VARCHAR2(25)
SALARY NUMBER(6,2)
DEPARTMENT_ID NUMBER(6)
You need to display the employees who have not been assigned to any department. You write the SELECT statement:
SELECT LAST_NAME, SALARY, DEPARTMENT_ID FROM EMP
WHERE DEPARMENT_ID = NULL;
What is true about this SQL statement? （）
Evaluate these two SQL statements:
SELECT last_name, salary , hire_date
FROM EMPLOYEES
ORDER BY salary DESC;
SELECT last_name, salary, hire_date
FROM EMPLOYEES
ORDER BY 2 DESC;
What is true about them? （）
From SQL*Plus, you issue this SELECT statement:
SELECT*
FROM order;
You use this statement to retrieve data from a data table for （）.
Click the Exhibit button and examine the data from the ORDERS and CUSTOMERS tables.
Evaluate this SQL statement:
SELECT cust_id, ord_total
FROM orders
WHERE ord_total > ANY(SELECT ord_total
FROM orders
WHERE cust_id IN (SELECT cust_id
FROM customers WHERE city LIKE'New York'));
What is the result when the above query is executed?（）
免费的网站请分享给朋友吧