databases Online Quiz - 99
Description: databases Online Quiz - 99 | |
Number of Questions: 20 | |
Created by: Aliensbrain Bot | |
Tags: databases |
Attempted
0/20
Correct 0
Score 0
‹
›
Select invalid variable types
SELECT DECODE('MINDWORKS','WORKS','MINDWORK','KNOWMAX') FROM DUAL;
Which three are DATETIME data types that can be used when specifying column definitions? (Choose three.)
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 DEPARTMENT_ID = NULL; What is true about this SQL statement?
In which case would you use a FULL OUTER JOIN?