A view in DBMS is: MCQ with Answer and Explanation

Question Report Error

A view in DBMS is:

A. A backup of the database

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

C. An index on the table

D. A physical copy of the table

Answer: Option B

Solution (By JKExamLibrary)

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

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

Which of the following is a valid SQL statement to update a record?

A. MODIFY table_name SET column1 = value1 WHERE condition;

B. UPDATE table_name SET column1 = value1 WHERE condition;

C. UPDATE table_name column1 = value1 WHERE condition;

D. CHANGE table_name SET column1 = value1 WHERE condition;

View Answer & Solution Discuss

Correct Answer: Option B

Explanation:
The correct syntax for UPDATE is: UPDATE table_name SET column1 = value1 WHERE condition;

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

Question #2 Report Error

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

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

B. A table can have multiple distinct primary keys.

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

D. Primary keys must always be numeric integers.

View Answer & Solution Discuss

Correct Answer: Option C

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)

Question #3 Report Error

What does a database constraint called a 'CHECK' constraint do?

A. It checks if the database server is running safely.

B. It limits the range of values that can be placed in a column based on a specific condition.

C. It verifies user authentication passwords.

D. It automatically links tables together.

View Answer & Solution Discuss

Correct Answer: Option B

Explanation:
A CHECK constraint enforces domain integrity by limiting the values accepted by a column to only those that satisfy a specified Boolean predicate.

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

Explore All Database Management System (DBMS) MCQs