Skip to Content
Home └Developing Queries with SQL └Quiz

Developing Queries with SQL

0 %

Completed

Course content

Quiz

10 XP
Prev Next
Fullscreen Share
Rating
0 0

There are no comments for now.

Join this Course
to be the first to leave a comment.

1. Which data type would best store a person’s birthday?
VARCHAR INT DATE MONEY
2. Which of the following is a numeric data type in SQL?
VARCHAR DATE INT CHAR
3. What is the purpose of the VARCHAR data type?
Store numeric values Store fixed-length characters Store variable-length strings Store boolean values
4. Which data type is used to store date values?
INT VARCHAR DATE FLOAT
5. Numeric Data Types
VARCHAR INT DECIMAL TEXT
6. What is the difference between FLOAT and DECIMAL?
FLOAT is more precise DECIMAL is more accurate for financial calculations FLOAT stores text They are exactly the same
7. You can use INT to store numbers with decimal places.
True False
8. Which of the following stores fixed-length character data?
TEXT CHAR VARCHAR CLOB
9. What is the difference between VARCHAR(50) and CHAR(50)?
CHAR uses less space VARCHAR always uses 50 characters CHAR pads unused space with blanks They behave identically
10. Which type is best for storing long paragraphs of text?
CHAR VARCHAR TEXT INT
11. Which data type stores both date and time?
DATE TIME DATETIME or TIMESTAMP TEXT
12. The DATE data type includes time information.
True False
13. What format is typically used by SQL to store dates?
MM-DD-YYYY DD/MM/YYYY YYYY-MM-DD Month Day, Year
14. What values can a Boolean data type store?
Only numbers TRUE or FALSE (or 1 and 0) Text values only Date and Time
15. Which data type is suitable for storing images or large files?
VARCHAR BINARY or BLOB CHAR INT
16. You can store an image in a TEXT data type.
True False