SQL 3

SQL 3

11th Grade

14 Qs

quiz-placeholder

Similar activities

INTERNET AND INTRANET

INTERNET AND INTRANET

9th - 11th Grade

10 Qs

Email Lớp 6

Email Lớp 6

6th Grade - University

17 Qs

Adopt me

Adopt me

KG - Professional Development

14 Qs

PAS GANJIL 2024

PAS GANJIL 2024

11th Grade

10 Qs

exploring computer science

exploring computer science

9th - 12th Grade

15 Qs

vlan aij xii

vlan aij xii

11th Grade

18 Qs

ASJ_XII_UH1

ASJ_XII_UH1

1st - 12th Grade

15 Qs

J808 LO1 and LO2 planning project keywords / terms

J808 LO1 and LO2 planning project keywords / terms

9th - 11th Grade

15 Qs

SQL 3

SQL 3

Assessment

Quiz

Computers

11th Grade

Practice Problem

Medium

Created by

O Hawkridge

Used 9+ times

FREE Resource

AI

Enhance your content in a minute

Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...

14 questions

Show all answers

1.

DROPDOWN QUESTION

30 sec • 1 pt

SQL stands for (a)   .

Strong Question Language
Structured Question Language
Structured Query Language
Seequal Language

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

Media Image

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'

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?