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
-
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.
-
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.
-
Component design
-
Client-Server model
-
Abstract machine model
-
Repository model
-
Algorithm design
B
Correct answer
Explanation
This type of model is a distributed system model, which shows how data and processing is distributed across the range of processors.
-
Property object
-
Container object
-
Data access object
-
Database object
-
QueryDef object
A
Correct answer
Explanation
It represents built-in characteristics or user defined characteristics of a data access object.
-
TableDef object
-
QueryDef object
-
Relation object
-
Container object
-
Field object
D
Correct answer
Explanation
It holds the information describing the objects, which are grouped into that container.
It corresponds to a column of data type and a set of properties.
-
Recordset object
-
Table type recordset object
-
QueryDef object
-
Field object
-
Snapshot type recordset object
E
Correct answer
Explanation
It contains a fixed set of data, as it exists, when the summary is created.
-
Table type recordset object
-
Dynaset type recordset object
-
Recordset object
-
Data access object
-
DBEngine
B
Correct answer
Explanation
It can refer to either local or attached tables, or to the result of queries.
-
JDBC API
-
JDBC driver manager
-
JDBC ODBC bridge
-
JDBC test suite
-
Native protocol pure java driver
D
Correct answer
Explanation
It helps you to determine that JDBC drivers will run your program.
-
client-server model
-
repository model
-
abstract machine model
-
either client-server model or abstract machine model
-
none of these
B
Correct answer
Explanation
A system model based on a shared database is called as repository model.
-
Entity-relation model
-
Data flow model
-
Structural model
-
Object-oriented model
-
None of these
A
Correct answer
Explanation
An entity-relation model is used to describe the logical data structures being used.