Tag: rdbms

Questions Related to rdbms

  1. Eliminate redundancy.

  2. Improve security.

  3. Improve efficiency.

  4. Minimize Errors.


Correct Option: A
Explanation:

Normalization of a database is used to eliminate redundancy and improve efficiency.

A. Eliminate redundancy: This option is correct. One of the main goals of database normalization is to eliminate or reduce redundancy in order to improve data consistency and reduce storage requirements. Redundancy can lead to data inconsistencies and inefficiencies in data management.

B. Improve security: This option is not directly related to normalization. While normalization can indirectly improve security by ensuring data integrity and reducing the risk of data inconsistencies, it is not its primary purpose.

C. Improve efficiency: This option is correct. Normalization helps improve the efficiency of data storage, retrieval, and manipulation operations by organizing data into properly structured tables and reducing data redundancy. This can lead to faster and more efficient query execution.

D. Minimize errors: This option is partially correct. Normalization can help minimize errors by reducing redundancy and ensuring data consistency. However, it is not its sole purpose, as efficiency and elimination of redundancy are also important goals.

Therefore, the correct answer is:

A. Eliminate redundancy.

  1. Key dependencies.

  2. Relation dependencies.

  3. Database dependencies.

  4. All of these.

  5. None of these.


Correct Option: A
  1. Conceptual level data hiding.

  2. Physical level data hiding.

  3. External level data hiding.

  4. All of these.

  5. None of these.


Correct Option: C
  1. Is made up of a several pieces of information.

  2. Uniquely identifies an item in a list.

  3. Is a combination of each unique key.

  4. Both (a) and (b).

  5. Both (c) and (b).


Correct Option: D
  1. Data elements.

  2. Records & files.

  3. Record relationships.

  4. All of these.

  5. None of these.


Correct Option: D
  1. Spread sheet program.

  2. Word processor program.

  3. Graphics program.

  4. All of these.

  5. None of these.


Correct Option: D
  1. Atomicity, Constant, Isolation, Durability.

  2. Atomicity, Consistency, Isolation, Duration.

  3. Atomicity, Consistency, Isolation, Durability.

  4. Atomicity, Consistency, Indexing, Durability.

  5. Atomicity, Constant, Indexing, Durability.


Correct Option: C
  1. Scalable.

  2. Robust.

  3. Platform independent.

  4. Distributed.


Correct Option: C
  1. Microsoft SQL Server.

  2. Microsoft Access.

  3. MySQL.

  4. Oracle.


Correct Option: C

An enterprise solution with data storage, a client interface and a security system is

  1. 2-tier system.

  2. 3-tier system.

  3. 4-tier system.

  4. N-tier system.


Correct Option: B