Which of the following SQL commands can be used to add data to a database table?
A. ADD
B. UPDATE
C. APPEND
D. INSERT
Answer: Option D
Solution (By Examveda Team)
The SQL command used to add data to a database table is INSERT. The INSERT statement is used to insert new rows or records into a table. Option D is the correct choice for adding data to a table in SQL. Options A, B, and C are not typically used for this purpose in SQL.This Question Belongs to SQL >> Sql Miscellaneous
Consider the following table -
P F
-----
2 4
3 4
4 3
5 2
7 2
9 5
6 4
Here P is a primary key and F is a foreign key referencing P with cascaded deletion. On the deletion of the entry (2, 4), which of the following tuples will also be deleted?