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 warehousing
-
clustering
-
data mining
-
sniffing
D
Correct answer
Explanation
Data mining involves searching of patterns and relations in stored databases. It is used to find the strategic information hidden in a data warehouse.
-
network data model
-
relational data model
-
ER model
-
IDMS
-
Sybase
C
Correct answer
Explanation
The entity-relationship model is the most popular object-based logical model. It is used to portray data at the conceptual and the view levels.
-
Oracle
-
Sybase
-
MySQL
-
SQL server
-
Ingres II
C
Correct answer
Explanation
MySQL is an open source RDBMS package. All the other RDBMS packages are patented softwares.
-
data management
-
authorisation
-
security auditing
-
securitisation
-
None of these
C
Correct answer
Explanation
Security auditing is the process of evaluating system reports to find whether the system is according to the standard security norms or not. It includes collection of information like user’s access activities, resource access, etc.
-
Oracle
-
Dot net
-
Sybase
-
Informix
-
DDL
B
Correct answer
Explanation
Except dot net, all others are RDBMS packages. Dot net is a programming language.
-
make the operational data dynamic
-
facilitate insertion, deletion and updation of data
-
store the data at microscopic level
-
reduce the response time of the system
-
facilitate queries and analysis
B
Correct answer
Explanation
OLTP stands for 'on line transaction processing'. In it, normalisation of database is done to facilitate insertion, deletion and updation of data.
-
Oracle
-
Microsoft
-
Dell
-
IBM
-
Intel
B
Correct answer
Explanation
SQL server is a product of Microsoft.
-
End user - SQL - Application program - DBMS - OS - Database
-
End user - Application program - SQL - OS - DBMS - Database
-
End user - Application program - SQL - DBMS - OS - Database
-
End user - Application program - SQL - DBMS - Database - OS
-
End user - Application program - DBMS - SQL - OS - Database
C
Correct answer
Explanation
The order for DBMS interface is: End user - Application program - SQL - DBMS - OS - Database.
-
DBMS
-
RDBMS
-
Folders
-
File manager
-
Files
C
Correct answer
Explanation
The arrangement of bookmarks can be done by using folders.
-
Subject orientation
-
Time invariant
-
Non-volatile
-
Static
-
Integrated form
B
Correct answer
Explanation
Data warehousing is a method of collection and storage of data so as to facilitate efficient data analysis and decision making.
-
tables
-
rows
-
relations
-
Both 1 and 2
-
Both 1 and 3
A
Correct answer
Explanation
RDBMS is based on relational model. It arranges the data in tables by finding relations between them.
-
Stereotype
-
Specification
-
Tagged value
-
Class diagram
B
Correct answer
Explanation
UML specification provides a semantic backplane that contains all the parts of all the models of a system and each part is related to one another in a consistent fashion.
-
Partially aborted
-
Partially committed
-
Aborted
-
Committed
-
Rollback
A
Correct answer
Explanation
Transaction cannot be partially aborted.
-
update the transaction
-
repeat a transaction
-
retrieve old transaction
-
recover from transaction failure
-
delete the transaction
D
Correct answer
Explanation
To recover from deadlocks or failure, transactions are rolled back.
-
multivalued dependency
-
transitive dependency
-
logical dependency
-
join dependency
-
full functional dependency
A
Correct answer
Explanation
4NF is designed to cope up with multivalued dependency.