SQL - Data Types

Question 1

identification

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

Answer 1

Data Type

Question 2

identification

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

Answer 2

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

Question 3

identification

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

Answer 3

Exact Numeric Data Types

Question 4

identification

Exact Numeric Data Types

Answer 4

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

Question 5

identification

1. float
2. real

Answer 5

Approximate Numeric Data Types

Question 6

identification

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

Answer 6

Date and Time Data Types

Question 7

identification

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

Answer 7

Character Strings Data Types

Question 8

identification

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

Answer 8

Unicode Character Strings Data Types

Question 9

identification

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

Answer 9

Binary Data Types

Question 10

identification

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

Answer 10

Misc Data Types

Question 11

identification

Approximate Numeric Data Types

Answer 11

1. float
2. real

Question 12

identification

Date and Time Data Types

Answer 12

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

Question 13

identification

Character Strings Data Types

Answer 13

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

Question 14

identification

Unicode Character Strings Data Types

Answer 14

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

Question 15

identification

Binary Data Types

Answer 15

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

Question 16

identification

Misc Data Types

Answer 16

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

Question 17

Data Types

Stores a result set for later processing

Answer 17

table

Question 18

Data Types

Reference to a cursor object

Answer 18

cursor

Question 19

Data Types

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

Answer 19

xml

Question 20

Data Types

Stores a globally unique identifier (GUID)

Answer 20

uniqueidentifier

Question 21

Data Types

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

Answer 21

timestamp

Question 22

Data Types

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

Answer 22

sql_variant

Question 23

Data Types

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

Answer 23

image

Question 24

Data Types

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

Answer 24

varbinary(max)

Question 25

Data Types

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

Answer 25

varbinary

Question 26

Data Types

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

Answer 26

binary

Question 27

Data Types

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

Answer 27

ntext

Question 28

Data Types

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

Answer 28

nvarchar(max)

Question 29

Data Types

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

Answer 29

nvarchar

Question 30

Data Types

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

Answer 30

nchar

Question 31

Data Types

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

Answer 31

text

Question 32

Data Types

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

Answer 32

varchar(max)

Question 33

Data Types

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

Answer 33

varchar

Question 34

Data Types

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

Answer 34

char

Question 35

Data Types

Stores a date like June 30, 1991

Answer 35

date

Question 36

Data Types

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

Answer 36

time