SQL Quiz 2

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