<b id="84pce"></b>

單項選擇題

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 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 );

單項選擇題

The STUDENT_GRADES table has these columns:
STUDENT_ID NUMBER(12)
SEMESTER_END DATE
GPA NUMBER(4,3)
The registrar requested a report listing the students' grade point averages (GPA) sorted from highest grade point average to lowest.
Which statement produces a report that displays the student ID and GPA in the sorted order requested by the registrar?（）

A.SELECT student_id, gpa FROM student_grades ORDER BY gpa ASC;
B.SELECT student_id, gpa FROM student_grades SORT ORDER BY gpa ASC;
C.SELECT student_id, gpa FROM student_grades SORT ORDER BY gpa;
D.SELECT student_id, gpa FROM student_grades ORDER BY gpa;
E.SELECT student_id, gpa FROM student_grades SORT ORDER BY gpa DESC;
F.SELECT student_id, gpa FROM student_grades ORDER BY gpa DESC;

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?（）

你可能感興趣的試題

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?（）