[单选题]

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

  • 查看答案
  • If no ______ is imposed on an employee for poor performance, other employees may react by reducing t

    If no ______ is imposed on an employee for poor performance, other employees may

  • 查看答案
  • 2.If there is friction between team members, examine the work processes they mutually own.Which of t

    2.If there is friction between team members, examine the work processes they mut

  • 查看答案
  • 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

  • 查看答案
  • Besides the knowledge in their particular fields, employees must always have additional skills-----t

    Besides the knowledge in their particular fields, employees must always have add

  • 查看答案
  • Besides the knowledge in their particular fields, employees must always have additional skills-----t

    Besides the knowledge in their particular fields, employees must always have add

  • 查看答案
  • 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

  • 查看答案
  • When the new software was introduced, many employees struggled to adapt because they didn’t see its

    When the new software was introduced, many employees struggled to adapt because

  • 查看答案
  • structure domain

    [名词解释] structure domain

  • 查看答案
  • The old entrepreneur didn't ()any of his employees during that serious recession, which won him

    The old entrepreneur didnt ()any of his employees during that serious recession,

  • 查看答案