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?

technology databases

  1. MERGE

  2. INSERT

  3. UPDATE

  4. ADD

  5. ENTER

  6. You cannot enter the phone numbers for the existing employee records.

Show answer
Correct Option: A

AI Explanation

To enter the phone numbers of each of the 100 employees into the existing EMPLOYEES table, the appropriate data manipulation operation to perform is the INSERT operation.

Option A) MERGE - The MERGE operation is used to update or insert data into a target table based on a condition. It is not necessary in this scenario since we are only inserting data.

Option B) INSERT - This option is correct. The INSERT operation is used to add new rows of data into a table. In this case, we are adding the phone numbers of each employee into the table.

Option C) UPDATE - The UPDATE operation is used to modify existing data in a table. It is not necessary in this scenario since we are not modifying existing data, but rather adding new data.

Option D) ADD - The ADD operation is used to add new columns to an existing table. It is not necessary in this scenario since we are not adding a new column, but rather adding data to an existing column.

Option E) ENTER - This option is not a valid data manipulation operation in SQL. It is not applicable in this scenario.

Option F) You cannot enter the phone numbers for the existing employee records - This option is incorrect. It is possible to enter the phone numbers for the existing employee records by performing the INSERT operation.

Therefore, the correct answer is B) INSERT.

Find more quizzes: