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
-
Data structure
-
Data flows and data stores
-
Data element
-
None of the above
C
Correct answer
Explanation
Data element is the smallest unit of data because it will not provide further decomposition.
-
Data bank
-
Folder or Directory
-
Meta Data
-
None of these
C
Correct answer
Explanation
Meta Data is termed as data about data.
D
Correct answer
Explanation
DML means Data Manipulation Language, is used to specify database updates and retrievals like INSERT, SELECT, UPDATE and more.
-
distinct table
-
hierarchy table
-
virtual table
-
all of above
C
Correct answer
Explanation
We can also call a view a virtual table because view is a personalized and customized collection of relation formed by using view. View secures the original table and provides us an user requirement table view.
-
Entity relationship model
-
Object oriented model
-
Relational model
-
None of these
C
Correct answer
Explanation
Relational model has inter-related records. In this model, records have relationships.
-
Non-procedural query language
-
Data definition language
-
Procedural query language
-
None of these
C
Correct answer
Explanation
Relational Algebra is a procedural query language because it describes the procedure to obtain the output and result.
-
serialization
-
read
-
both (1) and (2)
-
none of these
B
Correct answer
Explanation
Read only does not allow insert , alter and delete once the transaction is completed, so no modification is made.
-
Starvation
-
Join dependency
-
Weak entity set
-
None of these
A
Correct answer
Explanation
Starvation in database is called as poor constructed database, as well as a transaction which never completes its given task.
-
Shared
-
Exclusive
-
Update
-
Schema
B
Correct answer
Explanation
It is used for data modification purpose, therefore it is used to maintain the serializability.
-
Spooling
-
Concurrency control
-
Shadow paging
-
None of these
C
Correct answer
Explanation
The recovery from transaction failure is done by shadow paging.
-
The entry contains the search key and a pointer in the first data record with that search key value.
-
Adding other extra overheads
-
This index entry is not created for every value.
-
None of these
A
Correct answer
Explanation
Dense index is an entry which contains the search key and a pointer in the first data record with that search key value.
-
Commit
-
Set transaction
-
Rollback
-
All of these
C
Correct answer
Explanation
Rollback is a TCL statement which is used to resolve the problems of Dead lock and recovery of transaction.
-
data retains information in it
-
similar concepts
-
the information is generated from data
-
none of the above
C
Correct answer
Explanation
In computing, data refers to raw facts and figures, while information is the processed, organized, and meaningful output derived from that data.
-
data storage
-
data retrieval
-
data communication
-
all of the above
D
Correct answer
Explanation
Information Technology (IT) encompasses the entire spectrum of managing data, including its storage, retrieval, and communication across systems.
-
a document of what has to be accomplished
-
a statement of information processing requirement
-
a hierarchical partitioning of the program
-
none of the above
C
Correct answer
Explanation
A structure chart is a design tool that represents the hierarchical organization of modules in a program, showing the relationship and data flow between them.