SQL 3

Quiz
•
Computers
•
11th Grade
•
Medium
O Hawkridge
Used 7+ times
FREE Resource
14 questions
Show all answers
1.
DROPDOWN QUESTION
30 sec • 1 pt
SQL stands for (a) .
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following best describes the function of a primary key in a database?
A method to secure database access
A unique identifier for each record
A way to enhance the performance of database queries
A tool for defining relationships between tables
3.
MULTIPLE CHOICE QUESTION
1 min • 3 pts
Select the appropriate SQL query to show...
The title and description of all reviews for products that cost less than £100.
SELECT title, description
FROM Product, Review
WHERE Product.ProductID = Review.ProductID
AND Price < 100
SELECT title, description
FROM *
WHERE Price < 100
SELECT *
FROM Product, Review
WHERE Product.ProductID = Review.ProductID
SELECT title, description
FROM Product
WHERE Product.ProductID = Review.ProductID
AND Price <= 100
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which word is missing from the following SQL statement?
SELECT * table_name
WITH
WHERE
FROM
AND
5.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
How would we script a SQL query to select "Description" from the Item table?
SELECT Item.Description
EXTRACT Description FROM Item
SELECT Item FROM Description
SELECT Description FROM Item
6.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
Which query would return only the fields DesignerID and Designer?
SELECT * FROM Designers
SELECT DesignerID, Name FROM Designers
SELECT DesignerID AND Designer FROM Designers
SELECT DesignerID, Designer FROM Designers
7.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
You are required to update the phone number for only the DesignerID "SMI01" in the "Designer" table. Which of these would successfully do that?
UPDATE Designer SET PhoneNo = '01224123456'
UPDATE Designer (PhoneNo) VALUES ('01224123456')
UPDATE Designer SET PhoneNo = '01224123456' WHERE DesignerID = 'SMI01'
UPDATE PhoneNo = '01224123456' FROM Designer WHERE DesignerID = 'SMI01'
Create a free account and access millions of resources
Similar Resources on Wayground
10 questions
Examen Informática Mayo - 2° BTO

Quiz
•
11th Grade
16 questions
Revision MIT App Inventor after lvl3 clouds

Quiz
•
5th - 12th Grade
10 questions
Gravit Designer Basics

Quiz
•
10th - 12th Grade
15 questions
RO93 imedia

Quiz
•
11th Grade
15 questions
Unit 1 & 2

Quiz
•
9th - 12th Grade
16 questions
Inkscape Quiz: Vectors and More

Quiz
•
7th Grade - University
16 questions
Photoshop tools

Quiz
•
6th Grade - Professio...
11 questions
Device and Configuration- Domain (2)

Quiz
•
9th - 12th Grade
Popular Resources on Wayground
10 questions
Video Games

Quiz
•
6th - 12th Grade
10 questions
Lab Safety Procedures and Guidelines

Interactive video
•
6th - 10th Grade
25 questions
Multiplication Facts

Quiz
•
5th Grade
10 questions
UPDATED FOREST Kindness 9-22

Lesson
•
9th - 12th Grade
22 questions
Adding Integers

Quiz
•
6th Grade
15 questions
Subtracting Integers

Quiz
•
7th Grade
20 questions
US Constitution Quiz

Quiz
•
11th Grade
10 questions
Exploring Digital Citizenship Essentials

Interactive video
•
6th - 10th Grade