SQLite - 2 - SQLite Data Types MCQ

SQLite – SQLite Data Types

1 / 26

1. What is the primary purpose of data types in SQLite?

To control access to the database

To limit the database size

To specify data values

To determine the database schema

2 / 26

2. Which data type in SQLite is used for storing textual data?

BLOB

REAL

INTEGER

TEXT

3 / 26

3. What is the maximum length of a TEXT column in SQLite?

Unlimited

512 characters

255 characters

64KB

4 / 26

4. Which data type in SQLite is used to store whole numbers?

TEXT

INTEGER

BLOB

REAL

5 / 26

5. What is the maximum value that can be stored in a 32-bit INTEGER in SQLite?

2^31 – 1

2^63 – 1

2^32 – 1

There is no maximum value

6 / 26

6. Which data type in SQLite is used to store floating-point numbers?

TEXT

INTEGER

BLOB

REAL

7 / 26

7. What is the maximum size of a REAL data type in SQLite?

Unlimited

64 bytes

4 bytes

8 bytes

8 / 26

8. Which data type in SQLite is used to store binary data, such as images?

TEXT

BLOB

REAL

INTEGER

9 / 26

9. What is the maximum size of a BLOB data type in SQLite?

1 megabyte

2 gigabytes

Unlimited

4 terabytes

10 / 26

10. Which data type is suitable for storing dates and times in SQLite?

INTEGER

DATETIME

TEXT

REAL

11 / 26

11. What is the format of date and time values in a DATETIME column in SQLite?

HH:MM:SS MM-DD-YYYY

DD-MM-YYYY HH:MM:SS

YYYY-MM-DD HH:MM:SS

MM-DD-YYYY HH:MM:SS

12 / 26

12. Which data type can be used to store a true/false or yes/no value in SQLite?

INTEGER

TEXT

BLOB

BOOLEAN

13 / 26

13. How is a BOOLEAN value represented in SQLite?

0 for false, 1 for true

"0" and "1"

"No" and "Yes"

"False" and "True"

14 / 26

14. Which data type is used to store a fixed-length binary string in SQLite?

VARCHAR

CHAR

BLOB

TEXT

15 / 26

15. What is the primary difference between VARCHAR and CHAR in SQLite?

VARCHAR is used for numbers, CHAR is used for text

VARCHAR is case-sensitive, CHAR is case-insensitive

VARCHAR allows for variable-length strings, CHAR is fixed-length

VARCHAR is for small data, CHAR is for large data

16 / 26

16. Which data type in SQLite is used for storing currency values?

REAL

NUMERIC

MONEY

CURRENCY

17 / 26

17. How does the NUMERIC data type differ from REAL in SQLite?

NUMERIC is case-sensitive, REAL is case-insensitive

NUMERIC stores exact decimal values, REAL uses floating-point

NUMERIC allows for scientific notation, REAL does not

NUMERIC stores integers only, REAL stores decimal numbers

18 / 26

18. Which data type in SQLite is used to store a boolean value?

BOOL

INTEGER

BOOLEAN

TEXT

19 / 26

19. What is the maximum value that can be stored in a BOOLEAN column in SQLite?

1

False

0

True

20 / 26

20. In SQLite, what is the purpose of the NULL value?

To mark a record as deleted

To indicate a positive value

To represent a missing or unknown value

To indicate a zero value

21 / 26

21. Which data type in SQLite is used for storing Unicode character data?

VARCHAR

CHAR

UNICODE

TEXT

22 / 26

22. What is the primary benefit of using the TEXT data type for character data in SQLite?

It is case-insensitive

It allows for binary data

It supports Unicode characters

It is efficient for large text

23 / 26

23. In SQLite, how do you specify a default value for a column?

SET DEFAULT

SET VALUE DEFAULT

DEFAULT VALUE

DEFAULT

24 / 26

24. Which data type in SQLite is used for storing a large amount of text data?

CLOB

CHAR

TEXT

VARCHAR

25 / 26

25. What is the maximum size of a CLOB data type in SQLite?

4 petabytes

Unlimited

1 gigabyte

2 terabytes

26 / 26

26. Which data type is used to store a single character in SQLite?

STRING

CHARACTER

CHAR

TEXT

Your score is

0%

SQLite – 2 – SQLite Data Types MCQ