Home › Quizzes › Database Management System

Database Management System

Covers SQL operations, relational algebra concepts, and database constraints including GROUP BY, JOIN, Selection, Projection, SQL predicates (IN, LIKE, BETWEEN), and key constraints

15 Questions Published
Play Quiz Practise this topic out loud

Questions

Question 1 Multiple Choice (Single Answer)

Which of the following divides the result into a number of clusters?

  1. COUNT
  2. GROUP BY
  3. SUM
  4. ORDER BY
  5. MAX
Question 2 Multiple Choice (Single Answer)

Which of the following permits the combining of two relations to form a single relation and the processing of relationships existing between the operand relations in DBMS?

  1. JOIN
  2. Union
  3. Difference
  4. Intersection
  5. Cartesian product
Question 3 Multiple Choice (Single Answer)

Which of the following operations selects only some of the tuples in DBMS?

  1. JOIN
  2. Projection
  3. Selection
  4. Difference
  5. Intersection
Question 4 Multiple Choice (Single Answer)

Which operation is used for removing common tuples from the first relation in DBMS?

  1. Intersection
  2. Difference
  3. Projection
  4. Selection
  5. JOIN
Question 5 Multiple Choice (Single Answer)

Which of the following predicates is used to test an attribute value against a set of values?

  1. LIKE predicate
  2. BETWEEN predicate
  3. AVG
  4. IN predicate
  5. MIN
Question 6 Multiple Choice (Single Answer)

Which of the following can arrange the result of a query in either ascending order (ASC) or descending order (DESC) in DBMS?

  1. GROUP BY
  2. COUNT
  3. SUM
  4. AVG
  5. ORDER BY
Question 7 Multiple Choice (Single Answer)

By which predicate can one access the value in a given interval in DBMS?

  1. BETWEEN predicate
  2. LIKE predicate
  3. IN predicate
  4. COUNT
  5. SUM
Question 8 Multiple Choice (Single Answer)

Which predicate is used for pattern matching and to compare a string constant with a column of type character in DBMS?

  1. IN predicate
  2. LIKE predicate
  3. GROUP-BY
  4. COUNT
  5. SUM
Question 9 Multiple Choice (Single Answer)

Which of the following is used for the simply concatenation of tuples belonging to the two tuples and consisting of all the possible combination of the tuples?

  1. Selection
  2. JOIN
  3. Cartesian product
  4. Projection
  5. Difference
Question 10 Multiple Choice (Single Answer)

Which of the following quantified predicates is used for existential quantifier in DBMS?

  1. ALL
  2. ANY
  3. LIKE
  4. IN
  5. BETWEEN
Question 11 Multiple Choice (Single Answer)

Which of the following operations removes common tuples from the first relation in DBMS?

  1. Difference or minus
  2. Sum
  3. Cartesian product
  4. Projection
  5. Selection
Question 12 Multiple Choice (Single Answer)

Which of the following selects the common tuples from two relations in DBMS?

  1. Count
  2. Union
  3. Intersection
  4. Projection
  5. Selection
Question 13 Multiple Choice (Single Answer)

Which of the following is used to reference to a table through the primary key of the related table in DBMS?

  1. Attribute
  2. Candidate key
  3. Foreign key
  4. Primary key
  5. Entity
Question 14 Multiple Choice (Single Answer)

Which of the following constraints specifies that within each tuple, the value of each attribute must be an atomic value in advance DBMS?

  1. Domain constraint
  2. Super key
  3. Candidate key
  4. Primary key
  5. Attribute
Question 15 Multiple Choice (Single Answer)

Which of the following yields a vertical subset of the relation, either to reduce the number of attributes in a resultant relation or to reorder attributes in DBMS?

  1. Projection
  2. Selection
  3. JOIN
  4. Difference
  5. Intersection
← Back to Quizzes