Q. The ______ clause allows us to select only those rows in the result relation of the ____ clause that satisfy a specified predicate.

View solution

Q. Select ID, name, dept name, salary * 1.1
where instructor;

The query given below will not give an error. Which one of the following has to be replaced to get the desired output?

View solution

Q. The ________ clause is used to list the attributes desired in the result of a query.

View solution

Q. Select name, course_id
from instructor, teaches

where instructor_ID= teaches_ID;

This Query can be replaced by which one of the following ?

View solution

Q. Select * from employee where salary>10000 and dept_id=101;
Which of the following fields are displayed as output?

View solution

Q. Which of the following statements contains an error?

View solution

Q. Insert into employee _____ (1002,Joey,2000);
In the given query which of the keyword has to be inserted ?

View solution

Q. SELECT * FROM employee WHERE dept_name="Comp Sci";

In the SQL given above there is an error . Identify the error .

View solution

Q. ’_ _ _ ’ matches any string of ______ three characters. ’_ _ _ %’ matches any string of at ______ three characters.

View solution

Q. In SQL the spaces at the end of the string are removed by _______ function .

View solution

Q. _____ operator is used for appending two strings.

View solution

Q. The union operation is represented by

View solution

Q. The intersection operator is used to get the _____ tuples.

View solution

Q. The union operation automatically __________, unlike the select clause.

View solution

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