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
-
processing it into data
-
making decisions
-
to be fast
-
All of the above
B
Correct answer
Explanation
Information is processed data that provides context and meaning, which is essential for making informed decisions in organizations and daily life.
-
Indexed file
-
Command file
-
Archive file
-
Parameter file
-
Indexed sequential file
E
Correct answer
Explanation
In this file, an overflow area needs to be maintained to permit insertion in sequence.
-
Indexed file
-
Parameter file
-
Direct file
-
Command file
-
Password file
C
Correct answer
Explanation
This file offers an effective way to organize data when there is a need to access individual records randomly.
-
The application level
-
The abstract level
-
Storage structure
-
RAID level 0
-
Multi set
A
Correct answer
Explanation
In this specification of data structure, the user is modeling real life data in a specific context.
-
Complication in implementation
-
Structural reliance
-
Database integrity
-
Hardware expense
-
None of these
C
Correct answer
Explanation
This is an advantage of the hierarchical data model as it is based on inbuilt structure of parent and child relationship.
-
Data model
-
Database client
-
Database server
-
Network data model
-
Database
B
Correct answer
Explanation
The machine which is utilised for running user interface is considered as database client.
-
Based on the number of users
-
Based on the number of sites
-
Based on cost
-
Based on purpose
-
Based on data model
E
Correct answer
Explanation
This criterion is most extensively accepted for the classification of a database.
-
Local-read protocol
-
Local transactions
-
Global-read protocol
-
Global transactions
-
Primary-copy locking
C
Correct answer
Explanation
It can read, but cannot perform updation of local data items.
-
Adaptive query processing in data grid
-
Adaptive query processing in internet applications
-
Adaptive query processing in web-based data integration
-
Adaptive query processing in wide area database systems
-
Detecting and correcting optimiser
A
Correct answer
Explanation
Adaptive query processing is essentially used by data grids to offer better quality of service (QoS) to users and applications, inspite of dynamically changing resources and environments.
-
DBA
-
CODASYL
-
IMS
-
ODBMS
-
ERP
C
Correct answer
Explanation
Integrated Management System is a concept that offers the information needed to handle organisations in an efficient and effective manner.
-
Write-ahead
-
Redundant transaction logs
-
Database buffer
-
Deferred-write and deferred-update
-
Write-through
D
Correct answer
Explanation
Deferred-write and deferred-update are used by the recovery process when the transaction operations do not update the physical database instantly.
-
Personal database
-
Two-tier client/server database
-
Multi-tier client/server database
-
Enterprise application
-
Enterprise resource planning
A
Correct answer
Explanation
Personal database is prepared for assisting one client and offers him some quality of data proficiency.
-
recovery schedule
-
managing rollback using locking
-
deadlock detection by timeout
-
cascading rollback
-
view serialisability
D
Correct answer
Explanation
On the failing of a transaction, the system is required to return to the situation that it was in before the transaction was initiated. It is called as cascading rollback.
-
Object server approach
-
Page server approach
-
File server approach
-
Object clustering
-
Heterogeneous operation
C
Correct answer
Explanation
In this approach, the client processors of OODBMS have an interaction with a network file service for reading and writing database pages.
-
B-tree index
-
Concurrency control
-
Database element
-
Database recovery
-
Scheduler
A
Correct answer
Explanation
It keeps data sorted and allows searches, sequential access, insertions and deletions in logarithmic time.