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
-
Transaction log
-
Query language
-
Report writer
-
Data manipulation language
A
Correct answer
Explanation
Transaction log is a history of actions executed by a DBMS to guarantee ACID properties over crashes or hardware failures.
-
Network model
-
Object oriented model
-
Object based
-
E-R model
A
Correct answer
Explanation
The Network model is a record-based logical data model that organizes data in a graph structure with records as nodes and relationships as edges. The Object-oriented model is object-based, not record-based. The E-R model is a conceptual modeling tool, not a logical model. Object-based is a category, not a specific model.
-
4th Dimension
-
Foxpro
-
D base-IV
-
All of the above
-
Physical
-
Logical
-
View
-
None of above
C
Correct answer
Explanation
Data abstraction has three levels: Physical (lowest), Logical (middle), and View (highest). The View level provides the highest level of abstraction by showing users only the data they need without exposing underlying structures. It simplifies data access by hiding complexity.
-
Fortran
-
Autoflow
-
BPL
-
Total
-
Internal schema
-
Conceptual schema
-
User schema
-
Logical schema
A
Correct answer
Explanation
Internal schema or physical schema define how and where data are stored or organized in a physical data storage.
-
Client
-
Database server
-
Global coordinator
-
Local coordinator
-
Commit point site
B
Correct answer
Explanation
This object in distributed database receives a request for information from another node.
-
Appletviewer
-
ODBC
-
JDBC
-
None of these
C
Correct answer
Explanation
This is a Java tool that provides a database programming interface for Java programs.
-
Only 1
-
Only 2
-
Both 1 and 2
-
Neither 1 nor 2
B
Correct answer
Explanation
MIS (Management Information Systems) handles structured, routine decisions using predefined reports and data - it's NOT designed for unstructured problems. DSS (Decision Support Systems) specifically addresses unstructured decisions through analytical models, what-if analysis, and specialized databases. Statement 2 correctly describes DSS architecture.
-
Process control block
-
Process management
-
Process
-
Accounting info
-
Process number
A
Correct answer
Explanation
It is a data structure that contains all the information about a process within an operation system.
-
TIGRFAMs database
-
Pfam database
-
ProDom database
-
Kyoto database
-
MUMmer database
C
Correct answer
Explanation
The ProDom database contains protein domain families generated from the UniProtKB database by automated sequence comparisons.
-
1 and 2
-
1 and 3
-
2 and 3
-
2 and 4
-
3 and 4
D
Correct answer
Explanation
Correct answer. Secondary databases contain results from the analysis of sequences in the primary databases. Examples of secondary databases are PROSITE and Pfam.
-
BioGRID
-
TRANSFAC
-
PDB
-
TrEMBL
-
Pfam
A
Correct answer
Explanation
Correct answer. The Biological General Repository for Interaction Datasets (BioGRID) is a curated biological database of protein-protein and genetic interactions.
-
BOINC
-
SIMAP
-
TreeFam
-
InterPro
-
ModBase
C
Correct answer
Explanation
Correct answer. TreeFam is a database of evolutionary trees of animal genes which aims at developing a curated resource that gives reliable information about ortholog and paralog assignments, and evolutionary history of various gene families.
-
Repository
-
Data warehouse
-
RAD
-
CASE
B
Correct answer
Explanation
A data warehouse is a centralized repository that stores all information collected during database development, designed for query, analysis, and reporting. A repository typically stores metadata, RAD is a methodology, and CASE is a category of development tools.