What does the SQL command 'INSERT INTO' do? MCQ with Answer and Explanation

Question
What does the SQL command 'INSERT INTO' do?
A. Creates a table
B. Adds a new row to a table
C. Updates existing rows
D. Deletes rows
Answer: Option B
Solution (By JKSSB Mock Tests)
INSERT INTO is used to insert new records (rows) into a table.
This question belongs to: Computer Database Management System (DBMS)
Request complete Subject PDF

Discuss this Question (0)

No comments yet. Be the first to start the discussion!

Practice More Database Management System (DBMS) Questions

Question #1
What is the purpose of the SQL 'NULL' value?
A. To represent empty string
B. To represent zero
C. To represent an error
D. To represent missing or unknown data
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
NULL is a special marker indicating that a value is unknown or missing, not the same as zero or empty string.
This question belongs to: Computer Database Management System (DBMS)
Question #2
What is the purpose of the SQL 'UNION' operator?
A. To combine the results of two or more SELECT statements, removing duplicates
B. To join tables horizontally
C. To aggregate data
D. To filter duplicates
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
UNION concatenates the result sets of two or more queries, eliminating duplicate rows. UNION ALL keeps duplicates.
This question belongs to: Computer Database Management System (DBMS)
Question #3
What is a database transaction?
A. A database schema
B. A logical unit of work that consists of one or more SQL statements
C. A query that reads data
D. A backup copy of the database
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
A transaction is a sequence of operations performed as a single logical unit, ensuring ACID properties.
This question belongs to: Computer Database Management System (DBMS)
Explore All Database Management System (DBMS) MCQs
Today's Top Topics
Cyber Security 269 Database Management System (DBMS) 278 Computer Abbreviations 369 Computer Fundamentals 326 Computer Software 347
Explore Subjects
Accountancy and Statistics 3179 Economy GK 2220 English 15164 Computer 5279 Current Affairs 575
Practice Mix
Which of the following is an indirect tax in India?
The valve between the left atrium and left ventricle is the:
A person faces north. He turns 45° left, then 90° right, then 45° left. Which direction is he facing?
Under the Income Tax Act, the 'TDS' on the sale of an immovable property (other than agricultural land) by a resident is governed by which section, and what is the rate?
In 'Piecemeal Distribution' during dissolution, the first priority for payment of outside liabilities is: