Logo ExamsQA
Exit
Official Bank 0/127

CIW v5 Database Design Specialist (1D0-541) - CIW Exam Questions

Last updated on June 20, 2026

97% Exam Compliance
127 Total Questions
1
Question
Consider the following relational algebraic expression as well as the Dept1_Parts and

Dept2_Parts relations shown in the exhibit:

Exhibit

Which of the following relations would result from the given relational algebraic expression? A. B . C. D.

Exhibit
Reveal Only
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

2
Question
Which relational algebraic operation is used to select specific columns (attributes) from a relation?
Options
A Union
B Intersection
C Projection
D Difference
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

3
Question
Consider the Dept1_Parts and Dept2_Parts relations shown in the exhibit. Which of the following SQL statements would create a set difference of the two relations with the widest variety of Structured Query Language dialects?

Exhibit
Options
A SELECT *
FROM Dept1_Parts
EXCEPT (SELECT Part_ID
FROM Dept2_Parts);
B SELECT *
FROM Dept1_Parts
DIFFERENCE (SELECT Part_ID
FROM Dept2_Parts);
C SELECT *
FROM Dept1_Parts
MINUS (SELECT Part_ID
FROM Dept2_Parts);
D SELECT *
FROM Dept1_Parts
DIFFERENCE (SELECT Part_ID
FROM Dept2_Parts);
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

4
Question
Consider the Information Engineering diagram shown in the exhibit for a building management company. Referential integrity must be maintained such that a building cannot be deleted when it has residents. Building_ID, R_ID, Room_Count and Room_Num are integer numbers, whereas Bldg_Name, Location and Res_Name are all represented by variable-length strings with a maximum of 20 characters. Which SQL statement best implements the relations shown in this diagram?

Exhibit
Options
A CREATE TABLE BUILDING ( Building_ID INTEGER NOT NULL PRIMARY KEY,
Bldg_Name VARCHAR (20),
Location VARCHAR (20),
Room_Count INTEGER );
CREATE TABLE RESIDENT ( R_ID NOT NULL PRIMARY KEY,
Room_Num INTEGER,
Res_Name VARCHAR (20),
Building_ID INTEGER NOT NULL,
FOREIGN KEY Building_ID REFERENCES RESIDENT (Building_ID)
ON DELETE NO CHECK);
B CREATE TABLE BUILDING ( Building_ID INTEGER NOT NULL PRIMARY KEY,
Bldg_Name VARCHAR (20),
Location VARCHAR (20),
Room_Count INTEGER );
CREATE TABLE RESIDENT ( R_ID NOT NULL PRIMARY KEY,
Room_Num INTEGER,
Res_Name VARCHAR (20),
Building_ID INTEGER NOT NULL,
FOREIGN KEY Building_ID REFERENCES BUILDING (Building_ID) ON DELETE NO CHECK
ON UPDATE CASCADE);
C CREATE TABLE BUILDING ( Building_ID INTEGER NOT NULL PRIMARY KEY,
Bldg_Name VARCHAR (20),
Location VARCHAR (20),
Room_Count INTEGER );
CREATE TABLE RESIDENT ( R_ID NOT NULL PRIMARY KEY,
Room_Num INTEGER,
Res_Name VARCHAR (20),
Building_ID INTEGER NOT NULL,
FOREIGN KEY Building_ID REFERENCES BUILDING (Building_ID) ON DELETE NO CHECK
ON UPDATE CASCADE);
D CREATE TABLE BUILDING ( Building_ID INTEGER NOT NULL PRIMARY KEY,
Bldg_Name VARCHAR (20),
Location VARCHAR (20),
Room_Count INTEGER );
CREATE TABLE RESIDENT ( R_ID NOT NULL PRIMARY KEY,
Room_Num INTEGER,
Res_Name VARCHAR (20),
Building_ID INTEGER NOT NULL,
FOREIGN KEY Building_ID REFERENCES BUILDING (Building_ID) ON DELETE NO CHECK
ON UPDATE CASCADE);
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

5
Question
A large enterprise uses a two-tier database architecture and runs complex database processing on the client. Which term best describes the client in this system?
Options
A Fat client
B Enterprise client
C Terminal client
D Thin client
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

Finish Practice?

Are you sure you want to finish? This will end your practice session.