When using the SQL INSERT statement:
A. rows cannot be copied in mass from one table to another only.
B. rows can be modified according to criteria only.
C. rows can either be inserted into a table one at a time or in groups.
D. rows can be inserted into a table only one at a time only.
Answer: Option C
Solution(By Examveda Team)
When using the SQL INSERT statement, rows can either be inserted into a table one at a time or in groups. This means that you can insert multiple rows into a table with a single INSERT statement, making it more efficient for mass data insertion. Option C is the correct choice, while Options A, B, and D do not accurately describe the capabilities of the INSERT statement.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
Join The Discussion