CIW 1D0-541 Quiz 1 Topic 1 Questions 1-5

Question: 1

What is a virtual table?

AA virtual table is a relation created as the result of data manipulation, and is not a permanent
part of the database.

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

CA virtual table is a relation created from a defined base table; it contains metadata about the base
relation.

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

Show Answer

Question: 2

Which relational algebraic operation is used to select specific columns (attributes) from a

relation?

AUnion

BDifference

CProjection

DIntersection

Show Answer

Question: 3

Which mechanism provides database users with controlled access to the database through the

use of virtual tables?

AView

BData dictionary

CDatabase control language

DDatabase management system

Show Answer

Question: 4

Consider the following relational algebraic expression as well as the Dept1_Parts and

Dept2_Parts relations shown in the exhibit,

q4_1D0-541

Which of the following relations would result from the given relational algebraic expression?

AOption A

BOption B

COption C

DOption D

Show Answer

Question: 5

Consider the Registration relation shown in the exhibit. Which of the following SQL

statements would return the Registration2 relation from the Registration relation?

q5_1D0-541

ASELECT Course_Code
FROM Registration;

BSELECT *
FROM Registration
WHERE Registration_ID = 1003
AND Registration_ID = 1005;

CSELECT *
FROM Registration
WHERE Course_Code = 'A4343';

DSELECT Registration_ID, Student_ID, First_Name, Last_Name
FROM Registration
WHERE Course_Code = 'A4343';

Show Answer

CIW 1D0-541 Quiz:1 Topic:1 Questions:1-5