SQL Statements and Queries
Authored by AMO FSO GP2W
Professional Development
Professional Development
Used 44+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
15 questions
Show all answers
1.
MULTIPLE SELECT QUESTION
2 mins • 1 pt
What is the correct syntax of inserting to a database
INSERT INTO students (id, name, major) VALUES (1, 'Jane', 'Physics');
insert into students (id, name, major) values (1, 'Jane', 'Physics');
INSERT INTO students (id, name, major) VALUES (1, "Jane", "Physics");
INSERT INTO students (id, name, major) VALUES (1, 'Jane', 'Physics');
INSERT INTO students (id, name, major) VALUES (1, "Jane", "Physics");
2.
MULTIPLE SELECT QUESTION
2 mins • 1 pt
What is the correct syntax when creating a primary key
CREATE TABLE Persons (
ID INT NOT NULL,
LName VARCHAR(255),
FName VARCHAR(255),
Age INT,
PRIMARY KEY (ID));
CREATE TABLE Persons (
ID INT NOT NULL PRIMARY KEY,
LName VARCHAR(255),
FName VARCHAR(255),
Age INT);
CREATE TABLE Persons (
ID PRIMARY KEY,
LName VARCHAR(255),
FName VARCHAR(255),
Age INT);
CREATE TABLE Persons (
ID PK,
LName VARCHAR(255),
FName VARCHAR(255),
Age INT);
3.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
BLOB is a datatype
True
False
4.
MULTIPLE SELECT QUESTION
1 min • 1 pt
Select all that are Constraints
delete
not null
primary key
varchar
all of the above
5.
MULTIPLE CHOICE QUESTION
2 mins • 1 pt
How do you delete a specific record in students table?
DELETE FROM students WHERE ID=1;
DELETE FROM student WHERE ID=1;
DELETE * FROM students;
DROP TABLE students;
6.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Is it required to define a size for VARCHAR?
True
False
7.
MULTIPLE SELECT QUESTION
2 mins • 1 pt
Choose the items that are SQL Functions
SUM()
AVG()
COUNT()
LIKE()
DELETE()
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?
