Free 1D0-541 Exam Dumps

Question 31

Which security technique limits access by unauthorized users to parts of an enterprise database?

A. Views
B. Concurrency
C. Locking
D. Integrity controls

Correct Answer:A

Question 32

Consider the symbols shown in the exhibit. Which of the following correctly identifies these symbols when used in an entity-relationship (ER) diagram?
1D0-541 dumps exhibit

A. 1 = attribute, 2 = entity, 3 = relationship
B. 1 = entity, 2 = relationship, 3 = attribute
C. 1 = relationship, 2 = entity, 3 = attribute
D. 1 = relationship, 2 = attribute, 3 = entity

Correct Answer:C

Question 33

Which type of relational integrity is violated if a primary key in a database has a null value?

A. Entity integrity
B. Domain integrity
C. Domain constraints
D. Referential integrity

Correct Answer:A

Question 34

Which of the following best describes a composite key?

A. A composite key is a primary key and foreign key that consists of the first two attributes of a relation.
B. A composite key is a primary or foreign key defined by its parent key attributes.
C. A composite key is a foreign key that consists of the same attributes as the primary key from a related table.
D. A composite key is a primary or foreign key that consists of two or more attributes of a relation.

Correct Answer:D

Question 35

Consider the entity-relationship (ER) diagram shown in the exhibit. Which type of relationship between the two entities is shown?
1D0-541 dumps exhibit

A. m:m
B. m:n
C. 1:1
D. 1:n

Correct Answer:B