Q. If we want to retain all duplicates, we must write ________ in place of union.

View solution

Q. For like predicate which of the following is true.

i) % matches zero OF more characters.
ii) _ matches exactly one CHARACTER.

View solution

Q. The number of attributes in relation is called as its

View solution

Q. _____ clause is an additional filter that is applied to the result.

View solution

Q. _________ joins are SQL server default

View solution

Q. The _____________ is essentially used to search for patterns in target string.

View solution

Q. A _____ indicates an absent value that may exist but be unknown or that may not exist at all.

View solution

Q. If the attribute phone number is included in the relation all the values need not be entered into the phone number column . This type of entry is given as

View solution

Q. The predicate in a where clause can involve Boolean operations such as and.The result of true and unknown is_______ false and unknown is _____ while unknown and unknown is _____

View solution

Q. In a employee table to include the attributes whose value always have some value which of the following constraint must be used ?

View solution

Q. Using the ______ clause retains only one copy of such identical tuples.

View solution

Q. You attempt to query the database with this command:

SELECT nvl (100 / quantity, NONE)
FROM inventory;

Why does this statement cause an error when QUANTITY values are null?

View solution

Q. The result of _____unknown is unknown.

View solution

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

View solution

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

View solution

Q. Which of the following should be used to find all the courses taught in the Fall 2009 semester but not in the Spring 2010 semester .

View solution

Q. The phrase “greater than at least one” is represented in SQL by _____

View solution

Q. Which of the following is used to find all courses taught in both the Fall 2009 semester and in the Spring 2010 semester .

View solution

Q. SQL applies predicates in the _______ clause after groups have been formed, so aggregate functions may be used.

View solution

Q. Aggregate functions can be used in the select list or the_______clause of a select statement or subquery. They cannot be used in a ______ clause.

View solution