Examine the structure of the EMPLOYEES table: You need to update the records of employees 103 and 115. The UPDATE statement you specify should update the rows with the values specified below: Which…

The correct answer is C. UPDATE employees. This UPDATE statement is correct to receive desired results. Correct syntax is UPDATE table_name SET column_name1 = value, column_name2 = value2. You can also use the DEFAULT keyword to set a column value to its specified default value in update statements as Incorrect Answers…

Manipulating Data (DML)

Question

Examine the structure of the EMPLOYEES table:

You need to update the records of employees 103 and 115. The UPDATE statement you specify should update the rows with the values specified below:

Which UPDATE statement meets the requirements?

Exhibits

Options

AUPDATE employees
BUPDATE employees
CUPDATE employees
DUPDATE employees
EUPDATE employees

How the community answered

(24 responses)

A
4% (1)
B
13% (3)
C
79% (19)
E
4% (1)

Explanation

This UPDATE statement is correct to receive desired results. Correct syntax is UPDATE table_name SET column_name1 = value, column_name2 = value2. You can also use the DEFAULT keyword to set a column value to its specified default value in update statements as Incorrect Answers A: You cannot use syntax like UPDATE table_name SET column_name1 = value AND column_name2 = value2. Correct syntax is UPDATE table_name SET column_name1 = value, column_name2 = value2. B: You cannot use syntax like UPDATE table_name SET column_name1 = value AND column_name2 = value2. Correct syntax is UPDATE table_name SET column_name1 = value, column_name2 = value2. D: Group function is not allowed to use in the SET clause of the UPDATE command. E: You cannot set column to value DEFAULT OR NULL: this is wrong syntax to use.

Topics

#UPDATE statement#WHERE clause#DML syntax#multi-row update

Community Discussion

No community discussion yet for this question.

Full 1Z0-007 Practice