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
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.
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.
-
Metacyc
-
Ecocyc
-
KEGG pathway
-
UM-BBD
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.
-
Oracle
-
MS-Access
-
Mysql
-
All of the above
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.
-
genbank
-
uniprot
-
ensemble
-
MMDB
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.
-
3-D Models
-
Wireframe
-
Matrix
-
Textual - for example, stories that summarize specific information
-
Diagrams
E
Correct answer
Explanation
Diagrams may be used to depict how data flows from one structure to the other.
-
Temporal cohesion
-
Procedural cohesion
-
Communicational cohesion
-
Logical cohesion
-
Coincidental cohesion
C
Correct answer
Explanation
Communicational cohesion is when parts of a module are grouped because they operate on the same data (e.g. a module which operates on the same record of information).
-
Common coupling
-
External coupling
-
Control coupling
-
Data coupling
-
Pathological coupling
A
Correct answer
Explanation
Common coupling (also known as Global coupling) occurs when two modules share the same global data (e.g., a global variable). Changing the shared resource implies changing all the modules using it.
-
OMT dynamic model
-
OMT functional model
-
Object model
-
Use-case model
-
Test model
C
Correct answer
Explanation
This model describes the structure of objects in a system, their identity, relationships to other object attributes and operations.
-
Transaction_read_uncommitted
-
Transaction_read_committed
-
Transaction_repeatable_read
-
Transaction _Synchronous
-
None of these
D
Correct answer
Explanation
Actually Transaction _Synchronous is a synchronous process and not a transaction isolation level in EJB.
-
Context diagram
-
Data dictionary
-
Structured query language
-
Data flow diagram
-
Structure chart
C
Correct answer
Explanation
The structured query language (SQL) is a standardized language for querying information from a database.
-
good()
-
rdstate()
-
clear()
-
isstate()
A
Correct answer
Explanation
The member function good() is used to check whether the state of the stream for input/output operation is good or not.
-
Entity
-
System architecture
-
Relationship
-
Logical entity relationship
-
Physical entity relationship
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.
-
The UML is a language for modeling
-
The UML is a language for visualising
-
The UML is a language for specifying
-
The UML is a language for constructing
-
The UML is a language for documenting
A
Correct answer
Explanation
In UML modeling language, vocabulary and rules focus on the conceptual and physical representation of a system.
-
Stereotype
-
Specification
-
Tagged value
-
Class diagram
-
Constraints
B
Correct answer
Explanation
UML specification provides a semantic backplane that contains all the parts of all the models of a system and each part is related to one another in a consistent fashion.