A view in DBMS is: MCQ with Answer and Explanation

A view in DBMS is:
A. An index on the table
B. A physical copy of the table
C. A backup of the database
D. A virtual table based on the result of a query
Answer: Option D
Solution (By JKSSB Mock Tests)
A view is a virtual table derived from one or more base tables.

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 a 'foreign key' constraint specifically designed to prevent?
A. Unauthorized login attempts to the database.
B. Actions that would destroy links or introduce invalid references between tables.
C. Slow search execution times.
D. The use of duplicate data values within the primary key column.

Correct Answer: Option B


Explanation:
A Foreign Key constraint enforces referential integrity, preventing updates or deletions that would leave orphaned child records pointing to non-existent parent rows.

This question belongs to: Computer Database Management System (DBMS)
Question #2
Which of the following is a TCL (Transaction Control Language) command?
A. CREATE
B. SAVEPOINT
C. SELECT
D. DROP

Correct Answer: Option B


Explanation:
Transaction Control Language includes COMMIT, ROLLBACK, and SAVEPOINT.

This question belongs to: Computer Database Management System (DBMS)
Question #3
Which of the following commands is a Data Manipulation Language (DML) statement?
A. TRUNCATE
B. UPDATE
C. COMMENT
D. RENAME

Correct Answer: Option B


Explanation:
UPDATE is a DML statement because it is used to modify existing data values within rows of a database table, rather than modifying the structural schema.

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