sql quiz

A SELECT statement comes in four main parts:

• SELECT

• FROM

• WHERE

• INPUT

• ORDER BY

Each table has a number of key elements: ................. and ............... .

• single flat file

• field names/attributes

• records

ORDER BY specifies ...................................

• the criteria you need to find the information

• the table(s) that contain(s) the information

• the information you want to find within the database

• how the data is organized (sorted) when it is retrieved.

Which statement is used to extract data from a database?

• Extract

• Open

• Get

• Select

What is data redundancy?

• Data that is repeated multiple times.
• Data that is safe from SQL attacks.
• Data that is weak to SQL attacks.

What would the role of an SQL "Alias" be?

• to search for a specified pattern in a column

• give a table, or a column in a table, a temporary name

• selects values within a given range

• delete existing records in a table

When examining a row in a table, we refer to it as a...

• row number

• result number

• record

• result

How many records are in this table?

• 7

• 6

• 5

• 4

SQL stands for .................................

• structured query language

• standard query language

If you were wanting to filter data, which clause would you use?

• Where

• Order by

• From

• Select