Go on. Explore!

lvl 0 • 0 xp

lvl 1

Home Market Decks Interests

ITP-225 CH5 (MySQL)

memorize.ai (lvl 286)

(0)

10 cards

()

Section 1

Preview this deck

ascending

Front

1 / 10

SQL

0.0

0 reviews

5			0
4			0
3			0
2			0
1			0

Active users

All-time users

Favorites

Last updated

4 years ago

Date created

Mar 1, 2020

Cards (10)

Section 1

(10 cards)

ascending

Front

"By default, ORDER BY sorts results in _____ order."

Back

CREATE

Front

What SQL command is used to make a new database or database table?

Back

every column

Front

The asterisk in the query SELECT * FROM tablename means _____.

Back

UPDATE

Front

The _____ command is used to change the values already stored in a table.

Back

rows

Front

Conditionals in a query impact which _____ are returned.

Back

(All of the above) Strings, Dates, and Times

Front

Which of the following value types should be quoted when used in queries?

Back

SELECT

Front

What SQL command is used to fetch records from a table?

Back

USE

Front

What SQL command is used to select the database with which you want to work?

Back

INSERT

Front

What SQL command is used to add a record to a table?

Back

DELETE

Front

A single record can be removed from a table using _____ and a LIMIT clause or conditional.

Back