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
  1. EMBL

  2. Genbank

  3. PDB

  4. Uniprot

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

1Hae is a Protein Data Bank (PDB) identifier. PDB IDs follow a 4-character format (usually 1 number + 3 letters, or similar combinations). EMBL and Genbank are nucleotide databases with different ID formats, and UniProt uses longer alphanumeric codes.

Multiple choice
  1. Entrez

  2. SRS

  3. Google

  4. Bankit

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

Entrez is NCBI's integrated search and retrieval system that provides access to nucleotide sequences, protein sequences, structures, genomes, literature, and other databases. SRS is a different database system, Google is a general search engine, and BankIt is a sequence submission tool.

Multiple choice
  1. Metacyc

  2. Ecocyc

  3. KEGG pathway

  4. UM-BBD

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

MetaCyc is a curated database of metabolic pathways derived from scientific literature, organized around reference pathway maps that represent consensus metabolic knowledge from diverse organisms. Unlike KEGG's species-specific pathways or EcoCyc's E. coli focus, MetaCyc uses generalized reference pathways as its organizing principle.

Multiple choice
  1. Oracle

  2. MS-Access

  3. Mysql

  4. All of the above

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

Ensembl uses MySQL as its primary database system for storing and querying genomic data. Oracle is used by some other bioinformatics resources, MS-Access is not suitable for large-scale databases, and MySQL is the correct choice for Ensembl.

Multiple choice
  1. genbank

  2. uniprot

  3. ensemble

  4. MMDB

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

Ensembl is indeed a comprehensive genome database that provides automatic annotation of large genomes. It's one of the major resources for genomic information, housing extensive annotated data for various species. GenBank is a sequence database, UniProt focuses on proteins, and MMDB is for molecular structures, making Ensembl the correct choice for large-scale genome annotation.

Multiple choice
  1. Entity

  2. System architecture

  3. Relationship

  4. Logical entity relationship

  5. Physical entity relationship

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

This view of the system is defined as a set of structuring rules that allow a system to contain a set of simpler systems each with its own local perspective.

Multiple choice
  1. The UML is a language for modeling

  2. The UML is a language for visualising

  3. The UML is a language for specifying

  4. The UML is a language for constructing

  5. The UML is a language for documenting

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

In UML modeling language, vocabulary and rules focus on the conceptual and physical representation of a system.