CIW 1D0-541 Actual Free Exam Questions & Community Discussion

Exam Code/Number: 1D0-541
Exam Name/Title: CIW v5 Database Design Specialist
Certification Provider: CIW
Corresponding Certification: CIW Other Certification

Exam Questions: 124
Updated On: Jun 02, 2026

Question #21

You enterprise must decide whether to use a database management system. Which of the following lists four advantages of using a DBMS?

A. Consistency of data, adherence to standards, managed concurrency, and increased software complexity.

B. Management of data redundancy, increased data integrity, increased data dependence, and increased application program flexibility.

C. Increased datasecriry, increased data integrity, increased data independence, and decreased data separation.

D. Increased data access, increased data backup and recovery, data sharing, and consistency of data.

Discussion 0

Correct Answer: D Vote an answer

Question #22

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

A. 5

B. 4

C. 25

D. 20

Discussion 0

Correct Answer: A Vote an answer

Question #23

What is a relational database domain?

A. A set of permissibletuple values

B. A group of attributes

C. A collection of related data items

D. A set of permissible attribute values

Discussion 0

Correct Answer: D Vote an answer

Question #24

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?

A. Someone 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.

B. A 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 thesoftwares underlying code.

C. A user who has no knowledge of thesoftwares underlying code tests the software.

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

Discussion 0

Correct Answer: B Vote an answer

Question #25

What is the highest normal form of the relation(s) shown in the exhibit?

A. Second normal form

B. No normal form

C. First normal form

D. Third normal form

Discussion 0

Correct Answer: D Vote an answer

Question #26

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?

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 BUILDING (Building_ID)
ON DELETE NO CHECK
ON UPDATE CASCADE);

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 RESIDENT (Building_ID)
ON DELETE NO CHECK);

Discussion 0

Correct Answer: A Vote an answer

Question #27

What is a data dictionary?

A. Metadata that is stored in tables and is only accessible by the DBMS

B. Data that is stored in tables and is only accessible by the DBMS

C. An area of the database that is directly accessible by the user

D. A system catalog containing user data

Discussion 0

Correct Answer: A Vote an answer

Question #28

Which term describes the management of simultaneous transactions to prevent conflicts?

A. Serialization

B. Parallelism

C. Database control

D. Concurrency control

Discussion 0

Correct Answer: D Vote an answer

Question #29

What is the most important service provided by a database management system?

A. Allows users to store data in a distributed data repository

B. Provides support for data formatting language commands

C. Provides support for a data manipulation language

D. Translates procedural commands into non-procedural commands

Discussion 0

Correct Answer: C Vote an answer

Question #30

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

A. Data that is stored as tables

B. Data that is stored in a structured manner

C. Data recordsthat are stored sequentially in a file

D. Software that manipulates data

Discussion 0

Correct Answer: B Vote an answer

Download Free CIW 1D0-541 Demo

Simply submit your e-mail address below to get started with our free demo of your CIW 1D0-541 exam.