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

What is a view in a database?

A. A backup of a table

B. An index on a table

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

D. A physical table stored on disk

Answer: Option C

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)

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

Question #1 Report Error

Which of the following is a property of a database that ensures transactions are isolated from each other?

A. Isolation

B. Atomicity

C. Durability

D. Consistency

Correct Answer: Option A

Explanation:
Isolation ensures that concurrent execution of transactions results in a state that is equivalent to some serial execution.

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

Question #2 Report Error

What does DBMS stand for?

A. Database Management System

B. Data Backup Management System

C. Digital Business Management Software

D. Dynamic Binary Manipulation System

Correct Answer: Option A

Explanation:
DBMS stands for Database Management System, which is software for creating and managing databases.

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

Question #3 Report Error

Which of the following is a valid SQL statement to create a table?

A. Both A and B

B. Neither

C. CREATE TABLE table_name AS SELECT ...;

D. CREATE TABLE table_name (column1 datatype, column2 datatype);

Correct Answer: Option A

Explanation:
Both syntaxes are valid: direct CREATE TABLE with columns, and CREATE TABLE ... AS SELECT to create a table from a query result.

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