What is a view in a database? MCQ with Answer and Explanation

Question

Share Report Error

What is a view in a database?

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

B. A backup of a table

C. A physical table stored on disk

D. An index on a table

Answer: Option A

Solution (By JKSSB Mock Tests)

A view is a logical representation of data, derived from one or more tables, but does not store data physically.

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

Share Report

Who proposed the relational database model based on mathematical relation theory in 1970?

A. James Gosling

B. Dennis Ritchie

C. Charles Bachman

D. E.F. Codd

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Dr. Edgar Frank Codd (E.F. Codd) invented the relational model for database management while working for IBM in 1970.

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

Question #2

Share Report

Which of the following is a characteristic of the relational model?

A. Relationships are represented through keys

B. Data is accessed via SQL

C. All of the above

D. Data is stored in tables

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
The relational model organizes data in tables, uses keys for relationships, and is queried using a language like SQL.

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

Question #3

Share Report

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

Get Complete Subject PDF for Computer

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