SQL projection queries and NUMBER data types

1. 1Which query creates a projection of the DEPARTMENT_NAME and LOCATION_ID
   columns from the DEPARTMENTS table? (Choose the best answer.)

   1. ASELECT DISTINCT DEPARTMENT_NAME, LOCATION_ID
      FROM DEPARTMENTS;
   2. BSELECT DEPARTMENT_NAME, LOCATION_ID
      FROM DEPARTMENTS;
   3. CSELECT DEPT_NAME, LOC_ID
      FROM DEPT;
   4. DSELECT DEPARTMENT_NAME AS “LOCATION_ID”
      FROM DEPARTMENTS;
2. 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.)

   1. ASALARY=12345678
   2. BSALARY=123456.78
   3. CSALARY=12345.678
   4. DSALARY=123456
   5. ESALARY=12.34

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

Rate this quiz

More on SELECT Queries