Computer Knowledge
Database Management Systems
5,344 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
-
stack-space
-
session-information
-
private SQL-area
-
sorting area
-
strain area
C
Correct answer
Explanation
Private SQL-area holds information such as bind-variables and runtime-buffers.
-
Data and index files
-
Online redo log files
-
Temp files
-
Archive log files
-
Offline redo log files
B
Correct answer
Explanation
Online redo log files hold the transactional history of the database.
-
data files
-
tablespaces
-
data segments
-
extents
-
data blocks
B
Correct answer
Explanation
The Oracle RDBMS stores data logically in the form of tablespaces.
-
Platform Specific Release Number
-
Component Specific Release Number
-
Major Database Release Number
-
Database Maintenance Release Number
-
Application Server Release Number
E
Correct answer
Explanation
The third number tells about the Application Server Release Number.
-
Regional Data Base Management systems
-
Rational Data Base Management systems
-
Relational Data Base Management Systems
-
Requested Data Base Management systems
C
Correct answer
Explanation
RDBMS stands for Relational Database Management System. It is a type of database management system that stores data in the form of related tables.
-
database
-
record
-
information
-
None of these
A
Correct answer
Explanation
End-user query tools are specifically designed to allow users to retrieve and manipulate data stored within a database.
-
Open data
-
Linked data
-
Wikidata
-
Primary data
-
Tertiary source of data
A
Correct answer
Explanation
Open data is the idea that certain data should be freely available to everyone to use and republish as they wish, without restrictions from copyright, patents or other mechanisms of control.
-
a comprehensive integration collection of data about data
-
a dictionary or algorithm for obtaining the address of logical records on a storage device
-
the relationship among the different fields of data in a secondary storage
-
none of these
A
Correct answer
Explanation
A data dictionary is a centralized repository of information about data, such as meaning, relationships to other data, origin, usage, and format.
-
separate management from work
-
promote decentralised and end user computing
-
facilitate transmission of files across continents
-
eliminate data redundancy
D
Correct answer
Explanation
A Database Management System (DBMS) is designed to organize data efficiently, and one of its primary functions is to reduce or eliminate data redundancy.
-
database
-
program
-
information
-
query
C
Correct answer
Explanation
Data that has been processed, organized, and manipulated by a program to become meaningful and understandable is referred to as information. Raw data becomes useful information after processing. Therefore, option C is correct.
A
Correct answer
Explanation
A query is a database object used to retrieve, filter, and manipulate data from one or more tables based on specific criteria.
-
Conceptual view
-
Internal view
-
External view
-
None of the above
D
Correct answer
Explanation
All of the above are view levels of database.
-
Hierarchy schema
-
Network schema
-
Relational schema
-
All of the above
A
Correct answer
Explanation
Top to bottom approach is used in hierarchial schema because it basically is based on Parent and Child Relationship. The parent and child relationship type has basically 1 : N relationship.
-
By rollback of transaction
-
By locking up the data
-
Projection
-
None of the above
A
Correct answer
Explanation
There are few methods to get recovery of documents from deadlock. These are commit, rollback or abort.
-
index
-
instance
-
view
-
none of the above
B
Correct answer
Explanation
Instance is a collection of the information stored in a database at a particular moment.