Q. The type of JOIN operation through which one can keep all tuples in relations without considering corresponding tuples in any other relation is classified as

View solution

Q. The process in which tuple is created by having combined attributes from two relations is classified as

View solution

Q. Consider two tuples B and C, the operation whose result includes tuples that are included in both relations or either in B or C is classified as

View solution

Q. In relational operations, the SELECT operation is written as

View solution

Q. The nodes which represents queries in the relations are classified as

View solution

Q. In unary relational operations, the symbol π is used to represent the operation called

View solution

Q. The relational calculus is classified as

View solution

Q. The kind of operation which is used to extend the traditional projection operation by including projection attributes in projection list is called

View solution

Q. The expression of generalized projection can be written as

View solution

Q. The expression which specifies the procedure to retrieve rather than retrieval content is classified as

View solution

Q. In a query tree, the input relations of query are classified as

View solution

Q. With the help of selection condition, the fraction of selected tuples is classified as

View solution

Q. The most convenient operation which is used for the queries having universal quantification is classified as

View solution

Q. Find the ID, name, dept name, salary for instructors whose salary is greater than $80,000 .

View solution

Q. A query in the tuple relational calculus is expressed as:

View solution

Q. Which of the following symbol is used in the place of except ?

View solution

Q. “Find all students who have taken all courses offered in the Biology department.” The expressions that matches this sentence is :

View solution

Q. Which of the following is the comparison operator in tuple relational calculus

View solution

Q. An expression in the domain relational calculus is of the form

View solution

Q. Find the names of all instructors in the Physics department together with the course id of all courses they teach:

View solution