Term
Which query creates a projection of the DEPARTMENT_NAME and LOCATION_ID
columns from the DEPARTMENTS table? |
|
Definition
A. SELECT DISTINCT DEPARTMENT_NAME, LOCATION_ID
FROM DEPARTMENTS;
B. SELECT DEPARTMENT_NAME, LOCATION_ID
FROM DEPARTMENTS;
C. SELECT DEPT_NAME, LOC_ID
FROM DEPT;
D. SELECT DEPARTMENT_NAME AS “LOCATION_ID”
FROM DEPARTMENTS; |
|
|
Term
After 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? |
|
Definition
A. SALARY=12345678
B. SALARY=123456.78
C. SALARY=12345.678
D. SALARY=123456
E. SALARY=12.34 |
|
|
Term
After describing the JOB_HISTORY table, you discover that the START_DATE and END_
DATE columns have a data type of DATE. Consider the expression END_DATE-START_
DATE. (Choose two correct statements.) |
|
Definition
A. A value of DATE data type is returned.
B. A value of type NUMBER is returned.
C. A value of type VARCHAR2 is returned.
D. The expression is invalid since arithmetic cannot be performed on columns with DATE
data types.
E. The expression represents the days between the END_DATE and START_DATE less one
day. |
|
|
Term
The DEPARTMENTS table contains a DEPARTMENT_NAME column with data type
VARCHAR2(30). (Choose two true statements about this column.) |
|
Definition
A. This column can store character data up to a maximum of 30 characters.
B. This column must store character data that is at least 30 characters long.
C. The VARCHAR2 data type is replaced by the CHAR data type.
D. This column can store data in a column with data type VARCHAR2(50) provided that the
contents are at most 30 characters long. |
|
|
