1D0-541 Exam — Question 3

Exam 1D0-541 All QuestionsBrowse all questions from this exam

Question 3

What is a virtual table?

A.

A virtual table is a relation created as the result of data manipulation; it exists only in computer memory, and is not a permanent part of the database.

B.

A virtual table is a relation stored in the database; it is used when multiple users access the same relation in a database.

C.

A virtual table is a relation derived from the database data dictionary; it contains metadata about a base relation. A virtual table is a relation derived from the database? data dictionary; it contains metadata about a base relation.

D.

A virtual table is a relation that consists of primary and foreign keys for a particular set of relations in a database.

Correct Answer: A

A virtual table is a relation created as the result of data manipulation; it exists only in computer memory, and is not a permanent part of the database. This definition captures the essence of what a virtual table, or a 'view', is in database terminology. Views temporarily represent the data stored in the actual tables but do not store data themselves in the database.

Discussion

dayogreatsOption: C

the correct answer is C

dayogreats

Sorry I made a mistake in my first response. Here is the correct answer: A. A virtual table is a relation created as the result of data manipulation; it exists only in computer memory and is not a permanent part of the database.