FD2- Data Types

Question 1

Why are data types important?

Answer 1

1)Organize and process data effectively.
2)Data integrity (Only valid data types stored)

Question 2

Fundamental data types can be classified into which 3 groups?

Answer 2

Character (everything on keyboard)
Numeric
Date

Question 3

What are the examples of complex data types?

Answer 3

Maps
Images
Video

Question 4

What is a keyword?

Answer 4

A reserved word that a system recognize as instruction to perform tasks

Question 5

What are the common data types used in spreadsheet or database?

Answer 5

Numbers
Date/Time
Currency
String
Boolean

Question 6

What is the important strategy when assigning data types?

Answer 6

Consider purpose of data (what for, why, who)

Question 7

What is character?

Answer 7

Contains only a single value of number or letter or symbol.

Question 8

What is String?

Answer 8

String is combination of characters.
In spreadsheet, it is stored in TEXT.
TEXT formats all values as characters.

Question 9

What is Numbers?

Answer 9

Numeric values (non-digits)
Example: Integers, Real number, decimal numbers
Different systems has capacity of storing different numbers.
Spreadsheet has no limitations of types of number. (No need specify which number type)
Database have its own limitations of types of numbers. (Need specify which number type)

Question 10

Explain Date/Time

Answer 10

Date differ from country to country
DD/MM/YY or MM/DD/YY
Time formats differ based on different purpose
HH/MM/SS or HH only or SS only
Integration between date and time require the use of TIMEVALUE and INTERVAL

Question 11

Explain Currency.

Answer 11

Decimal is used in CURRENCY data type.
A currency sign will be added next to the stored digit.

Question 12

Explain Boolean.

Answer 12

True or False.
Can be used in yes-or-no situations
Supported by most systems