Logo

Go on. Explore!

lvl 0 • 0 xp

lvl 1

HomeMarketDecksInterests
MySQL Data Types

MySQL Data Types

memorize.aimemorize.ai (lvl 286)
Star 0%
Star 0%
Star 0%
Star 0%
Star 0%
(0)
(0)
(0)
30 cards
()
Section 1

Preview this deck

NN means what?

Front

1 / 30

SQL
Star 0%
Star 0%
Star 0%
Star 0%
Star 0%

0.0

0 reviews

5
0
4
0
3
0
2
0
1
0

Active users

0

All-time users

0

Favorites

0

Last updated

6 years ago

Date created

Mar 1, 2020

Cards (30)

Section 1

(30 cards)

NN means what?

Front

the column may not have NULL values

Back

What are MySQL numerical data types?

Front

BIT, TINYINT, SMALLINT, MEDIUMINT, INT, BIGINT, FLOAT, DOUBLE, DECIMAL

Back

What do Entities become in an RDBMS?

Front

Entities become tables

Back

BIT default to what

Front

one bit

Back

FLOAT

Front

Small number with a floating decimal point

Back

The more information a data type can store the larger what?

Front

the larger the memory required to store a field

Back

When modeling a database or creating a table what MySQL data types should you use?

Front

Appropriate for each column based on type of date to be stored

Back

Parameters may specify what?

Front

display width, or precision (length), and scale (decimal places)

Back

Numerical data types can store what

Front

signed data types (default mode), requiring a single bit to determine if the number is positive or negative

Back

How an attribute is stored in an RDBMS is controlled by what?

Front

The data type selected for the attribute

Back

What is SQL now?

Front

Standard that encompasses additional features beyond just data manipulation

Back

BIT

Front

1 - 64

Back

In an RDBMS attributes become what?

Front

Columns and fields

Back

AI means an INTEGER column means what?

Front

Automatically increment

Back

DOUBLE

Front

Large number with a floating decimal point

Back

Data types become part of the SQL used for what?

Front

to create a table

Back

BIT synonyms

Front

BOOL , BOOLEAN, TINYINT(1)

Back

What does not supplying parameters will use what?

Front

default values

Back

Storage of attributes should be what?

Front

Appropriate and as compact as practible

Back

Numerical data types can also be unsigned

Front

Back

SQL was originally used for what?

Front

To manage data in an RDBMS

Back

PK means what?

Front

The column participates as the primary key and no data in this column may be repeated

Back

FLOAT synonyms

Front

REAL, DOUBLE PRECISION

Back

CHAR

Front

Fixed space from

Back

RDBMS

Front

Relational Database Management System

Back

DECIMAL synonyms

Front

DEC, NUMERIC, FIXED

Back

Most numerical data types support what?

Front

parameters

Back

Entities have what

Front

attributes

Back

DECIMAL

Front

DOUBLE allowing for a fixed decimal point

Back

What is decimal default

Front

(10,0)

Back