Pass the CIW Web Development Series 1D0-541 Questions and answers with ExamsMirror

Views

Concurrency

Locking

Integrity controls

Create intermediate entities.

Create a logical data model.

Resolve many-to-manyrelationships.

Identify and resolve complex relationships.

It is the primary key for an entity.

It uniquely identifies every instance of an entity.

One or more keys are joined together to form a composite key.

One or more keys may be used to form a primary key.

OptionA

OptionB

OptionC

OptionD

1:1

1:N

N:1

M:N

A composite key is a primary key that consists of the first two attributes of a relation.

A composite key is a primary or foreign key defined by its parent keys.

A composite key is a foreign key that consists of the same attributes as the primary key from a related table.

A composite key is a primary or foreign key that consists of two or more attributes of a relation.

The ordering of attributes in a table is significant.

An attribute contains values from multiple domains.

An attribute name can be used only once per table.

An attribute name can be used only once in a relational database system with multiple tables.

Boyce-Codd normal form

First normal form

Second normal form

Third normal form

A system catalog containing user data

An area of the database that is directly accessible by the user

Data that is stored in tables and is only accessible by the DBMS

Metadata that is stored in tables and is only accessible by the DBMS

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;