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
-
Object model
-
Object definition language
-
Object interchange format
-
Object query language
-
Access mode
C
Correct answer
Explanation
This determines how the various objects are represented for exchanging them between different OODBMS.
-
Data fragmentation
-
Distributed database
-
Distributed transaction
-
Distributed transaction coordinator
-
Homogeneous database
E
Correct answer
Explanation
Homogeneous database simplifies the data sharing between different users.
-
Recoverability
-
Transaction
-
Serialisability
-
Workflow systems
-
Online transaction processing system
C
Correct answer
Explanation
Serialisability is the main criterion for the accuracy of simultaneous transaction executions and a main objective for concurrency control.
-
3, 4, 1, 2
-
4, 3, 1, 2
-
3, 4, 2, 1
-
None of the above
B
Correct answer
Explanation
The correct JDBC sequence is: 1) Register Driver, 2) Get Connection, 3) Create Statement, 4) Execute Query. First, you register the JDBC driver, then establish a connection to the database, create a statement object, and finally execute the SQL query.
-
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.
-
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.
-
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.