INSERT command is used to A. add a single tuple to a relation B. add multiple…
2025
INSERT command is used to
A. add a single tuple to a relation
B. add multiple tuples to a relation
C. add values to specific attributes
D. insert new table
Choose the correct answer from the options given below:
- A.
A only
- B.
A, B only
- C.
A, B, C only
- D.
B, C, D only
Attempted by 1028 students.
Show answer & explanation
Correct answer: C
Answer: INSERT is used to add single or multiple tuples to a relation and to insert values into specific attributes; it is not used to create new tables.
Explanation:
Add a single tuple — INSERT supports inserting one row using a VALUES clause that provides the values for that tuple.
Add multiple tuples — many SQL dialects allow multiple value lists in one INSERT statement to insert several rows at once.
Insert into specific attributes — you can list target columns in the INSERT clause so values are placed into specific attributes.
Create new tables is not an INSERT operation — use CREATE TABLE to define a new table.
Therefore, the correct description is that INSERT is used to add single tuples, add multiple tuples, and insert values into specific attributes; it does not create new tables.
A video solution is available for this question — log in and enroll to watch it.