A2 SQL Commands
Authored by Andrew Dawson
Computers
12th Grade
Used 7+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
20 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following SQL commands create a table?
CREATE TABLE TableName
CREATE TableName
BUILD TableName
INSERT TableName
Answer explanation
CREATE TABLE Students (
StudentID VARCHAR(4) NOT NULL,
StudentName VARCHAR(20) NOT NULL,
DOB DATE
PRIMARY KEY (StudentID)
)
Creates a table with 3 fields which specific validation techniques applied. The primary key is the StudentID. NOT NULL indicates that this field must be filled in when inserting a record.
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following SQL commands delete a table?
DELETE TABLE TableName
DELETE TableName
DROP TableName
REMOVE TableName
Answer explanation
DROP Students
Deletes the table and all the data
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following SQL commands return data from a database table?
SELECT
INSERT
DELETE
DROP
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following SQL commands return all the data from a database table?
SELECT * FROM Students
SELECT * FROM Pupils WHERE PupilID = “EHP01”
SELECT PupilID FROM Pupils
SELECT PupilName, DOB FROM Pupils WHERE Gender = “F”
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following SQL commands return a specific column from a database table?
SELECT * FROM Students
SELECT * FROM Pupils WHERE PupilID = “EHP01”
SELECT PupilID FROM Pupils
SELECT PupilName, DOB FROM Pupils WHERE Gender = “F”
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following SQL commands return all the data for a specific record?
SELECT * FROM Students
SELECT * FROM Pupils WHERE PupilID = “EHP01”
SELECT PupilID FROM Pupils
SELECT PupilName, DOB FROM Pupils WHERE Gender = “F”
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following SQL commands return all the data specific data that meets a given criteria?
SELECT * FROM Students
SELECT * FROM Pupils WHERE PupilID = “EHP01”
SELECT PupilID FROM Pupils
SELECT PupilName, DOB FROM Pupils WHERE Gender = “F”
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports
Continue with Google
Continue with Email
Continue with Microsoft
or continue with
%20(1).png)
Apple
Others
Already have an account?
