1D0-541 Practice Exam Questions with Answers CIW v5 Database Design Specialist Certification

BUILDING(Building_ID, Bldg_Name, Location, Room_Count)

Primary Key Building_ID RESIDENT(R_ID, Room_Num,

Res_Name, Building_ID) Primary Key R_ID

BUILDING(Building_ID, Bldg_Name, Location, Room_Count)

Primary Key BUILDING RESIDENT(R_ID, Room_Num,

Res_Name, Building_ID) Primary Key RESIDENT

BUILDING(Building_ID, Bldg_Name, Location, Room_Count) Primary Key BUILDING ForeignKey BUILDING(Building_ID) references RESIDENT(Building_ID) RESIDENT(R_ID, Room_Num, Res_Name, Building_ID) Primary Key RESIDENT

BUILDING(Building_ID, Bldg_Name, Location, Room_Count)

Primary Key Building_ID RESIDENT(R_ID, Room_Num,

Res_Name, Building_ID) Primary Key R_ID Foreign Key

Building_ID references BUILDING(Building_ID)

SELECT *

FROM Dept1_Parts

EXCEPT

(SELECT Part_ID

FROM Dept2_Parts);

SELECT *

FROM Dept1_Parts

MINUS

(SELECT Part_ID

FROM Dept2_Parts);

SELECT *

FROM Dept1_Parts

DIFFERENCE

(SELECT Part_ID

FROM Dept2_Parts);

SELECT *

FROM Dept1_Parts

DIFFERENCE

(SELECT Part_ID

FROM Dept2_Parts);

Only an update anomaly would occur.

An insertion anomaly would occur.

A deletion anomaly would occur.

An update anomaly and a deletion anomaly would occur.

UPDATE Recreation SET Activity,

Activity_Fee (‘Tennis’,100) WHERE

Student_ID = 1003;

UPDATE TABLE Recreation ALTER COLUMN ACTIVITY

SET ACTIVITY =‘Tennis', Activity_Fee = 100 WHERE

Student__ID = 1003 AND Activity = wimming?AND Activity=

?wimming?

UPDATE Recreation SET Activity =

‘Tennis', Activity_Fee = 100 WHERE

Student_ID = 1003 AND Activity =

'Swimming';

DELETE Activity FROM

Recreation WHERE

Student_ID = 1003; INSERT

INTO Recreation VALUES (1003,‘Tennis', 100);

OptionA

OptionB

OptionC

OptionD

Data Query Language

Database Entity Language

Data Definition Language

Data Manipulation Language

SELECT *

FROM Dept1_Parts

AND

(SELECT *

FROM Dept2_Parts);

SELECT *

FROM Dept1_Parts

INTERSECTION

(SELECT *

FROM Dept2_Parts);

SELECT *

FROM Dept1_Parts

WHERE Dept1_Parts.Part_ID = Dept2_Parts.Part_ID;

SELECT *

FROM Dept1_Parts

WHERE Dept1_Parts.Part_ID = Dept2_Parts.Part_ID;

A normalized set of data applicable to a particular relation

A combination of attributes for a relation

A definition of permissible values for one or more attributes

A set of permissible values for one or more relations

A primary key should be a value that may be null and may change over time.

A primary key should be a value that is not null and will never change.

A primary key should consist of meaningful data and a value that can be changed if needed.

A primary key should not consist of meaningful data and a value that can be changed if needed.

Entity

Domain

Primary key

Attribute group

Cust_Name is the determinant.

Cust_Name is transitively dependent on Cust_ID.

Cust_ID is transitively dependent on Cust_Name.

Cust_Name is functionally dependent on Cust_ID.

SELECT * FROM Customers

WHERE Satisfaction_Rate > 80

OR Sales_Office = Atlanta

SELECT * FROM Customers

WHERE Satisfaction_Rate <= 80

AND Sales_Office = Atlanta

SELECT * FROM Customers

WHERE Satisfaction_Rate >= 80;

SELECT * FROM Customers

WHERE Satisfaction_Rate >= 80

AND NOT Sales Office = Atlanta

Union

Difference

Projection

Intersection