Computer Knowledge

Database Management Systems

5,543 Questions

Database Management Systems (DBMS) form the core framework for data storage, retrieval, and security in modern software applications. Concepts such as the E-R model, backup planning, SQL integration, and big data architecture are essential for computer knowledge sections. This hub offers a comprehensive set of practice questions to master DBMS fundamentals and advanced database operations.

E-R Model ConceptsBackup and RecoverySQL Server UpgradesJDBC and ODBCBig Data CharacteristicsData VirtualizationOracle Database

Database Management Systems Questions

Multiple choice

Which of the following is the incorrect statement in relational database design process?

  1. Specialization is used for the subgrouping of entities in relationship sets.

  2. Specialization have a bottom up manner approach in its relationship among entities.

  3. For generalization there should be some common attribute among the entities.

  4. Generalization maintains relationship among higher level entity set and one or more lower level entity sets.

  5. None of the above
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

This is false statement as it is used to subgroup the top level entities.

Multiple choice

Consider the following scenario-An entity 'Train' is further classified in to two sub-entities, i.e., 'Passenger' and 'Goods', then which of the following statement is/are true?

  1. The 'Train' possesses a generalization approach.

  2. 'Passenger' train and 'Goods' train possesses a specialization approach.

  3. The 'Train' also possess aggregation approach.

  4. All of the above.

  5. Both (1) and (2).
Reveal answer Fill a bubble to check yourself
E Correct answer
Explanation

These are the correct statements.

Multiple choice

Which of the following is false about dependency preservation and non-additive join property in relational database?

  1. The non-additive property is very critical in relation database.

  2. Dependency preservation ensures that each functional dependency is represented in individual relations after decomposition.

  3. Dependency preservation is not a necessary process in relational database.

  4. None of these
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

All of the above statements are true. All of the above statements are true.

Multiple choice

Which of the following is not true about data dictionary in software engineering?

  1. It describes the database or collection of databases.

  2. It contains the representation and definition of the data elements.

  3. It provides the relationship between the entities.

  4. It is created during the requirement analysis phase in SDLC (Software Development Life Cycle).

  5. None of these
Reveal answer Fill a bubble to check yourself
E Correct answer
Explanation

All of the above are true statements.