Should be used to choose the database you want to use once you’ve connected to MySQL

Is a pseudonym for the SELECT command

Has been deprecated and should be avoided for security reasons

Is used to load code from another file

Which statement is used to count number of rows in table?

SELECT COUNT(*) FROM table_name;

SELECT COUNT ALL(*) FROM table_name;

SELECT ROWS(*) FROM table_name;

Which query would return only the fields DesignerID and Designer?

SELECT DesignerID, Designer FROM Designers

SELECT DesignerID, Name FROM Designers

SELECT DesignerID AND Designer FROM Designers

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' WHERE DesignerID = 'SMI01'

UPDATE Designer SET PhoneNo = '01224123456'

UPDATE Designer (PhoneNo) VALUES ('01224123456')

UPDATE PhoneNo = '01224123456' FROM Designer WHERE DesignerID = 'SMI01'

With SQL how can I return all items in the Item table sorted from the lowest priced to the highest priced?

SELECT * FROM Items ORDER BY Price ASC

SELECT * FROM Items ORDER BY Price ASCENDING

SELECT * FROM Items BY Price LOWEST TO HIGHEST

SELECT * FROM Items ORDER BY Price DESC

How would you DELETE records from the Items table with a "Chair" Type?

DELETE FROM Items WHERE Type = 'Chair'

DELETE Type FROM Items WHERE Type = 'Chair'

DELETE ITEMS WHERE Type = 'Chair'

How would you display Chairs in the Items table that have a Price greater than £50.

SELECT * FROM Items WHERE Type = 'Chair' AND Price > 50

SELECT * FROM Items WHERE Type = 'Chair' OR Price < 100

SELECT * FROM Iterms WHERE Type = 'Chair' AND Price >= 50

SELECT * FROM Items WHERE Price > 50

Which SQL statement would add a record to the database?

INSERT INTO Designer VALUES ('SMI01', 'M Smith', 'mail@msmith.com', '01224123456')

INSERT VALUES ('SMI01', 'M Smith', 'mail@msmith.com', 01224123456') INTO Designer

INSERT ('SMI01', 'M Smith', 'mail@msmith.com', '01224123456') INTO Designer

INSERT Designer INTO VALUES (''SMI01', 'M Smith', 'mail@msmith.com', '01224123456')

I want to select EVERY column and entry in my "actors" table. How can I do that?

SELECT * FROM actors WHERE age > 30;

SELECT name, age FROM actors WHERE age < 30;

I want to add the actor "Brad Pitt" (aged 56) to my table "actors." Which statement will do this?

INSERT INTO actors VALUES ("Brad Pitt", 56);

INSERT "Brad Pitt" AND 56 INTO actors;

UPDATE age = 56 WHERE name = "Brad Pitt";

CREATE ENTRY ("Brad Pitt", 56) IN TABLE actors;

I want to select all columns in my "actors" table for all actors older than 30. How can I do that?

SELECT * FROM actors WHERE age > 30;

SELECT name, age FROM actors WHERE age < 30;

My Sql

Authored by bhawna arora

Computers

12th Grade

Used 18+ times

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

Content View

Student View

40 questions

Show all answers

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What does SQL stands for?

Standard Query Language

Structured Query Language

Structured Query Link

Standard Query Link

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Where does the CREATE Command belong?

DML

DDL

DCL

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

An SQL command used to add record in a table.

Insert

Create

Update

Add

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

A clause in the SELECT command that specifies the condition the records must satisfy.

Table_name

WHERE

Database name

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

It is a DML command that is used to display record.

DISPLAY

STRUCTURE

WHERE

SELECT

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

This symbol is placed immediately after the SELECT command to display all the fields.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

This symbol is an SQL wildcard that can substitute for one or more characters when searching for data in a database.

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 Classlink

Continue with Clever

or continue with

Microsoft

Apple

Others

Already have an account?

Similar Resources on Wayground

40 questions

Media and Information Literacy Review Long Quiz

Quiz

•

12th Grade

35 questions

Unit 1 Exam

Quiz

•

12th Grade

40 questions

removal Empowerment Technologies-11 Galanida

Quiz

•

11th - 12th Grade

35 questions

term 2 practice grade 7

Quiz

•

7th Grade - University

35 questions

LATIHAN SAS GANJIL DKV X

Quiz

•

9th - 12th Grade

45 questions

Microsoft Excel - Basics

Quiz

•

7th Grade - University

39 questions

AQA Computer Science GCSE - 3.5 Computer networks

Quiz

•

10th - 12th Grade

37 questions

Stock Market-Stock Market Game

Quiz

•

8th - 12th Grade

Popular Resources on Wayground

15 questions

Fractions on a Number Line

Quiz

•

3rd Grade

20 questions

Equivalent Fractions

Quiz

•

3rd Grade

25 questions

Multiplication Facts

Quiz

•

5th Grade

$fractions$

22 questions

fractions

Quiz

•

3rd Grade

20 questions

Main Idea and Details

Quiz

•

5th Grade

20 questions

Context Clues

Quiz

•

6th Grade

15 questions

Equivalent Fractions

Quiz

•

4th Grade

20 questions

Figurative Language Review

Quiz

•

6th Grade

Discover more resources for Computers

18 questions

[AP CSP] JavaScript Programming Lesson 2025-2026

Lesson

•

9th - 12th Grade

My Sql

What does SQL stands for?

Where does the CREATE Command belong?

An SQL command used to add record in a table.

A clause in the SELECT command that specifies the condition the records must satisfy.

It is a DML command that is used to display record.

This symbol is placed immediately after the SELECT command to display all the fields.

This symbol is an SQL wildcard that can substitute for one or more characters when searching for data in a database.

What is the meaning of DML?

What is the meaning of DDL?

What is the commands that define a database, including creating, altering, and dropping tables and establishing constraints

Access all questions and much more by creating a free account

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Computers