CIW 1D0-541 Exam Practice Test Instant Access

Question 1

Consider the following table as well as the Dept1_Parts and Dept2_Parts relations shown in

the exhibit:

Which of the following relational algebraic expressions would result in the given table?

AOption A

BOption B

COption C

DOption D

Answer : A

Question 2

Which pair of relational algebraic operations requires union compatibility?

AProjection and Cartesian product

BSelection and projection

CIntersection and difference

DCartesian product and intersection

Answer : C

Question 3

Consider the entity-relation (ER) diagram shown in the exhibit. When the logical database

design phase is completed, which of the following is a valid DBDL description of the base

relations for the ER diagram?

ASTUDENT(
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

BSTUDENT(
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

CSTUDENT(
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

DSTUDENT(
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

Answer : D

Question 4

Which of the following definitions applies to all types of databases?

AData that is stored as tables

BSoftware that manipulates data

CData that is stored in a structured manner

DData records that are stored sequentially in a file

Answer : C

Question 5

Your enterprise must decide whether to use a database management system. Which of the

following best describes the overall functionality of a DBMS?

AA DBMS provides the ability to control data access using Data Manipulation Language.

BA DBMS provides the ability to maintain databases while providing increased security for the
database.

CA DBMS allows users to access the database while allowing only the database administrator to
define user views.

DA DBMS provides the ability to define, create and maintain databases while providing
controlled access to databases.

Answer : D

Question 6

Which type of relational integrity is violated if a primary key in a database has a null value?

AEntity integrity

BDomain integrity

CDomain constraints

DReferential integrity

Answer : A

Question 7

Consider the Orders relation shown in the exhibit. Which of the following SQL statements

would return all complete tuples for order dates in 2002, arranged by amount from lowest to

highest?

ASELECT *
FROM Orders
WHERE Order_Date LIKE _02
ORDER BY Amount;

BSELECT (Order_Date, Amount)
FROM Orders
WHERE Order_Date LIKE %02
ORDER BY Amount;

CSELECT *
FROM Orders
WHERE Order_Date LIKE _02
ORDER BY Order_No;

DSELECT *
FROM Orders
WHERE Order_Date LIKE %02
ORDER BY Amount;

Answer : D

CIW 1D0-541 CIW v5 Database Design Specialist Exam Practice Test