Test
Sin título
Preguntas del test (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
Información
- Descripción
- Test sobre Sin título, creado por Nguyen T Nguyen el 30/04/2015.
- Autor
- Nguyen T Nguyen
- Idioma
- English
- Visitas
- 0
- Valoración
- Aún sin valoraciones Valora este test