A
which of the following displays the unique values of the column?
SELECT ________ dept_name FROM instructor;
Distinct
SELECT emp_name
FROM department
WHERE dept_name LIKE ’ _____ Computer Science’;
Which one of the following has to be added into the blank to select the dept_name which has Computer Science as its ending string?
%
Aggregate functions are functions that take a ___________ as input and return a single value.
Collection of values
The____condition allows a general predicate over the relations being joined.
on
The ________ clause is used to list the attributes desired in the result of a query.
select
SELECT name
FROM instructor
WHERE dept name = ’Physics’
ORDER BY name;
By default, the order by clause lists items in ______ order.
Ascending
SELECT __________
FROM instructor
WHERE dept name= ’Comp. Sci.’;
Which of the following should be used to find the mean of the salary ?
Avg(salary)
Which of the join operations do not preserve non matched tuples?
Inner join
In the given query which of the keyword has to be inserted?
INSERT INTO employee _____ (1002,Joey,2000);
values
SELECT *
FROM instructor
ORDER BY salary ____, name ___;
To display the salary from greater to smaller and name in ascending order which of the following options should be used?
Desc, Asc
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.
Distinct
What type of join is needed when you wish to include rows that do not have matching values?
Outer join
SELECT name ____ instructor name, course id
FROM instructor, teaches
WHERE instructor.ID= teaches.ID;
Which keyword must be used here to rename the field name?
as
In SQL the spaces at the end of the string are removed by _______ function
Trim
All aggregate functions except _____ ignore null values in their input collection.
Count(*)
How many tables may be included with a join?
multiple
SELECT * FROM employee WHERE dept_name="Comp Sci";
In the SQL given above there is an error . Identify the error.
“Comp Sci”
_____ operator is used for appending two strings.
||
The phrase “greater than at least one” is represented in SQL by _____
> some
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:
right outer join