Go on. Explore!

lvl 0 • 0 xp

lvl 1

Home Market Decks Interests

MySQL Chapter 11

memorize.ai (lvl 286)

(0)

18 cards

()

Section 1

Preview this deck

What is CS ?

Front

1 / 18

SQL

0.0

0 reviews

5			0
4			0
3			0
2			0
1			0

Active users

All-time users

Favorites

Last updated

7 years ago

Date created

Mar 1, 2020

Cards (18)

Section 1

(18 cards)

What is CS ?

Front

Case Sensitive

Back

What is ci?

Front

Case-Insensitive

Back

Not Null

Front

What kind of constraint prevents null values from being stored in the column?

Back

Binary

Front

What means when the characters are sorted according to the binary numbers that corresponds with each character?

Back

Character Set

Front

What is used by a database, table, or column determining which characters can be stored and how many bytes are used to store the characters?

Back

Reference constraint

Front

What is also known as foreign key constraint?

Back

Primary key constraint

Front

What requires that each row has a unique value for the column or columns for the primary key, and it does not allow null values?

Back

Collation

Front

What is when every character set has a corresponding ? that determines how the characters are sorted?

Back

Attribute

Front

What are column names and data types?

Back

Table-level constraint

Front

What is as if it is a separate colukmn definition and you name the columns it constrains within that definition?

Back

Constraint

Front

What are used to enforce integrity of the data in a table by defining rules about the values that can be stored in the columns of the table?

Back

Column-level constraint

Front

What is used as part of a definition of the column it constrains?

Back

Script

Front

What is a file that contains one or more SQL statements?

Back

Foreign key constraint

Front

What requires values in one table to match values in another table?

Back

Unique Constraint

Front

What requires that each row has a unique value in a column but allows null values to be stored in the column?

Back

Index

Front

What helps speed up joins and searches by providing a way for a database management system to go directly to a row rather than having to search through all the rows until it finds the one you want?

Back

Storage Engine

Front

What determines how MYSQL stores data and which database features are available to you?

Back

Cascading Delete

Front

What makes it easier to delte data that you didn't intend to delete?

Back