WorksheetsSQL Commands - SELECT Statements
Total questions: 10
Worksheet time: 6mins
Complete the SELECT Statement
SELECT * (a) ABC
What does ABC in the Select Statement Represent?
SELECT * FROM ABC
The Name of the Table
The Name of the Database
The Name of the Column
What does the * in the Select Statement represent?
SELECT * FROM ABC
The First Column in the Table
All the Columns
in the Table
The Last Column in the Table
What goes into the WHERE Clause of a Select Statement?
SELECT * FROM ABC
WHERE _____
The database that the table is in
The columns that need to be retrieved
The condition that the Results must fulfil
Modify the Select Statement to only get the following Columns
Col1, Col2
SELECT * FROM ABC
SELECT
Col1 and Col2
FROM ABC
SELECT
Col1 Col2
FROM ABC
SELECT
Col1, Col2, *
FROM ABC
SELECT
Col1, Col2
FROM ABC
Which is the line that helps us check if the phone number '91234567' is already added?
SELECT Name, Email
FROM Contacts
WHERE Phone = '91234567'
SELECT Name, Email
FROM Contacts
WHERE Phone = '91234567'
Which is the line that tells SQL which table to use?
SELECT Name, Email
FROM Contacts
WHERE Phone = '91234567'
SELECT Name, Email
FROM Contacts
WHERE Phone = '91234567'
Which line do we modify to change the columns we retrieve?
SELECT Name, Email
FROM Contacts
WHERE Phone = '91234567'
SELECT Name, Email
FROM Contacts
WHERE Phone = '91234567'
What happens if we leave out the WHERE part of a SELECT Statement?
SELECT Name, Email
FROM Contacts
WHERE Phone = '91234567' <-
All the results will display
All the results will be wrong
An Error will occur
What happens if we rearrange the Columns in a Select Statement?
SELECT Email, Name <-
FROM Contacts
WHERE Phone = '91234567'
The columns will not be retrieved
The columns will be displayed in that order
An Error will occur
