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
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!

3
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!

4
Question
Consider the relation shown in the exhibit. Which of the following SQL statements would properly add information for a new employee?

Exhibit
Options
A INSERT INTO Employee(Emp_ID, First_Name, Last_Name, Birth_Date)
VALUES(0004, Tim, Bogart, 03-15-77);
B INSERT INTO Employee(Emp_ID, First_Name, Last_Name, Birth_Date)
VALUES(0005, Tim, Bogart, 03-05-77);
C INSERT INTO Employee(Emp_ID, First_Name, Last_Name, Birth_Date)
VALUES(0005, Tim, Bogart, 03-05-77);
D INSERT INTO Employee
VALUES(0005, Tim, Bogart, 03-15-77);
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

5
Question
Consider the Employee relation shown in the exhibit. A database manager wants to set up a view called Emp_Dept that allows users to find employees and their department ID numbers. Which SQL statement will accomplish this?

Exhibit
Options
A CREATE VIEW Emp_Dept AS SELECT Last_Name, First_Name, Dept_ID
FROM Employee;
B CREATE VIEW Emp_Dept AS SELECT *
FROM Employee
WHERE ID = 0001
AND ID = 0002
AND ID = 0003
AND ID = 0004;
C UPDATE VIEW Emp_Dept
AS SELECT Last_Name, First_Name, Dept_ID
FROM Employee;
D UPDATE VIEW Emp_Dept
AS SELECT *
FROM Employee;
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.