Go on. Explore!

lvl 0 • 0 xp

lvl 1

Home Market Decks Interests

MySQL Chapter 04

memorize.ai (lvl 286)

(0)

29 cards

()

Section 1

Preview this deck

T/F - A foreign key is a combination of one or more columns used to establish and enforce a link between the data in two tables.

Front

1 / 29

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 (29)

Section 1

(29 cards)

T/F - A foreign key is a combination of one or more columns used to establish and enforce a link between the data in two tables.

Front

True

Back

T/F - Considering using a clustered index when columns contain a large number of distinct values.

Front

True

Back

Add an index to one or more columns to speed up data _____.

Front

Retrieval

Back

T/F - You can create a foreign key by defining a foreign key constraint when you create or alter a table.

Front

True

Back

When you define a primary key, you have met the first criteria for ____.

Front

1NF

Back

T/F - A table can contain only one clustered index.

Front

True

Back

T/F - Consider using a clustered index when queries return large result sets.

Front

True

Back

Which of the following is not a constraint? CHECK, DEFAULT, UNIQUE, INDEX

Front

INDEX

Back

T/F - A table can contain only one foreign key.

Front

False

Back

T/F - Indexes allow faster data retrieval.

Front

True

Back

What is the name for the situation in which more than one columns act as a primary key?

Front

Composite primary key

Back

T/F - Tables in a database must satisfy all five normal forms in order to maximize performance.

Front

False

Back

T/F - Consider using a clustered index when columns undergo frequent changes.

Front

False

Back

Which of the following things can help speed data retrieval? A DEFAULT constraint, A primary key constraint, A clustered index, A foreign key constraint

Front

A primary key constraint, A clustered index

Back

T/F - Optimal database performance can be achieved by indexing every column in a table.

Front

False

Back

What could not be used as a primary key?

Front

An address

Back

T/F - A clustered index usually improves performance when inserting data.

Front

False

Back

Normalization is the elimination of redundant data to save ____.

Front

Space

Back

T/F - A primary key can contain NULL values.

Front

False

Back

T/F - A few wide tables (with more columns) are characteristic of a normalized database.

Front

False

Back

A foreign key works in conjunction with primary key or unique constraints to enforce ____.

Front

Referential integrity

Back

Which normal form ensures that each attribute describes the entity?

Front

2NF

Back

T/F - Creating a primary key satisfies one of the first normal form criteria.

Front

True

Back

T/F - A foreign key enforces referential integrity by ensuring only valid data is stored.

Front

True

Back

T/F - A greater number of narrow tables (with fewer columns) is a characteristic of a normalized database.

Front

True

Back

The value of a primary key must be ____.

Front

Unique

Back

How many clustered indexes can you have for a table or database?

Front

1

Back

T/F - Consider using a clustered index when columns are accessed sequentially.

Front

True

Back

Values in a clustered index are ____.

Front

Sorted

Back