Go on. Explore!

lvl 0 • 0 xp

lvl 1

Home Market Decks Interests

ITP-225 CH4 (MySQL)

memorize.ai (lvl 286)

(0)

10 cards

()

Section 1

Preview this deck

USE

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

6 years ago

Date created

Mar 1, 2020

Cards (10)

Section 1

(10 cards)

USE

Front

The _____ SQL command is used to select the database with which you want to work.

Back

(All of the above) a semicolon, and \g

Front

SQL commands within the mysql client are terminated with _____.

Back

DECIMAL

Front

A price of a product in an e-commerce site should be stored in a column of type _____.

Back

(All of the above) must always have a value, must always have a unique value, and must have a value that never changes

Front

Primary key columns _____.

Back

(All of the above) letters, underscores, and numbers

Front

"A database, table, or column name can consist of _____."

Back

CHAR(2)

Front

A two letter state abbreviation would be best stored in a column of type _____.

Back

DEFAULT

Front

"To indicate a default value for a column, add the _____ property to its definition."

Back

(All of the Above) NOT NULL, AUTO_INCREMENT, and UNSIGNED

Front

Primary key columns should almost always have the following properties:

Back

UNSIGNED

Front

"If a numeric type will never store negative values, that column should be marked as _____."

Back

command line interface

Front

The mysql client is accessible through your computer's _____.

Back