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

Manager’s salary details are hidden from the employee. This is

  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

AI Explanation

To answer this question, we need to understand the concept of data hiding in the context of database management.

Option A) Conceptual level data hiding - This option is incorrect. Conceptual level data hiding refers to hiding the internal details and complexities of a database from the end-users. It is not directly related to hiding specific salary details from employees.

Option B) Physical level data hiding - This option is incorrect. Physical level data hiding refers to hiding the physical storage details and implementation specifics of a database from the end-users. It is also not directly related to hiding specific salary details.

Option C) External level data hiding - This option is correct. External level data hiding refers to hiding specific data elements or attributes from certain users or user groups. In this case, the manager's salary details are hidden from the employee, which is an example of external level data hiding.

Option D) All of these - This option is incorrect. While it is true that data hiding can occur at multiple levels (conceptual, physical, and external), the given scenario specifically relates to external level data hiding.

Option E) None of these - This option is incorrect. As explained above, the correct answer is Option C, which represents external level data hiding.

Therefore, the correct answer is C) External level data hiding.

  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

What is the full form of ACID?

  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

The most open source DBMS.

  1. Microsoft SQL Server.

  2. Microsoft Access.

  3. MySQL.

  4. Oracle.


Correct Option: C
  1. 2-tier system.

  2. 3-tier system.

  3. 4-tier system.

  4. N-tier system.


Correct Option: B