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

Question Report Error

What is a view in a database?

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

B. An index on a table

C. A backup of a table

D. A physical table stored on disk

Answer: Option A

Solution (By JKExamLibrary)

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)

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

What geometric symbol is used in an Entity-Relationship (ER) diagram to represent a relationship between entities?

A. Oval

B. Diamond

C. Circle

D. Rectangle

View Answer & Solution Discuss

Correct Answer: Option B

Explanation:
Diamonds are utilized in ER diagrams to depict relationships between two or more entities.

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

Question #2 Report Error

What is the purpose of the SQL 'IN' operator?

A. To join tables

B. To check if a value matches any value in a list

C. To check if a value is null

D. To check if a value is between two values

View Answer & Solution Discuss

Correct Answer: Option B

Explanation:
IN is used to test membership in a set of values.

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

Question #3 Report Error

Which of the following database concepts deals with grouping a set of SQL statements into a single logical unit of execution?

A. View definition

B. Normalization

C. Transaction

D. Indexing

View Answer & Solution Discuss

Correct Answer: Option C

Explanation:
A Transaction is a sequence of one or more SQL operations treated as a single, indivisible unit of work that must either succeed completely or fail completely.

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

Explore All Database Management System (DBMS) MCQs