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

Question

Share Report Error

What does the SQL command 'INSERT INTO' do?

A. Adds a new row to a table

B. Deletes rows

C. Updates existing rows

D. Creates a table

Answer: Option A

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 a Foreign Key?

A. To link two tables and enforce referential integrity

B. To uniquely identify records

C. To sort data

D. To create indexes

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
A foreign key establishes a relationship between tables and maintains referential integrity.

This question belongs to: Computer Database Management System (DBMS)

Question #2

What is a domain in the context of the relational model?

A. A table name

B. A primary key

C. A foreign key

D. A set of allowed values for an attribute

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
A domain defines the set of permissible values that an attribute can take, ensuring data consistency.

This question belongs to: Computer Database Management System (DBMS)

Question #3

Which statement about primary keys in a relational database table is completely true?

A. A table can have multiple distinct primary keys.

B. A table can contain at most one primary key.

C. A primary key column can accept a single NULL value.

D. Primary keys must always be numeric integers.

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
A relational database table can have exactly one primary key constraint defined, which uniquely identifies each record and strictly forbids NULLs.

This question belongs to: Computer Database Management System (DBMS)

Explore All Database Management System (DBMS) MCQs