CIW 1D0-541 Exam Practice Test Instant Access

Question 1

Which term describes an attribute or combination of attributes that uniquely identifies a row in

a relation?

AEntity

BDomain

CPrimary key

DAttribute group

Answer : C

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

Consider the table for an employee database shown in the exhibit. What is the degree of the

table?

A25

D20

Answer : B

Question 7

Your enterprise has created a database and database application. The testing phase for the

project has started. Which of the following best describes white-box testing of the projects

software?

AThe database designer tests the software because he or she is able to make necessary changes to
the underlying code for the software.

BA user who has no knowledge of the softwares underlying code tests the software.

CSomeone other than the database designer tests the software. This person has no access to the
underlying code and attempts to use the
software only in ways not considered by the software designers.

DA person tests the software and submits suggestions to the software's underlying code. This
person is someone other than the database
designer, but has access to the softwares underlying code.

Answer : D

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