1D0-541 Free Practice Test

Which process is used to prevent the current database operation from reading or writing a data item while that data item is being accessed by another operation?

1. A. Lock
2. B. Deadlock
3. C. Timestamp
4. D. Batch

Correct Answer: A

What is a relational database domain?

1. A. A group of attributes
2. B. A set of permissible tuple values
3. C. A collection of related data items
4. D. A set of permissible attribute values

Correct Answer: D

Which term best defines a database system in which data records are stored with no structured relationships between the records?

1. A. Flat-file database
2. B. Relational database
3. C. Distributed database
4. D. Object-oriented database

Correct Answer: A

Consider the following table as well as the Dept1_Parts and Dept2_Parts relations shown in the exhibit:

Which of the following relational algebraic expressions would result in the given table?

1. A.
2. B.
3. C.
4. D.

Correct Answer: A

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

1. A. m:m
2. B. m:n
3. C. 1:1
4. D. 1:n

Correct Answer: B