Your Path to Success: How to Pass the CIW 1D0-541 CIW v5 Database Design Specialist Exam

Union

Selection

Projection

Difference

A group of attributes

A set of permissible tuple values

A collection of related data items

A set of permissible attribute values

SELECT *

FROM Orders

WHERE Order_Date LIKE _02

ORDER BY Amount;

SELECT (Order_Date, Amount)

FROM Orders

WHERE Order_Date LIKE %02

ORDER BY Amount;

SELECT *

FROM Orders

WHERE Order_Date LIKE _02

ORDER BY Order_No;

SELECT *

FROM Orders

WHERE Order_Date LIKE %02

ORDER BY Amount;

1,2,3,4

3,4,1,2

4,3,1,2

4,2,3,1

Locking

Time stamps

Optimistic

Serialization

STUDENT(

Student_Number: integer NOT NULL

Name: variable length character string length 20 NOT NULL)

Primary Key Student_Number

CLASS(

Class_Num: integer NOT NULL

Class_Name: integer NOT NULL)

Primary Key Class_Num

STUDENT(

Student_Number: integer NOT NULL

Name: variable length character string length 20 NOT NULL)

Primary Key Student_Number

CLASS(

Class_Num: integer NOT NULL

Class_Name: integer NOT NULL)

Primary Key Class_Num

Foreign Key Class_Num References STUDENT

STUDENT(

Student_Number: integer NOT NULL

Name: variable length character string length 20 NOT NULL)

Primary Key Student_Number

STU_CLASS(

Student_Number: integer NOT NULL

Class_Num: integer NOT NULL)

Primary Key Student_Number

CLASS(

Class_Num: integer NOT NULL

Class_Name: integer NOT NULL)

Primary Key Class_Num

STUDENT(

Student_Number: integer NOT NULL

Name: variable length character string length 20 NOT NULL)

Primary Key Student_Number

STU_CLASS(

Student_Number: integer NOT NULL

Class_Num: integer NOT NULL)

Primary Key Student_Number, Class_Num

CLASS(

Class_Num: integer NOT NULL

Class_Name: integer NOT NULL)

Primary Key Class_Num

View

Data dictionary

Database control language

Database management system