1Z0-007

单项选择题

The STUDENT_GRADES table has these columns:
STUDENT_ID NUMBER(12)
SEMESTER_END DATE
GPA NUMBER(4,3)
Which statement finds the highest grade point average (GPA) per semester?（）

A.SELECT MAX(gpa) FROM student_grades WHERE gpa IS NOT NULL;
B.SELECT (gpa) FROM student_grades GROUP BY semester_end WHERE gpa IS NOT NULL;
C.SELECT MAX(gpa) FROM student_grades WHERE gpa IS NOT NULL GROUP BY semester_end;
D.SELECT MAX(gpa) GROUP BY semester_end WHERE gpa IS NOT NULL FROM student_grades;
E.SELECT MAX(gpa) FROM student_grades GROUP BY semester_end WHERE gpa IS NOT NULL;

相关考题

Which three are DATETIME data types that can be used wh...

多项选择题Which three are DATETIME data types that can be used when specifying column definitions? （）

A.TIMESTAMP
B.INTERVAL MONTH TO DAY
C.INTERVAL DAY TO SECOND
D.INTERVAL YEAR TO MONTH
E.TIMESTAMP WITH DATABASE TIMEZONE

Examine the structure of the EMPLOYEES table: EMPLOYEE_...

单项选择题

Examine the structure of the EMPLOYEES table:
EMPLOYEE_ID NUMBER Primary Key
FIRST_NAME VARCHAR2(25)
LAST_NAME VARCHAR2(25)
HIRE_DATE DATE
Which UPDATE statement is valid?（）

A.UPDATE employees SET first_name = 'John' SET last_name ='Smith' WHERE employee_id = 180;
B.UPDATE employees SET first_name = 'John', SET last_name ='Smith' WHERE employee_id = 180;
C.UPDATE employees SET first_name = 'John' AND last_name ='Smith' WHERE employee_id = 180;
D.UPDATE employees SET first_name = 'John', last_name ='Smith' WHERE employee_id = 180;

Examine the structure of the EMPLOYEES and DEPARTMENTS ...

单项选择题

Examine the structure of the EMPLOYEES and DEPARTMENTS tables:
EMPLOYEES
EMPLOYEE_ID NUMBER
DEPARTMENT_ID NUMBER
MANAGER_ID NUMBER
LAST_NAME VARCHAR2(25)
DEPARTMENTS
DEPARTMENT_ID NUMBER
MANAGER_ID NUMBER
DEPARTMENT_NAME VARCHAR2(35)
LOCATION_ID NUMBER
You want to create a report displaying employee last names, department names, and locations. Which query should you use?（）

A.SELECT e.last_name, d. department_name, d.location_id FROM employees e NATURAL JOIN departments D USING department_id ;
B.SELECT last_name, department_name, location_id FROM employees NATURAL JOIN departments WHERE e.department_id =d.department_id;
C.SELECT e.last_name, d.department_name, d.location_id FROM employees e NATURAL JOIN departments d;
D.SELECT e.last_name, d.department_name, d.location_id FROM employees e JOIN departments d USING (department_id );

All Rights Reserved 版权所有©牛牛题库网(nntiku.com)

备案号：湘ICP备2022003000号-1