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 not true about data dictionary in software engineering?

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

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

  3. It provides the relationship between the entities.

  4. It describes the database or collection of databases.

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

All of the above are true statements.

Multiple choice

Which of the following is the role of system administrator?

  1. Verification/validation of the data

  2. Installation, configuration and maintain the database

  3. Develop a plan to back up the database and recovery routines

  4. All of the above

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

Yes, all of the above are the roles of a system administrator.

Multiple choice

Which of the following statement(s) is/are false?

  1. Data Flow Diagram shows the data transfer between the entities in the system.

  2. A DFD shows a lower level view of the system.

  3. DFD is made by a software analyst of designer.

  4. DFD shows the functionality of the system.

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

This is a false statement as a DFD shows a higher level view of a system as it shows the actual transfer of the data in the system whereas a flow chart shows a lower level view of the system as it shows only the data transfer activities in the system and not the transfer of the data.

Multiple choice

Which of the following statement(s) is/are false?

  1. A physical DFD is used to describe the set of items that appears in each level.

  2. A physical DFD can have duplicate or redundant data.

  3. A logical DFD can not have duplicate data or redundancy.

  4. A logical DFD shows the data flows to operate the system.

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

Yes, all of the above are the true statements.

Multiple choice

Which of the following statements is false regarding ER Model?

  1. It is an abstract way of describing a database.

  2. It uses a three schema approach to software engineering.

  3. Conceptual data model is the lowest level ER model.

  4. An entity is an abstraction from the complexities of a domain.

  5. Entities and relationships can both have attributes.
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

This is the highest level ER model in that it contains the least granular detail but establishes the overall scope of what is to be included within the model set. The conceptual ER model normally defines master reference data entities that are commonly used by the organization.

Multiple choice

Which one of the following does not come under the classification of databases on the basis of types of data?

  1. Nucleotide sequence

  2. Protein sequence

  3. Primary databases

  4. Metabolic pathway

Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Biological databases are classified by data type (nucleotide sequences, protein sequences, metabolic pathways) OR by curation level (primary, secondary, tertiary). 'Primary databases' describes the curation level, not the type of data stored, making C the correct answer as it does NOT fit 'classification by data type'.

Multiple choice

Which of the following is a literature database?

  1. GEO

  2. PubMed

  3. EST

  4. MMDB

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

PubMed is the premier biomedical literature database indexing millions of journal articles from life sciences journals. GEO (Gene Expression Omnibus) stores functional genomics data, EST refers to Expressed Sequence Tags, and MMDB contains 3D molecular structures - none of these are literature databases.