CIW v5 Database Design Specialist - 1D0-541 FREE EXAM DUMPS QUESTIONS & ANSWERS]

Question 1

Consider the Recreation relation shown in the exhibit. You need to apply a SQL statement to the
Recreation relation that will return the following data:
Which SQL statement applied to the Recreation relation will return this data?

A. SELECT Activity FROM Recreation WHERE NOT LIKE Activity; B. SELECT Activity FROM Recreation WHERE DISTINCT Activity; C. SELECT Activity FROM Recreation; D. SELECT DISTINCT Activity FROM Recreation;

Discussion 0

Correct Answer: D Vote an answer

Question 2

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

A. 6 B. 20 C. 25 D. 4

Discussion 0

Correct Answer: D Vote an answer

Question 3

Which three pieces of information did E.F. Codd describe as necessary to retrieve a data value from a relational database?

A. Entity, relation name, and domain B. Attribute, relation name, and primary key C. Table name, primary key, and entity D. Attribute, domain, andtuple

Discussion 0

Correct Answer: B Vote an answer

Question 4

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. A set of normalized relations B. A reviewed entity-relationship (ER) model C. An entity-relationship (ER) model with no redundant data D. A set ofdenormalized relations

Discussion 0

Correct Answer: B Vote an answer

Question 5

The exhibit shows a table called Recreation Relation that relates a unique student identification number and a sports activity with a fee for participating in that activity. The Student_ID and Activity columns in the table are used together as a composite key. Which statement about the relation is correct?

A. The table contains a transitive dependency. B. Activity_Fee is a determinant of Activity and Student_I C. Activity_Fee is partially dependent on the key. D. Activity_Fee is a determinant of Activity.

Discussion 0

Correct Answer: C Vote an answer

Question 6

Which database security technique prevents invalid data from being entered into the database?

A. User authorization B. File locking C. Parity checks D. Integrity controls

Discussion 0

Correct Answer: D Vote an answer

Question 7

With regard to databases, what is normalization?

A. The process of reducing the cardinality of a relation B. The process of duplicating data to reduce the number of tables C. The process of limiting data stored in a table to a specific range of values D. The process of organizing and refining relations

Discussion 0

Correct Answer: D Vote an answer

Question 8

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

A. First normal form B. STUDENT( Student_Number: integer NOT NULL Name: variable length character string length 20 NOT NULL) Primary Key Student_Number CLASS( Class_Num: integer NOT NULL Class_Name: integer NOT NULL) Primary Key Class_Num C. Second normal form D. STUDENT( Student_Number: integer NOT NULL Name: variable length character string length 20 NOT NULL) Primary Key StudenMMumber STU_CLASS( Student_Number: integer NOT NULL Class_Num: integer NOT NULL) Primary Key Student_Number CLASS( Class_Num: integer NOT NULL Class_Name: integer NOT NULL) Primary Key Class_Num E. Third normal form F. Boyce-Codd normal form G. STUDENT( Student_Number: integer NOT NULL Name: variable length character string length 20 NOT NULL) Primary Key Student_Number CLASS( Class_Num: integer NOT NULL Class_Name: integer NOT NULL) Primary Key Class_Num Foreign Key Class_Num References STUDENT

Discussion 0

Correct Answer: E Vote an answer

Question 9

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

A. First normal form B. Second normal form C. Third normal form D. Boyce-Codd normal form

Discussion 0

Correct Answer: B Vote an answer

Question 10

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 MINUS (SELECT Part_ID FROM Dept2_Parts); B. SELECT * FROM Dept1_Parts DIFFERENCE (SELECT Part_ID FROM Dept2_Parts); C. SELECT * FROM Dept1_Parts EXCEPT(SELECT PartJD FROM Dept2_Parts); D. SELECT * FROM Dept1_Parts WHERE Part_ID NOT IN (SELECT Part_ID FROM Dept2_Parts);

Discussion 0

Correct Answer: D Vote an answer