Q. Select count (____ ID)
from teaches
where semester = ’Spring’ and year = 2010;
If we do want to eliminate duplicates, we use the keyword ______in the aggregate expression.

View solution

Q. The ____ connective tests for set membership, where the set is a collection of values produced by a select clause. The ____ connective tests for the absence of set membership.

View solution

Q. We can test for the nonexistence of tuples in a subquery by using the _____ construct.

View solution

Q. Dates must be specified in the format

View solution

Q. An ________ on an attribute of a relation is a data structure that allows the database system to find those tuples in the relation that have a specified value for that attribute efficiently, without scanning through all the tuples of the relation.

View solution

Q. Which of the following is used to store movie and image files ?

View solution

Q. The user defined data type can be created using

View solution

Q. Values of one type can be converted to another domain using which of the following ?

View solution

Q. Which of the following closely resembles Create view ?

View solution

Q. In contemporary databases the top level of the hierarchy consists of ______, each of which can contain _____.

View solution

Q. Which of the following statements creates a new table temp instructor that has the same schema as instructor.

View solution

Q. The____condition allows a general predicate over the relations being joined.

View solution

Q. Which of the join operations do not preserve non matched tuples.

View solution

Q. What type of join is needed when you wish to include rows that do not have matching values?

View solution

Q. How many join types in join condition:

View solution

Q. Which join refers to join records from the right table that have no matching key in the left table are include in the result set:

View solution

Q. In SQL the statement select * from R, S is equivalent to

View solution

Q. Which join condition contains an equality operator:

View solution

Q. A __________ is a special kind of a store procedure that executes in response to certain action on the table like insertion, deletion or updation of data.

View solution

Q. The CREATE TRIGGER statement is used to create the trigger. THE _____ clause specifies the table name on which the trigger is to be attached. The ______ specifies that this is an AFTER INSERT trigger.

View solution