Quiz
Untitled
Questions in this quiz (2)
1Which query creates a projection of the DEPARTMENT_NAME and LOCATION_ID
columns from the DEPARTMENTS table? (Choose the best answer.)- ASELECT DISTINCT DEPARTMENT_NAME, LOCATION_ID
FROM DEPARTMENTS; - BSELECT DEPARTMENT_NAME, LOCATION_ID
FROM DEPARTMENTS; - CSELECT DEPT_NAME, LOC_ID
FROM DEPT; - DSELECT DEPARTMENT_NAME AS “LOCATION_ID”
FROM DEPARTMENTS;
- ASELECT DISTINCT DEPARTMENT_NAME, LOCATION_ID
2After describing the EMPLOYEES table, you discover that the SALARY column has a data
type of NUMBER(8,2). Which SALARY value(s) will not be permitted in this column?
(Choose all that apply.)- ASALARY=12345678
- BSALARY=123456.78
- CSALARY=12345.678
- DSALARY=123456
- ESALARY=12.34
Information
- Description
- Quiz on Untitled, created by Nguyen T Nguyen on 30/04/2015.
- Author
- Nguyen T Nguyen
- Language
- English
- Views
- 0
- Rating
- No ratings yet Rate this quiz