Database Course Quiz

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

• Advanced SQL Techniques

• Database Normalization

• Introduction to Relational Databases

• Distributed Database Architectures

Which of the following is NOT a type of relationship in ER diagrams?

• 1:1

• 1:M

• N:M

• M:N

What does ACID stand for in transaction management?

• Accuracy, Consistency, Isolation, Durability

• Atomicity, Consistency, Isolation, Data

• Atomicity, Consistency, Integrity, Durability

• Atomicity, Consistency, Isolation, Durability

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

• SELECT

• INSERT

• UPDATE

• JOIN

What is the purpose of database normalization?

• To enhance data security

• To improve data retrieval speed

• To minimize data redundancy

• To increase data redundancy

Which of the following is a characteristic of distributed databases?

• Single point of failure

• Limited scalability

• Data consistency challenges

• Centralized data storage

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

• Eliminating duplicate columns

• Ensuring all attributes are atomic

• Establishing foreign keys

• Creating indexes

Which SQL function is used to calculate the average value?

• AVG

• COUNT

• MAX

• SUM

What is the main goal of using indexes in SQL?

• To increase data redundancy

• To improve query performance

• To simplify database design

• To enforce data integrity

Which of the following is NOT a type of distributed database architecture?

• Hierarchical

• Centralized

• Client-server

• Peer-to-peer