[2026] CIW v5 Database Design Specialist - 1D0-541 무료 시험 문제

문제1

The exhibit shows a table called Housing Relation that relates a unique student identification number with a dormitory building and a room fee for that building. Each building charges only one fee and a student can live in only one building. The key for the Housing Relation is Student_ID.
This table is in which normal form?

A. 1NF, 2NF and 3NF

B. 1NF and 2NF

C. 1NF, 2NF, 3NF and BCNF

D. 1NF

정답: B

문제2

Consider the Registration relation shown in the exhibit. Which of the following SQL statements would return all tuples that have course codes beginning with the letter M?

A. SELECT * FROM Registration WHERE Course_Code = #

B. SELECT * FROM Registration WHERE Course_Code LIKE _

C. SELECT * FROM Registration WHERE Course Code = %

D. SELECT* FROM Registration WHERE Course_Code LIKE %

정답: D

문제3

A large enterprise uses a two-tier database architecture and runs complex database applications. Which term best describes the client in this system?

A. Terminal client

B. Fat client

C. Enterprise client

D. Thin client

정답: B

문제4

A foreign key maps to a:

A. prime key.

B. parent key.

C. indirect key.

D. composite key.

정답: B

문제5

Consider the relations shown in the exhibit. Due to restructuring, the sales department has been eliminated and the employees working in that department have been dismissed. All ID information is stored as integers. Which SQL statement would be used to return a relation with all information for the employees who have been dismissed?

A. SELECT *
FROM Employee;

B. SELECT *
FROM Employee
WHERE Dept_ID = 022;

C. SELECT ID,Last_Name
FROM Employee;
WHERE ID = 0004;

D. SELECT *
FROM Employee
WHERE Dept_ID = 022;

정답: D

문제6

What is a relational database domain?

A. A set of permissibletuple values

B. A set of permissible attribute values

C. A collection of related data items

D. A group of attributes

정답: B

CIW v5 Database Design Specialist - 1D0-541무료 덤프문제 풀어보기

우리와 연락하기

유용한 링크

최신 업데이트