1D0-541 by CIW Actual Free Exam Questions And Answers

CIW v5 Database Design Specialist - 1D0-541 Exam Practice Test

Question 1

Which statement accurately describes a characteristic of attributes?

A. An attribute name can be used only once in a relational database system with multiple tables.

B. The ordering of attributes in a table is significant.

C. An attribute contains values from multiple domains.

D. An attribute name can be used only once per table.

Discussion 0

Correct Answer: D Vote an answer

Question 2

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

A. 4

B. 25

C. 5

D. 20

Discussion 0

Correct Answer: C Vote an answer

Question 3

Your enterprise has reached the conceptual design phase for a database project. What is the desired goal at the end of this design phase?

A. An entity-relationship (ER) model with no redundant data

B. A set of normalized relations

C. A set ofdenormalized relations

D. A reviewed entity-relationship (ER) model

Discussion 0

Correct Answer: D Vote an answer

Question 4

Which statement best describes a procedural data manipulation language command?

A. The user is not required to know how the underlying data structures are implemented.

B. It can be used only to manipulate data through a SQL interface.

C. It contains a query language for retrieving data.

D. It requires that the user know how the underlying data structures are implemented.

Discussion 0

Correct Answer: D Vote an answer

Question 5

Consider the following DBDL description of an entity: Teachers (teach_num: variable length character string length 10 NOT NULL teach_name: variable length character string length 10 NOT NULL) Primary Key: teach_num which integrity constraint is satisfied?

A. Referential integrity

B. Entity integrity

C. Necessary data

D. Referential foreign integrity

Discussion 0

Correct Answer: B Vote an answer

Question 6

Which relational algebraic operation is used to select specific columns (attributes) from a relation?

A. Projection

B. Union

C. Intersection

D. Difference

Discussion 0

Correct Answer: A Vote an answer

If you have any question please leave me your email address, we will reply and send email to you in 12 hours.

Our Working Time: ( GMT 0:00-15:00 ) From Monday to Saturday

Support:

Contact now

CIW v5 Database Design Specialist - 1D0-541 Exam Practice Test

Contact Us

Useful Links

Latest Updated