RDBMS basics

1. Which of the following is not a purpose of using a database management system (DBMS)?

• A. Redundancy control

• B. Data inconsistency

• C. Efficient data access

• D. Data security

In a two-tier database architecture, which component resides at the client machine?

A.

• A) Query processor

• B) Database system functionality

• C) Application program

• D) Disk storage

3. Who is responsible for granting access rights to users in a DBMS?

• A. Application Programmer

• B. End User

• C. Database Administrator (DBA)

• D. System Analyst

4. The level that provides only part of the entire database for user interaction is the:

• A. Physical level
  

• B. Logical level
  

• C. View level
  

• D. Internal level

5. Which of the following is concerned with removing data redundancy and anomalies in database design?

• A. Indexing
  

• B. Normalization
  

• C. ER Modeling
  

• D. Aggregation

6. Which ACID property ensures that all operations of a transaction are completed or none at all?

• A. Atomicity
  

• B. Consistency
  

• C. Isolation
  

• D. Durability

7. The ACID property that ensures the database remains in a valid state after a transaction is:

• A. Atomicity
  

• B. Consistency
  

• C. Durability
  

• D. Concurrency

8. Which of the following is not an example of a database application?

• A. ATM system
  

• B. Online shopping portal
  

• C. Compiler
  

• D. Student registration system

9. 9. What is a major disadvantage of storing the same data in multiple files?

• A) Faster access
  

• B) Data redundancy
  

• C) Stronger security
  

• D) Improved accuracy

10. 10. What is a major consequence of data isolation in traditional file systems?

• A) Faster retrieval of related data
  

• B) Easier data analysis
  

• C) Difficulty in retrieving data across multiple files
  

• D) Better data security