SQL Statements and Queries

Quiz
•
Professional Development
•
Professional Development
•
Hard

AMO FSO GP2W
Used 44+ times
FREE Resource
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()
Create a free account and access millions of resources
Similar Resources on Wayground
10 questions
Budget System

Quiz
•
Professional Development
13 questions
Python Quiz : Loop

Quiz
•
Professional Development
10 questions
Nodejs: Database SQL

Quiz
•
Professional Development
20 questions
SQL FINAL ASSESSMENT

Quiz
•
Professional Development
10 questions
Excel - Conditional Functions

Quiz
•
Professional Development
10 questions
Filtering and Sorting

Quiz
•
Professional Development
10 questions
OYMS Training

Quiz
•
Professional Development
10 questions
MDP(Custom)-Accenture-16/08/21 (Day 21)

Quiz
•
Professional Development
Popular Resources on Wayground
15 questions
Hersheys' Travels Quiz (AM)

Quiz
•
6th - 8th Grade
20 questions
PBIS-HGMS

Quiz
•
6th - 8th Grade
30 questions
Lufkin Road Middle School Student Handbook & Policies Assessment

Quiz
•
7th Grade
20 questions
Multiplication Facts

Quiz
•
3rd Grade
17 questions
MIXED Factoring Review

Quiz
•
KG - University
10 questions
Laws of Exponents

Quiz
•
9th Grade
10 questions
Characterization

Quiz
•
3rd - 7th Grade
10 questions
Multiply Fractions

Quiz
•
6th Grade