Multiple choice technology databases

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?

  1. MERGE

  2. INSERT

  3. UPDATE

  4. ADD

  5. ENTER
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

When you need to add data to existing records in a table, you use the UPDATE statement. The INSERT statement creates new rows, whereas UPDATE modifies existing rows. Since the table already has 100 employee records and you want to add phone numbers to those records (some of which may be NULL if unavailable), UPDATE is the correct operation.

Keep practicing — related questions