
Databases - Review Questions With Answers
Authored by Susan Fudge
Information Technology (IT)
11th Grade

AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
7 questions
Show all answers
1.
MULTIPLE SELECT QUESTION
30 sec • 1 pt
What is the difference between VARCHAR and INT data types?
VARCHAR stores variable-length text
INT is used for whole numbers
Answer explanation
VARCHAR is designed to store variable-length text, making it suitable for strings of different sizes. INT, on the other hand, is specifically for whole numbers, allowing for efficient storage and calculations with numeric data.
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which data type would you use for storing dates in a database?
DATE
STRING
INTEGER
FLOAT
Answer explanation
The DATE data type is specifically designed to store date values in a database, allowing for proper date manipulation and querying. Other types like STRING, INTEGER, and FLOAT are not suitable for date storage.
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What data type should you choose for a column that stores boolean values (e.g., TRUE/FALSE)?
BOOLEAN
INTEGER
VARCHAR
FLOAT
Answer explanation
The BOOLEAN data type is specifically designed to store true/false values, making it the ideal choice for a column that needs to represent boolean values. Other types like INTEGER or VARCHAR are not suitable for this purpose.
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Activity Question: Given a "Student" table with columns StudentID, Name, EnrollmentDate, and IsActive, choose appropriate data types. Answer: StudentID: INT, Name: VARCHAR, EnrollmentDate: DATE, IsActive: BOOLEAN
StudentID: INT, Name: VARCHAR, EnrollmentDate: DATE, IsActive: BOOLEAN
StudentID: STRING, Name: TEXT, EnrollmentDate: DATETIME, IsActive: INT
StudentID: NUMBER, Name: CHAR, EnrollmentDate: TIMESTAMP, IsActive: STRING
StudentID: INTEGER, Name: STRING, EnrollmentDate: TEXT, IsActive: BOOL
Answer explanation
The correct choice specifies appropriate data types: INT for StudentID (numeric), VARCHAR for Name (variable-length string), DATE for EnrollmentDate (date type), and BOOLEAN for IsActive (true/false).
5.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
In a database, Yes/No, Text and Date/Time are all examples of:
data types
data queries
tabs you can select
records in the data table
Answer explanation
Yes/No, Text, and Date/Time are all examples of data types, which define the kind of data that can be stored in a database. Therefore, the correct answer is 'data types'.
6.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
A data type that can only hold 2 values e.g. Yes/No or True/False.
Boolean
Integer
Real
String
Answer explanation
The correct answer is 'Boolean' because it is a data type that can only hold two values, such as Yes/No or True/False. Other options like Integer, Real, and String can hold multiple values, making them incorrect.
7.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
A data type used for storing numbers with a fractional part e.g. 3.142
Integer
Boolean
Real / Float
String
Answer explanation
The correct answer is 'Real / Float' because it represents data types that can store numbers with fractional parts, such as 3.142. In contrast, 'Integer' stores whole numbers, 'Boolean' stores true/false values, and 'String' stores text.
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever
or continue with

Microsoft
%20(1).png)
Apple
Others
Already have an account?
Similar Resources on Wayground
10 questions
Problem-solving and Program Design Concepts
Quiz
•
11th Grade
10 questions
Quiz Fungsi Agregasi SQL
Quiz
•
11th Grade
10 questions
Quiz Microsoft Excel #1
Quiz
•
10th Grade - University
10 questions
Database Practice Test 1 Part 2 Review
Quiz
•
11th Grade
10 questions
Python Module 2 Section 6 Review
Quiz
•
11th Grade
8 questions
MA3-App Lab Design and Functionality
Quiz
•
9th - 12th Grade
5 questions
Kuis greedy, char + string
Quiz
•
11th Grade
10 questions
Quiz tentang Java
Quiz
•
9th - 12th Grade
Popular Resources on Wayground
7 questions
History of Valentine's Day
Interactive video
•
4th Grade
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
22 questions
fractions
Quiz
•
3rd Grade
15 questions
Valentine's Day Trivia
Quiz
•
3rd Grade
20 questions
Main Idea and Details
Quiz
•
5th Grade
20 questions
Context Clues
Quiz
•
6th Grade
Discover more resources for Information Technology (IT)
18 questions
Valentines Day Trivia
Quiz
•
3rd Grade - University
20 questions
-AR -ER -IR present tense
Quiz
•
10th - 12th Grade
21 questions
Presidents Day Trivia
Quiz
•
6th - 12th Grade
10 questions
Valentine's Day: History and Modern Celebration
Interactive video
•
9th - 12th Grade
11 questions
Valentine's Day Trivia
Quiz
•
8th - 12th Grade
10 questions
Factor Quadratic Expressions with Various Coefficients
Quiz
•
9th - 12th Grade
10 questions
Evaluating Piecewise Functions Practice
Quiz
•
11th Grade
18 questions
Success Strategies
Quiz
•
9th - 12th Grade