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

Question Report Error

What does the SQL command 'INSERT INTO' do?

A. Deletes rows

B. Creates a table

C. Updates existing rows

D. Adds a new row to a table

Answer: Option D

Solution (By JKExamLibrary)

INSERT INTO is used to insert new records (rows) into a table.

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

Discuss this Question (0)

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

Practice More Database Management System (DBMS) Questions

Question #1 Report Error

In normalization, 1NF requires that:

A. All attributes have atomic values

B. The table has a primary key

C. There are no transitive dependencies

D. There are no partial dependencies

View Answer & Solution Discuss

Correct Answer: Option A

Explanation:
First Normal Form (1NF) ensures that each attribute contains only atomic (indivisible) values.

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

Question #2 Report Error

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

A. A set of allowed values for an attribute

B. A primary key

C. A table name

D. A foreign key

View Answer & Solution Discuss

Correct Answer: Option A

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 Report Error

In SQL, which clause is used to specify the table(s) from which to retrieve data?

A. WHERE

B. FROM

C. SELECT

D. GROUP BY

View Answer & Solution Discuss

Correct Answer: Option B

Explanation:
The FROM clause identifies the table(s) from which data is to be selected.

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

Explore All Database Management System (DBMS) MCQs