Which of the following is a characteristic of a view? MCQ with Answer and Explanation

Question

Share Report Error

Which of the following is a characteristic of a view?

A. It is always faster than a table

B. It stores data physically

C. It is a virtual table based on a query

D. It cannot be updated

Answer: Option C

Solution (By JKSSB Mock Tests)

A view is a virtual table that does not store data physically; it presents data from one or more tables as if it were a table.

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

Which of the following is an example of a relational database management system (RDBMS)?

A. MongoDB

B. Redis

C. Cassandra

D. Oracle Database

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Oracle Database is a well-known RDBMS. MongoDB, Redis, and Cassandra are NoSQL databases.

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

Question #2

A view in DBMS is:

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

B. An index on the table

C. A backup of the database

D. A physical copy of the table

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
A view is a virtual table derived from one or more base tables.

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

Question #3

In SQL, what does the wildcard '%' match when used with LIKE?

A. Any string of zero or more characters

B. A specific character

C. Any single character

D. Only digits

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
'%' matches any sequence of zero or more characters, while '_' matches a single character.

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

Explore All Database Management System (DBMS) MCQs