ITF+ Flat File vs Relational Database Basics

1. What is an attribute in database terminology?

A column or field in a table

A type of database license

A backup procedure

A security permission level

2. True or False: Third Normal Form (3NF) eliminates transitive dependencies.

True

False

Submit

4. Which advantage do relational databases have over flat files for large datasets?

Better organization, reduced redundancy, and improved query efficiency

They require no technical knowledge to use

They automatically delete outdated records

They eliminate the need for backups

5. True or False: Flat file databases automatically prevent duplicate entries.

True

False

Submit

7. What does a one-to-many relationship represent in a relational database?

One record in a table relates to multiple records in another table

Multiple records must share the same primary key

Data is duplicated across all tables

A table can only have one foreign key

8. True or False: SQL is the standard language for querying relational databases.

True

False

Submit

10. Which statement best describes ACID properties in relational databases?

Atomicity, Consistency, Isolation, Durability—ensure reliable transactions

A system for archiving old database files

A method for encrypting database passwords

Automatic Compression and Indexing Directives

11. What is the primary difference between a flat file database and a relational database?

Flat files store data in single tables; relational databases use multiple linked tables

Flat files are faster; relational databases are slower

Flat files require no normalization; relational databases always require it

Flat files use SQL; relational databases use proprietary languages

12. True or False: Relational databases require a predefined schema before data entry.

True

False

Submit

14. Which normal form eliminates repeating groups and ensures all non-key attributes depend on the entire primary key?

First Normal Form (1NF)

Second Normal Form (2NF)

Third Normal Form (3NF)

Boyce-Codd Normal Form (BCNF)

15. In database terminology, what is a tuple?

A row in a table

A column header

A type of database software

A backup file

16. True or False: A flat file database can efficiently handle complex relationships between multiple data entities.

True

False

Submit

18. What does normalization accomplish in relational databases?

Reduces data redundancy and improves data integrity

Increases the number of tables in a database

Encrypts sensitive information

Automatically backs up all data

19. Which of the following is a disadvantage of flat file databases?

Data redundancy and difficulty maintaining data integrity

They require complex SQL queries

They cannot store text data

They automatically enforce referential integrity

20. In a relational database, what is a primary key?

A column that uniquely identifies each row in a table

The first column in any database table

A password used to access the database

A field that stores the date a record was created

ITF+ Flat File vs Relational Database Basics Quiz

1. What is an attribute in database terminology?

2.

What first name or nickname would you like us to use?

2. True or False: Third Normal Form (3NF) eliminates transitive dependencies.

3. A database schema defines the ____.

4. Which advantage do relational databases have over flat files for large datasets?

5. True or False: Flat file databases automatically prevent duplicate entries.

6. In relational databases, a candidate key is ____.

7. What does a one-to-many relationship represent in a relational database?

8. True or False: SQL is the standard language for querying relational databases.

9. A flat file database is most appropriate for ____.

10. Which statement best describes ACID properties in relational databases?

11. What is the primary difference between a flat file database and a relational database?

12. True or False: Relational databases require a predefined schema before data entry.

13. Referential integrity ensures that ____.

14. Which normal form eliminates repeating groups and ensures all non-key attributes depend on the entire primary key?

15. In database terminology, what is a tuple?

16. True or False: A flat file database can efficiently handle complex relationships between multiple data entities.

17. A foreign key is used to ____.

18. What does normalization accomplish in relational databases?

19. Which of the following is a disadvantage of flat file databases?

20. In a relational database, what is a primary key?