SQL RE-DO

SQL Structured Query Language

a domain-specific language used to manage data.

Multiple Choice

What does SQL stand for?

• Structured Query List
• Structured Query Language
• Simple Query Language
• Standard Query Language

When selecting data all you need is the column name and table name

SELECT *
FROM table_name;

Multiple Choice

What does * mean in SQL?

• SELECT

• COMMAND

• all columns

• Multiply

• Delete

When selecting data all you need is the column name and table name

SELECT column1, column2, ...
FROM table_name;

SELECT *
FROM table_name;

Open Ended

What is the different outputs between these SQL comands

SELECT column1, column2, ...
FROM table_name;

and

SELECT *
FROM table_name;

Multiple Choice

With SQL, how do you select a column named "FirstName" from a table named "Persons"?

• SELECT FirstName FROM People;
• SELECT FirstName FROM Users;
• SELECT FirstName FROM Persons;
• SELECT Name FROM Persons;

Multiple Choice

With SQL, how do you select a column named "LastName" from a table named "Persons"?

• GET LastName FROM Persons;
• SELECT LastName WHERE Persons;
• SELECT LastName FROM Persons;
• SELECT * FROM Persons;

Multiple Choice

With SQL, how do you select a column named "CarModel" from a table named "Cars"?

• SELECT * FROM Cars;
• SELECT CarModel FROM Cars;
• FROM Cars SELECT CarModel;
• SELECT CarModel WHERE Cars;

From

"From" is always the tables name.

Multiple Choice

What is the name of this table?

• events
• activities
• records
• logs

Multiple Choice

What is the name of this table?

• Scores
• Grades
• Subjects
• Results

Write and SQL statement that shows all fields for this table

Fill in the Blanks

Write an SQL statement that shows all fields for this table

SELECT *

tblOrders;

Fill in the Blanks

Write an SQL statement that shows all fields for this table

SELECT

From tblOrders;

Where

Where functions similar to an "IF" statement in python.

It is used to extract only those records that fulfill a specified condition.

​What will happen?

What does happen!

​What will happen?

What does happen!

​Where will happen?

What does happen!

Dropdown

​

Select answer

*
​

Select answer

Customers
​

Select answer

CustomerID > 80;

Dropdown

SELECT​ ​

Select answer

FROM​ ​

Select answer

​WHERE CustomerID ​

Select answer

80;

Open Ended

The following SQL statement is written to display all customer bookings that stay more than one night.
SELECT ALL

FROM TblBookings

IF Nights < 1

The SQL statement is incorrect. Rewrite the SQL statement so that it is correct.

Open Ended

Write an SQL statement for the following:

display all suppliers in "Tokyo"

the table name is Suppliers

Open Ended

Write an SQL statement for the following:

Table is call Orders

Display all fields if the EmployeeID is 4 and the orderDate is 7/8/1996