多项选择题

Examine the description of the STUDENTS table:

Which two aggregate functions are valid on the START_DATE column?（）

A. SUM(start_date)
B. AVG(start_date)
C. COUNT(start_date)
D. AVG(start_date, end_date)
E. MIN(start_date)
F. MAXIMUM(start_date)

相关考题

The EMPLOYEE tables has these columns: LAST_NAME VARCHA...

单项选择题

The EMPLOYEE tables has these columns:
LAST_NAME VARCHAR2(35)
SALARY NUMBER(8,2)
COMMISSION_PCT NUMBER(5,2)
You want to display the name and annual salary multiplied by the commission_pct for all employees. For records that have a NULL commission_pct, a zero must be displayed against the calculated column.
Which SQL statement displays the desired results?（）

A. SELECT last_name, (salary * 12) * commission_pct FROM EMPLOYEES;
B. SELECT last_name, (salary * 12) * IFNULL(commission_pct, 0) FROM EMPLOYEES;
C. SELECT last_name, (salary * 12) * NVL2(commission_pct, 0) FROM EMPLOYEES;
D. SELECT last_name, (salary * 12) * NVL(commission_pct, 0) FROM EMPLOYEES;

Examine the description of the STUDENTS table: STD_ID N...

多项选择题

Examine the description of the STUDENTS table:
STD_ID NUMBER(4)
COURSE_ID VARCHARD2(10)
START_DATE DATE
END_DATE DATE
Which two aggregate functions are valid on the START_DATE column?（）

A. SUM(start_date)
B. AVG(start_date)
C. COUNT(start_date)
D. AVG(start_date, end_date)
E. MIN(start_date)
F. MAXIMUM(start_date)

Which syntax turns an existing constraint on?（）A. ALTER...

单项选择题Which syntax turns an existing constraint on?（）

A. ALTER TABLE table_name   ENABLE constraint_name;
B. ALTER TABLE table_name   STATUS = ENABLE CONSTRAINT constraint_name;
C. ALTER TABLE table_name   ENABLE CONSTRAINT constraint_name;
D. ALTER TABLE table_name   STATUS ENABLE CONSTRAINT constraint_name;
E. ALTER TABLE table_name   TURN ON CONSTRAINT constraint_name;

1Z0-007

Examine the description of the STUDENTS table: Which two aggregate functions are valid on the START_DATE column?（）

Examine the description of the STUDENTS table:

Which two aggregate functions are valid on the START_DATE column?（）