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.Join The Discussion
Comments ( 1 )
Related Questions on Sql Miscellaneous
A. Structured Query Language
B. Structured Query List
C. Simple Query Language
D. None of these
Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables?
A. Data Definition Language(DDL)
B. Data Manipulation Language(DML)
C. Both of above
D. None
Which operator performs pattern matching?
A. BETWEEN operator
B. LIKE operator
C. EXISTS operator
D. None of these
What operator tests column for the absence of data?
A. EXISTS operator
B. NOT operator
C. IS NULL operator
D. None of these
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?