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

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

View solution