SQL Basics

What does SQL stand for?

• Strong Question Language

• Structured Query Language

• Structured Question Language

• Strong Query Language

Which SQL Statement is used to get data from a database

• GET

• EXTRACT

• SELECT

• SHOW

What is missing from the following SQL statement:

SELECT * _______ Customers;

• SELECT

• ORDER BY

• WHERE

• FROM

What is the purpose of a * ?

• Selects all fields from a table

• Selects all rows from a table

• Selects the first record from a table

• Selects the last record from a table

Which of the following does not describe the relationship in the diagram

• A player can play no games or many games

• A game must have at least one player

• A game can have more then one player

• A player has to play at least one game

Which clause lets you filter data?

• SORT

• ORDER BY

• WHERE

• FILTER

For an AND operator either condition must be true to return a record.

• True

• False

What does the FROM clause do?

• Selects the columns to be returned

• Selects the rows to be returned

• Selects the table to use in the query

• Selects the database to use in the query

Which of the following is used to select all the records from the Order Table where the Price is more then $100?

• SELECT * FROM Order WHERE Price > 100;

• SELECT [all] FROM Order WHERE Price > 100;

• SELECT Order WHERE Price > 100;

• SELECT * FROM Order WHERE Price OVER 100

Which of the following allows you to add more then one filter to a query?

• LIKE

• BETWEEN

• EQUALS

• OR