Which SQL command is used to add new rows of data into an existing table? MCQ with Answer and Explanation

Question

Share Report Error

Which SQL command is used to add new rows of data into an existing table?

A. INSERT

B. APPEND

C. UPDATE

D. ADD

Answer: Option A

Solution (By JKSSB Mock Tests)

The INSERT command is a Data Manipulation Language (DML) statement used to add new records/rows to 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

Which of the following is a valid SQL statement to create a view?

A. Neither

B. Both A and B

C. CREATE VIEW view_name AS SELECT ...;

D. CREATE VIEW view_name (columns) AS SELECT ...;

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Both syntaxes are valid: CREATE VIEW view_name AS SELECT ... and with column aliases.

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

Question #2

A view in DBMS is:

A. An index on the table

B. A virtual table based on the result of a query

C. A physical copy of the table

D. A backup of the database

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
A view is a virtual table derived from one or more base tables.

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

Question #3

What is metadata?

A. Temporary data

B. Data about data

C. User data

D. Backup data

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Metadata is data that provides information about other data, such as structure and constraints.

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

Explore All Database Management System (DBMS) MCQs