1D0-541 Exam Dumps : CIW v5 Database Design Specialist

The intersection oftwo relations

ACartesian product of two relations

Arestricted Cartesian product of two relations

The Cartesian product oftwo union-compatible relations

Attribute, domain, and tuple

Entity, relation name, and domain

Table name, primary key, and entity

Attribute, relation name, and primary key

CREATE VIEW Emp_Dept AS SELECT

Last_Name, First_Name, Dept_ID FROM

Employee;

UPDATE VIEW Emp_Dept

AS SELECT * FROM

Employee;

UPDATE VIEW Emp_Dept AS SELECT

Last_Name, First_Name, Dept_ID FROM

Employee;

CREATE VIEW Emp_Dept

AS SELECT * FROM

Employee WHERE ID = 0001

AND ID = 0002 AND ID =

0003 AND ID = 0004;