1D0-541 Exam QuestionsBrowse all questions from this exam

1D0-541 Exam - Question 3

What is a virtual table?

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.

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

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.

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

Show Answer

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

1 comment

dayogreatsOption: C

Jul 24, 2023

the correct answer is C

dayogreats

Aug 3, 2023

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.