1D0-541

1D0-541 practice questions, page 4 of 5, with answer review and explanations.

Question 16

Which pair of relational algebraic operations requires union compatibility?

  1. Union and join
  2. Selection and projection
  3. Intersection and difference
  4. Cartesian product and intersection

Question 17

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. Option A
  2. Option B
  3. Option C
  4. Option D

Question 18

What is the most important service provided by a database management system?

  1. Provides support for a data manipulation language
  2. Allows users to store data in a distributed data repository
  3. Provides support for data formatting language commands
  4. Translates procedural commands into non-procedural commands

Question 19

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

  1. 6
  2. 20
  3. 4
  4. 25

Question 20

What is a relational database domain?

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