Ciw Database Design Specialist 1D0 541 Practice Test 50 Questions

CIW DATABASE DESIGN

SPECIALIST 1D0-541

PRACTICE TEST 50

QUESTIONS

Question 1: A company is replacing separate departmental spreadsheets with a

centralized DBMS. Which bene�t is most directly gained by the change?

Choices:

1) Elimination of all data validation rules 2) Improved data sharing and consistency across users 3) Removal of the need for backups 4) Guaranteed zero downtime

Correct Answer: Improved data sharing and consistency across users

Explanation: A DBMS can centralize data management so multiple users and applications share controlled data de�nitions and integrity rules. This improves consistency and reduces con�icting copies; it does not eliminate validation, backups, or downtime risk.Page 1

Question 2: A relation contains 12 columns and currently stores 8,000 rows. Which statement correctly describes its degree and cardinality?

Choices:

1) Degree 8,000 and cardinality 12 2) Degree 12 and cardinality 8,000 3) Both degree and cardinality are 12 4) Both degree and cardinality are 8,000

Correct Answer: Degree 12 and cardinality 8,000

Explanation: In the relational model, degree is the number of attributes or columns and cardinality is the number of tuples or rows. Therefore the degree is 12 and the cardinality is

8,000.

Question 3: Which design rule is violated if a row in a table is allowed to have NULL in its primary key column?

Choices:

1) Domain integrity 2) Entity integrity 3) Referential integrity 4) Transaction isolation

Correct Answer: Entity integrity

Explanation: Entity integrity requires each row to be uniquely identi�able, so a primary key must be unique and cannot be NULL.Page 2

Question 4: An Orders table contains CustomerID as a foreign key referencing

Customers.CustomerID. Which action would violate referential integrity if no cascading or null-setting rule exists?

Choices:

1) Adding a new customer with a unique CustomerID 2) Deleting a customer that is still referenced by an order 3) Updating an order's non-key Notes column 4) Creating an index on Orders.CustomerID

Correct Answer: Deleting a customer that is still referenced by an order

Explanation: Referential integrity requires every non-NULL foreign-key value to match an existing candidate or primary key in the parent table. Deleting a referenced parent row would leave an orphaned foreign key unless an appropriate referential action is de�ned.

Question 5: Which description best de�nes a composite key?

Choices:

1) A key generated automatically by the DBMS 2) A key made from two or more attributes whose combined values identify a row 3) A foreign key that must always contain NULL 4) A key used only in temporary tables Correct Answer: A key made from two or more attributes whose combined values identify a row Explanation: A composite key consists of multiple attributes used together to uniquely identify a tuple. No single component is necessarily su�cient by itself.Page 3