Q. A command to remove a relation from an SQL database

View solution

Q. Which SQL Query is use to remove a table and all its data from the database?

View solution

Q. A type of query that is placed within a WHERE or HAVING clause of another query is called

View solution

Q. Aggregate functions are functions that take a ___________ as input and return a single value.

View solution

Q. Select __________ from instructor where dept name= ’Comp. Sci.’;
Which of the following should be used to find the mean of the salary ?

View solution

Q. All aggregate functions except _____ ignore null values in their input collection.

View solution

Q. A Boolean data type that can take values true, false, and________ .

View solution

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