What is a virtual table that does not physically exist on storage but is defined by an underlying SQL query called? MCQ with Answer and Explanation

What is a virtual table that does not physically exist on storage but is defined by an underlying SQL query called?
A. Index
B. View
C. Trigger
D. Stored Procedure
Answer: Option B
Solution (By JKSSB Mock Tests)
A View is a virtual, logical table derived from the result set of an SQL SELECT query. It behaves like a table but does not store data independently.

Discuss this Question (0)

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

Practice More Database Management System (DBMS) Questions

Question #1
A candidate key is:
A. Always the primary key
B. Any key with duplicates
C. A minimal super key
D. A foreign key only

Correct Answer: Option C


Explanation:
A candidate key is a minimal set of attributes that can uniquely identify a tuple.

This question belongs to: Computer Database Management System (DBMS)
Question #2
What is a relation in relational database terms?
A. A table
B. A row
C. A key
D. A column

Correct Answer: Option A


Explanation:
In the relational model, a relation is a table consisting of rows and columns.

This question belongs to: Computer Database Management System (DBMS)
Question #3
Which of the following is a method to avoid deadlock?
A. Deadlock detection and resolution
B. Lock ordering
C. Using a timeout
D. All of the above

Correct Answer: Option D


Explanation:
Strategies to handle deadlocks include timeout, lock ordering, and detection with rollback.

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