Database Concepts Quiz

What type of database model organizes data in tables with rows and columns?

• Hierarchical

• Network

• Relational

• Object-Oriented

In a database, what is a unique identifier for each record in a table called?

• Primary key

• Secondary key

• Foreign key

• Index key

Which SQL statement is used to retrieve data from a database?

• UPDATE

• DELETE

• INSERT

• SELECT

What is the purpose of normalization in a database?

• Increase data redundancy

• Optimize query speed

• Reduce data redundancy

• Improve data security

Which of the following is not a characteristic of a good database design?

• Data integrity

• Data redundancy

• Scalability

• Efficiency

Which data type is used in SQL to store true or false values?

• INT

• BOOLEAN

• VARCHAR

• FLOAT

In SQL, which data type is best suited for storing large texts such as articles or comments?

• TEXT

• VARCHAR

• CHAR

• BLOB

Which SQL data type is used to store numerical values with fixed precision and scale?

• DECIMAL

• INTEGER

• DATE

• VARCHAR

In SQL, what is the difference between CHAR and VARCHAR data types?

• CHAR is fixed length, VARCHAR is variable length

• CHAR is variable length, VARCHAR is fixed length

• No difference

• VARCHAR is used only for numeric data

What data type would you use in SQL to store a date and time value together?

• DATETIME

• DATE

• TIME

• TIMESTAMP