Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

DBMS > SQL - Data Types > Flashcards

SQL - Data Types Flashcards

1
Q

identification

is an attribute that specifies the type of data of any object.

A

Data Type

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

identification

SQL Server offers six categories of data types for your use which are

A
  1. Exact Numeric Data Types
  2. Approximate Numeric Data Types
  3. Date and Time Data Types
  4. Character Strings Data Types
  5. Unicode Character Strings Data Types
  6. Binary Data Types
    also Misc Data Types
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

identification

  1. bigint
  2. int
  3. smallint
  4. tinyint
  5. bit
  6. decimal
  7. numeric
  8. money
  9. smallmoneyExact
A

Exact Numeric Data Types

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

identification

Exact Numeric Data Types

A
  1. bigint
  2. int
  3. smallint
  4. tinyint
  5. bit
  6. decimal
  7. numeric
  8. money
  9. smallmoneyExact Numeric Data Types
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

identification

  1. float
  2. real
A

Approximate Numeric Data Types

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

identification

  1. datetime
  2. smalldatetime
  3. date
  4. time
A

Date and Time Data Types

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

identification

  1. char
  2. varchar
  3. varchar(max)
  4. text
A

Character Strings Data Types

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

identification

  1. nchar
  2. nvarchar
  3. nvarchar(max)
  4. ntext
A

Unicode Character Strings Data Types

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

identification

  1. binary
  2. varbinary
  3. varbinary(max)
  4. image
A

Binary Data Types

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

identification

  1. sql_variant
  2. timestamp
  3. uniqueidentifier
  4. xml
  5. cursor
  6. table
A

Misc Data Types

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

identification

Approximate Numeric Data Types

A
  1. float
  2. real
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

identification

Date and Time Data Types

A
  1. datetime
  2. smalldatetime
  3. date
  4. time
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

identification

Character Strings Data Types

A
  1. char
  2. varchar
  3. varchar(max)
  4. text
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

identification

Unicode Character Strings Data Types

A
  1. nchar
  2. nvarchar
  3. nvarchar(max)
  4. ntext
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

identification

Binary Data Types

A
  1. binary
  2. varbinary
  3. varbinary(max)
  4. image
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

identification

Misc Data Types

A
  1. sql_variant
  2. timestamp
  3. uniqueidentifier
  4. xml
  5. cursor
  6. table
17
Q

Data Types

Stores a result set for later processing

A

table

18
Q

Data Types

Reference to a cursor object

A

cursor

19
Q

Data Types

Stores XML data. You can store xml instances in a column or a variable (SQL Server 2005 only).

A

xml

20
Q

Data Types

Stores a globally unique identifier (GUID)

A

uniqueidentifier

21
Q

Data Types

Stores a database-wide unique number that gets updated every time a row gets updated

A

timestamp

22
Q

Data Types

Stores values of various SQL Server-supported data types, except text, ntext, and timestamp.

A

sql_variant

23
Q

Data Types

Maximum length of 2,147,483,647 bytes. ( Variable length Binary Data)

A

image

24
Q

Data Types

Maximum length of 231 bytes (SQL Server 2005 only). (Variable length Binary data)

A

varbinary(max)

25
Q

Data Types

Maximum length of 8,000 bytes.(Variable length binary data)

A

varbinary

26
Q

Data Types

Maximum length of 8,000 bytes(Fixed-length binary data )

A

binary

27
Q

Data Types

Maximum length of 1,073,741,823 characters. ( Variable length Unicode )

A

ntext

28
Q

Data Types

Maximum length of 231characters (SQL Server 2005 only).(Variable length Unicode)

A

nvarchar(max)

29
Q

Data Types

Maximum length of 4,000 characters.(Variable length Unicode)

A

nvarchar

30
Q

Data Types

Maximum length of 4,000 characters.(Fixed length Unicode)

A

nchar

31
Q

Data Types

Variable-length non-Unicode data with a maximum length of 2,147,483,647 characters.

A

text

32
Q

Data Types

Maximum length of 231characters, Variable-length non-Unicode data (SQL Server 2005 only).

A

varchar(max)

33
Q

Data Types

Maximum of 8,000 characters.(Variable-length non-Unicode data).

A

varchar

34
Q

Data Types

Maximum length of 8,000 characters.(Fixed length non-Unicode characters)

A

char

35
Q

Data Types

Stores a date like June 30, 1991

A

date

36
Q

Data Types

Stores a time of day like 12:30 P.M.

A

time

DBMS (10 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions