1Z0-007 · Question #182
You added a PHONE_NUMBER column of NUMBER data type to an existing EMPLOYEES table. The EMPLOYEES table already contains records of 100 employees. Now, you want to enter the phone numbers of each of…
The correct answer is C. UPDATE. To update information you need to use UPDATE command. Incorrect Answers A: Since you don't have to add any records to the table you don't need the MERGE command. B: Since you don't have to add any records to the table you don't need the MERGE command. D: There is no ADD command…
Question
You added a PHONE_NUMBER column of NUMBER data type to an existing EMPLOYEES table. The EMPLOYEES table already contains records of 100 employees. Now, you want to enter the phone numbers of each of the 100 employees into the table. Some of the employees may not have a phone number available. Which data manipulation operation do you perform?
Options
- AMERGE
- BINSERT
- CUPDATE
- DADD
- EENTER
- FYou cannot enter the phone numbers for the existing employee records.
How the community answered
(41 responses)- B5% (2)
- C78% (32)
- D2% (1)
- E12% (5)
- F2% (1)
Explanation
To update information you need to use UPDATE command. Incorrect Answers A: Since you don't have to add any records to the table you don't need the MERGE command. B: Since you don't have to add any records to the table you don't need the MERGE command. D: There is no ADD command in Oracle. E: There is no ENTER command in Oracle. F: You can enter the phone numbers for the existing employee records by using UPDATE
Topics
Community Discussion
No community discussion yet for this question.