Go on. Explore!

lvl 0 • 0 xp

lvl 1

Home Market Decks Interests

ITP-225 CH6 (MySQL)

memorize.ai (lvl 286)

(0)

10 cards

()

Section 1

Preview this deck

(All of the above) KEY, UNIQUE, and FULLTEXT

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)

(All of the above) KEY, UNIQUE, and FULLTEXT

Front

MySQL supports the _____ index type.

Back

(All of the above) the entire database, each separate table, an individual column

Front

The character set can be assigned to _____.

Back

many-to-many

Front

Your database design should avoid two tables with a _____ relationship.

Back

False

Front

The character set used by the database can be different than that used by the PHP script or HTML page.

Back

identical to a primary key in a related table

Front

A foreign key is _____.

Back

True

Front

You can use different storage engines within the same database.

Back

the server

Front

"By default, MySQL stores dates and times using the time zone of _____."

Back

one-to-none

Front

Which of the following is not a relationship type?

Back

allow for NULL values

Front

You should not index columns that _____.

Back

InnoDB and MyISAM

Front

The two most commonly used storage engines in MySQL are _____.

Back