Data Base Management System
Description: Data Base Management System | |
Number of Questions: 15 | |
Created by: Girish Devgan | |
Tags: Data Base Management System Database |
Which of the following 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?
Which of the following operations selects only some of the tuples in DBMS?
Which operation is used for removing common tuples from the first relation in DBMS?
Which of the following predicates 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?
By which predicate can one access the value in a given interval in DBMS?
Which predicate is used for pattern matching and to compare a string constant with a column of type character in DBMS?
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?
Which of the following quantified predicates is used for existential quantifier in DBMS?
Which of the following operations removes common tuples from the first relation in DBMS?
Which of the following selects the common tuples from two relations in DBMS?
Which of the following is used to reference to a table through the primary key of the related table in DBMS?
Which of the following constraints specifies that within each tuple, the value of each attribute must be an atomic value in advance DBMS?
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?