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: Sep 27, 2026

Question #41

Which subset of Structured Query Language (SQL) is used to limit access to a database or its data?

A. Data Manipulation Language

B. Data Formatting Language

C. Data Markup Language

D. Data Control Language

Discussion 0

Correct Answer: D Vote an answer

Question #42

Which type of dependency occurs when one attribute of a composite key is removed and the dependency still exists?

A. 1:1

B. Functional

C. Transitive

D. Partial functional

Discussion 0

Correct Answer: D Vote an answer

Question #43

Which statement is used to define a named group of related tables, views, domains and other database objects?

A. CREATE DOMAIN

B. CREATE SCHEMA

C. CREATE

D. CREATE TABLE

Discussion 0

Correct Answer: B Vote an answer

Question #44

Consider the Information Engineering diagram in the exhibit showing a conceptual data model of the relations BUILDING and RESIDENT. What is the next step in refining the data model?

A. Identify and resolve complex relationships.

B. Create intermediate entities.

C. Resolve many-to-many relationships.

D. Create a logical data model.

Discussion 0

Correct Answer: D Vote an answer

Question #45

Which type of entity must reference another entity for its data to be meaningful?

A. Foreign

B. Primary

C. Strong

D. Weak

Discussion 0

Correct Answer: D Vote an answer

Question #46

With regard to databases, what is normalization?

A. The process of duplicating data to reduce the number of tables

B. The process of organizing and refining relations

C. The process of reducing the cardinality of a relation

D. The process of limiting data stored in a table to a specific range of values

Discussion 0

Correct Answer: B Vote an answer

Question #47

Consider the Information Engineering diagram shown in the exhibit. Building_ID, R_ID, Room_Count and Room_Num are integer numbers, whereas Bldg_Name and Res_Name are represented by variable-length strings with a maximum of 20 characters. Location can be up to 50 characters long, and no building has more than 600 rooms. Which SQL statement best implements the BUILDING relation shown in this diagram?

A. CREATETABLE BUILDING (
Building_ID NOT NULL PRIMARY KEY, Bldg_Name, Location, Room_Count);

B. CREATETABLE BUILDING ( Building_ID NOT NULL PRIMARY KEY, Bldg_Name, Location, Room_Count, FOREIGN KEY Building_ID REFERENCES BUILDING (Building_ID));

C. CREATETABLE BUILDING (Building_ID INTEGER NOT NULL PRIMARY KEY, Bldg_Name VARCHAR (20), Location VARCHAR (50),

D. CREATETABLE BUILDING (Building_ID INTEGER NOT NULL PRIMARY KEY, Bldg_Name VARCHAR (20), Location VARCHAR (50),
Room_Count INTEGER CHECK (Room_Count >
Room_Count INTEGER CHECK (
-1 And Room_Count < 601));
Room_Count > -1 Or Room_Count < 601));

Discussion 0

Correct Answer: D Vote an answer

Question #48

Your company must choose which type of database to use for a new project. Which of the following lists three characteristics of file-based database systems?

A. Separation of data, repetition of data, and data independence

B. Incompatibility of files, tabular data structures, and data dependence

C. Application program inflexibility, data dependence, and separation of data

D. Repetition of data, application program flexibility, and data centralization

Discussion 0

Correct Answer: C Vote an answer

Question #49

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?

A. SELECT * FROM Dept1_Parts EXCEPT(SELECT PartJD FROM Dept2_Parts);

B. SELECT * FROM Dept1_Parts WHERE Part_ID NOT IN (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

Correct Answer: B Vote an answer

Question #50

What is a virtual table?

A. A virtual table is a relation derived from the database data dictionary; it contains metadata about a base relation. A virtual table is a relation derived from the database?data dictionary; it contains metadata about a base relation.

B. A virtual table is a relation that consists of primary and foreign keys for a particular set of relations in a database.

C. A virtual table is a relation stored in the database; it is used when multiple users access the same relation in a database.

D. A virtual table is a relation created as the result of data manipulation; it exists only in computer memory, and is not a permanent part of the database.

Discussion 0

Correct Answer: D 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.