Database Course Flashcard

Front

What is the primary focus of Module 1 in the database course?

Back

Introduction to Relational Databases

Front

Which of the following is NOT a type of relationship in ER diagrams? 1:1, 1:M, N:M, M:N

Back

N:M

Front

What does ACID stand for in transaction management?

Back

Atomicity, Consistency, Isolation, Durability

Front

Which SQL operation is used to combine rows from two or more tables?

Back

JOIN

Front

What is the purpose of database normalization?

Back

To minimize data redundancy

Front

Which of the following is a characteristic of distributed databases? Single point of failure, Limited scalability, Data consistency challenges, Centralized data storage

Back

Data consistency challenges

Front

What is the first normal form (1NF) concerned with?

Back

Ensuring all attributes are atomic

Front

Which SQL function is used to calculate the average value?

Back

AVG

Front

What is the main goal of using indexes in SQL?

Back

To improve query performance

Front

Which of the following is NOT a type of distributed database architecture?
Options: Centralized, Client-server, Peer-to-peer

Back

Hierarchical