Database Fundamentals Assessment

What is the primary purpose of data in a database system? a. To provide context b. To store raw facts c. To eliminate redundancy d. To create relationships

• To ensure data security

• b. To store raw facts

• To enhance data visualization

• To facilitate data entry

Which of the following is an example of metadata? a. A student's grade b. The size of a document file c. A student's name d. A music file's album name

• The date a document was created

• d. A music file's album name

• The content of a music file

• A student's attendance record

Which of these is NOT a characteristic of information? a. Processed Data b. Meaningful c. Relevance d. Raw facts

• e. Unprocessed Data

• f. Structured Information

• d. Raw facts

• g. Contextual Data

A collection of related records in a database is called: a. Field b. Table c. File d. Entity

• b. Table

• Database

• Record

• Column

What does the DBMS ensure in terms of data consistency? a. Redundancy b. Isolation c. Transactions are always consistent d. Faster queries

• a. Data is always duplicated

• b. All queries are executed simultaneously

• d. Data is stored in multiple locations

• c. Transactions are always consistent

Which of the following is NOT a DBMS function? a. Data integrity b. Redundancy control c. Data retrieval optimization d. Data visualization

• d. Data visualization

• Data encryption

• Backup management

• User authentication

What does ACID in DBMS stand for? a. Atomicity, Consistency, Isolation, Durability b. Allocation, Consistency, Isolation, D

• Atomicity, Consistency, Isolation, Distribution

• Atomicity, Consistency, Integrity, Durability

• Atomicity, Clarity, Isolation, Durability

• Atomicity, Consistency, Isolation, Durability

Which of the following is a type of database model? a. Hierarchical b. Linear c. Circular d. Random

• Flat

• Network

• a. Hierarchical

• Matrix

What is the role of a primary key in a database? a. To store large amounts of data b. To uniquely identify a record c. To create relationships d. To ensure data integrity

• To encrypt sensitive data

• b. To uniquely identify a record

• To store metadata about the database

• To index the database for faster searches

Which SQL command is used to retrieve data from a database? a. SELECT b. GET c. FETCH d. RETRIEVE

• QUERY

• PICK

• a. SELECT

• LOAD