Font size
WorksheetsSQL Quiz 2
Total questions: 10
Worksheet time: 20mins
What does the Q in SQL stand for?
Query
Question
Quizzical
Quantify
The join operation which includes everything from each table is
FULL OUTER
COMPLETE TOTAL
ABSOLUTE 100%
FULL INNER
What is the difference between WHERE and HAVING?
HAVING only applies to aggregate functions like GROUP BY
There are interchangeable
WHERE specifies a GEOGRAPHIC location for a database server
WHERE has limited use
Why make views?
It is faster, safer and better practice to not allow general access to the production database
You should not, they are slow
You should not, they are inefficient
"View" is simply a synonym for the return of the SELECT function
Which operator selects values WITHIN a range?
BETWEEN
INSIDE
< AND >
> AND <
CREATE allows us to make
Tables
Databases
Views
Indexes
How do we comment in SQL?
--....
#.....
/**....**/
//.....
What does the MINUS operator do?
Subtracts one number from another
Returns rows only from the first query
Returns rows only from the second query
Deletes a row
Which keywords are needed for defining a new procedure?
CREATE, BEGIN, END
CREATE, MAKE, FINISH
BEGIN, END
NEW_PROCEDURE
What is a foreign key?
A primary key of a different table present in another table
A key from a different SQL system (e.g. Postgres to SQL Server)
A key to the international version of SQL server
A primary key from any other database
