[单选题]

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

参考答案与解析：

相关试题

The（ ）may examine or re-examine the goods or take samples from them straightaway in the absence of t

[单选题]The（ ）may examine or re-examine the goods or take samples from them straigh

  • 查看答案

    • The（ ）may examine or re-examine the goods or takesamples from them straightaway in the absence of th

    [单选题]The（ ）may examine or re-examine the goods or takesamples from them straight

  • 查看答案

    • Click the Exhibit button and examine the

    [单选题]Click the Exhibit button and examine the data in the EMPLOYEES and DEPARTMENTS tables.You want to retrieve all employees, whether or not they have matching departments in the departments table. Which query would you use?（）A . SELECT last_name, depart

  • 查看答案

    • Employees in this company have to have a

    [主观题]E．mployees in this company have to have a good command of English. Tell me about your ability in speaking and understanding in English.

  • 查看答案

    • According to the text, GM employees( )[

    [单选题]A．ccording to the text, GM employees（ ）[A] worry about the production cost of cars[B] express the dissatisfaction with their welfare[C] show much confidence in their chairman[D] feel excited when voicing their opinions

  • 查看答案

    • structure domain

    [名词解释] structure domain

  • 查看答案

    • A systematic textbook evaluation is NOT to examine whether a textbook __________．

    [单选题]A systematic textbook evaluation is NOT to examine whether a textbook _____

  • 查看答案

    • 20. Among employees __________, the supp

    [单选题]20. Among employees __________, the support for the change is zero. A. at length B. at last C. at large D. at best

  • 查看答案

    • In the author’s opinion, employees shoul

    [单选题]In the author’s opinion, employees should _____.［A］ invest in company stock to show loyalty to their employer［B］ get out of their own company’s stock［C］ wait for some time before disposing of their stock［D］ give trust to a particular company’s stock

  • 查看答案

    • The software structure is an expression

    [单选题]The software structure is an expression of the relationship among software modules.In the following phrases, which are NOT the relations among software modules? (2 Points)Ⅰ.calling relationⅡ.belonging relationⅢ.Execution relationⅣ.process relationA．Ⅰ

  • 查看答案