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
-
jamming
-
password
-
documentation
-
record lock
D
Correct answer
Explanation
Record locking is a concurrency control mechanism that prevents conflicting simultaneous updates to the same database record. When one user acquires a lock on a record, other users must wait until the lock is released before they can modify that record. This prevents lost updates and ensures data integrity in multi-user database environments.
-
fields and columns
-
rows and columns
-
rows and cells
-
none of the above
B
Correct answer
Explanation
In relational database terminology, a table is organized as rows (also called tuples or records) and columns (also called attributes or fields). Each row represents a single complete entity or record, while each column represents a specific attribute or field that all records possess. This two-dimensional structure is the foundation of relational databases.
-
Caching
-
Stratification
-
Temporary intercession
-
Function proxy
-
NIO
A
Correct answer
Explanation
In this technique, it would not be necessary to connect to the remote server next time that the document is requested, because it stores the retrieved document in a local file.
-
MangoDB v.1.8.0
-
Google bigtable
-
CouchDB
-
Wuala
-
Google app engine
B
Correct answer
Explanation
This data store includes web indexing, Google earth and Google finance.
-
Electronic filling
-
Polynomial
-
Effective enumeration
-
All of the above
A
Correct answer
Explanation
Electronic filing (misspelled as 'filling' in the options) refers to the digital storage and management of documents, allowing for easy organization and retrieval. It replaces traditional paper-based filing systems.
-
File processing
-
Database
-
Front-end-processor
-
Direct processing
A
Correct answer
Explanation
File processing refers to the systematic manipulation of data files, including updating a master file with new transaction data. This ensures that the permanent records (master files) accurately reflect the current state of the business or system.
-
Field
-
Bead
-
Database
-
Data collection
B
Correct answer
Explanation
In early computer science and list-processing terminology, a 'bead' refers to a record or a component of a data structure that can contain fields or pointers to other similar structures. This term is historical and rarely used in modern programming.
-
Data acquisition
-
Data bank
-
Database system
-
Database
B
Correct answer
Explanation
A data bank is a large repository of information on a specific subject, often compiled from multiple sources. While the term database is more common in modern technical contexts, data bank specifically emphasizes the collection of data for a particular topic or field. Data acquisition refers to the process of gathering data, not the storage itself.
-
DB2 XML
-
SQL/XML
-
Sarissa
-
Scriptaculous
-
Schema
B
Correct answer
Explanation
SQL/XML is a way to publish XML as an ANSI and ISO standard that provides support for using XML in the context of a relational database management system.
-
Static member
-
PHP session
-
HMAC verification
-
Session memory
-
EnableSession
B
Correct answer
Explanation
It allows an application to store information for the current session.
-
hierarchical
-
relational
-
network
-
distributed
-
IMS
B
Correct answer
Explanation
This data model in DBMS makes use of a set of tables to show data as well as the relationship between the data.
-
Vertical fragmentation
-
Horizontal partitioning
-
Summary data
-
Duplicate data
-
Functional dependency
C
Correct answer
Explanation
This is the technique used for denormalisation in which the records are summarised in some summary columns. It reduces the number of records stored in a table.
-
Distribution
-
Transaction
-
Failure
-
Heterogeneity
-
Homogeneity
B
Correct answer
Explanation
This type of transparency in distributed DBMS permits a transaction to be executed either completely or not at all.
-
Object database
-
Dimensional
-
Post-relational database
-
Network data
-
Hierarchical data
B
Correct answer
Explanation
This model is a specialised adaption of the relational model. It is used to represent data in a data warehouse in a way that data can be easily summarised using OLAP queries.
-
Mixed fragmentation
-
Horizontal fragmentation
-
Vertical fragmentation
-
Data processor
-
Distributed data storage
C
Correct answer
Explanation
This type of operation on database can be acquired by dividing a table into a number of sub-tables having disjointed columns.