The EMP table contains these columns: You need to display the employees who have not been assigned to any department. You write the SELECT statement: What is true about this SQL statement?（）
1、The EMP table contains these columns:
The EMP table contains these columns:EMPLOYEE_ID NUMBER(4)EMPNAME VARCHAR2 (25)SALARY NUMBER(9,2)HIRE_DATE DATEYou query the database with this SQL ...
2、The EMP table contains these columns:
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 ...
3、The EMPLOYEE tables has these columns
The EMPLOYEE tables has these columns:LAST_NAME VARCHAR2(35)SALARY NUMBER(8,2)COMMISSION_PCT NUMBER(5,2)You want to display the name and annual salar...
4、The EMPLOYEE tables has these columns
The EMPLOYEE tables has these columns:You want to display the name and annual salary multiplied by the commission_pct for all employees. For re...
5、The CUSTOMERS table has these columns
The CUSTOMERS table has these columns:CUSTOMER_ID NUMBER(4) NOT NULLCUSTOMER_NAME VARCHAR2(100) NOT NULLSTREET_ADDRESS VARCHAR2(150)CITY_ADDRESS VARCHAR...
6、The ORDERS table has these columns:
The ORDERS table has these columns:The ORDERS table tracks the Order number, the order total, and the customer to whom the Order belongs. Whic...