0

Data Base Management System

Description: Data Base Management System
Number of Questions: 15
Created by:
Tags: Data Base Management System Database
Attempted 0/15 Correct 0 Score 0

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

  1. COUNT

  2. GROUP BY

  3. SUM

  4. ORDER BY

  5. MAX


Correct Option: B
Explanation:

GROUP-BY clause divides the result into a number of clusters.

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


Correct Option: A
Explanation:

This operator permits the combining of two relations to form a single relation and the processing of relationships existing between the operand relations.

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

  1. JOIN

  2. Projection

  3. Selection

  4. Difference

  5. Intersection


Correct Option: C
Explanation:

This is an operation that selects only some of the tuples in the relation.

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

  1. Intersection

  2. Difference

  3. Projection

  4. Selection

  5. JOIN


Correct Option: B
Explanation:

The difference operation is used for removing common tuples from first relation.

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


Correct Option: D
Explanation:

IN predicate is used to test an attribute value against a set of values.

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


Correct Option: E
Explanation:

This is used to arrange the result of a query in either ascending (ASC) or descending order (DESC).

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


Correct Option: A
Explanation:

BETWEEN predicate is used to specify the range in which the value must lie.

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


Correct Option: B
Explanation:

Pattern matching can be done using LIKE predicate. In pattern matching, string constant is compared with a column of type character.

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


Correct Option: C
Explanation:

The cartesian product of two relations is simply the concatenation of tuples belonging to the two relations and consisting of all the possible combinations of the tuples.

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

  1. ALL

  2. ANY

  3. LIKE

  4. IN

  5. BETWEEN


Correct Option: B
Explanation:

ANY stands for existential quantifier.

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


Correct Option: A
Explanation:

It removes common tuples from first relation.

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

  1. Count

  2. Union

  3. Intersection

  4. Projection

  5. Selection


Correct Option: C
Explanation:

This operation selects the common tuples from two relations.

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


Correct Option: C
Explanation:

Reference to a table through the primary key of that related table is achieved using foreign key.

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


Correct Option: A
Explanation:

Domain constraints specifies that within each tuple, the value of each attribute must be an atomic value.

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


Correct Option: A
Explanation:

Projection yields a vertical subset of the relation, either to reduce the number of attributes in a resultant relation or to reorder attributes.

- Hide questions