SQL 2

SQL 2

Multiple Choice

What does SQL stand for?

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

Multiple Choice

What are the 3 key words to remember?

• Sense, and, sensibility

• Focus, Clarity, Action
• Select, From, Where

• Grand, Theft, Auto

• Select, Command,

  Delete

SELECT

The SELECT statement is used to select data from a database.

Dropdown

SELECT selects the ​

Select answer

of the table, that the user wants to display

FROM

FROM is the name of the table you are using.

Multiple Choice

What is the tables name

• Scoreboard
• Analysis Sheet
• Output Chart
• Data Summary
• Result Table

Multiple Choice

What is the tables name?

• Table E
• Table C
• Table A
• Table D
• Table B

Multiple Select

What SQL statement is correct?

• SELECT * FROM scones;

• SELECT * FROM Sc0res;

• SELECT * FROM scores;

• SELECT * FROM Scores;

SELECT (Specific)

SELECT * selects all the columns but what if I wanted to select certain columns!

Open Ended

What will happen?

SELECT CustomerID, CustomerName, Address, City, PostalCode

FROM Customers;

Open Ended

Write a SQL statement that Shows P_ID, and the place.

Click here