Fundamentals of Database Quiz

What is Data?

• Raw facts, figures, and details collected from various sources.

• Processed and organized data that has meaning.

• A collection of related data, stored digitally.

• Software that manages databases.

What is Information?

• Raw facts, figures, and details collected from various sources.

• Processed and organized data that has meaning.

• A collection of related data, stored digitally.

• Software that manages databases.

What is a Database?

• Raw facts, figures, and details collected from various sources.

• Processed and organized data that has meaning.

• A collection of related data, stored digitally.

• Software that manages databases.

What is Data Modeling?

• The process of creating a model for a given problem domain.

• A graphical abstraction representing real-world data structures.

• Refers to the implementation of a data model in a specific database system.

• Data is stored in tables with unique names.

What is Normalization?

• The process of organizing data in a database to reduce redundancy.

• A method to ensure data integrity.

• A way to create relationships between tables.

• A technique for data retrieval.

What must be in a Normal Form?

• Each table represents a single subject.

• Each intersection of rows and columns contains only one value.

• No data should be unnecessarily stored in more than one table.

• All of the above.

What is COUNT()?

• Counts the number of rows in a table.

• Returns the smallest value in a set of values.

• Returns the largest value in a set of values.

• Calculates the average of a set of values.

What is MIN()?

• Counts the number of rows in a table.

• Returns the smallest value in a set of values.

• Returns the largest value in a set of values.

• Calculates the average of a set of values.

What is MAX()?

• Counts the number of rows in a table.

• Returns the smallest value in a set of values.

• Returns the largest value in a set of values.

• Calculates the average of a set of values.

What is the primary purpose of data in a database system?

• To provide context

• To store raw facts

• To eliminate redundancy

• To create relationships