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
-
database
-
record
-
information
-
None of these
A
Correct answer
Explanation
End-user query tools are specifically designed to allow users to retrieve and manipulate data stored within a database.
-
Open data
-
Linked data
-
Wikidata
-
Primary data
-
Tertiary source of data
A
Correct answer
Explanation
Open data is the idea that certain data should be freely available to everyone to use and republish as they wish, without restrictions from copyright, patents or other mechanisms of control.
-
a comprehensive integration collection of data about data
-
a dictionary or algorithm for obtaining the address of logical records on a storage device
-
the relationship among the different fields of data in a secondary storage
-
none of these
A
Correct answer
Explanation
A data dictionary is a centralized repository of information about data, such as meaning, relationships to other data, origin, usage, and format.
-
Only P and Q
-
Only P and R
-
Only P and S
-
Only Q and R
-
Only Q and S
B
Correct answer
Explanation
It is correct. Both P and R are enzyme database.
REBASE is a database of information about restriction enzymes and DNA methyltransferases.
BRENDA (BRaunschweig ENzyme DAtabase) is an enzyme information system representing one of the most comprehensive enzyme repositories.
-
separate management from work
-
promote decentralised and end user computing
-
facilitate transmission of files across continents
-
eliminate data redundancy
D
Correct answer
Explanation
A Database Management System (DBMS) is designed to organize data efficiently, and one of its primary functions is to reduce or eliminate data redundancy.
-
database
-
program
-
information
-
query
A
Correct answer
Explanation
A query is a database object used to retrieve, filter, and manipulate data from one or more tables based on specific criteria.
-
Conceptual view
-
Internal view
-
External view
-
None of the above
D
Correct answer
Explanation
All of the above are view levels of database.
-
Hierarchy schema
-
Network schema
-
Relational schema
-
All of the above
A
Correct answer
Explanation
Top to bottom approach is used in hierarchial schema because it basically is based on Parent and Child Relationship. The parent and child relationship type has basically 1 : N relationship.
-
By rollback of transaction
-
By locking up the data
-
Projection
-
None of the above
A
Correct answer
Explanation
There are few methods to get recovery of documents from deadlock. These are commit, rollback or abort.
-
index
-
instance
-
view
-
none of the above
B
Correct answer
Explanation
Instance is a collection of the information stored in a database at a particular moment.
-
Oracle
-
Ingress
-
Mysql
-
None of the above
B
Correct answer
Explanation
Quel was the original query language for the Ingres dbms. It is now called SQL.
-
Refree
-
Barrier
-
Gateway
-
Interface
D
Correct answer
Explanation
Every software has a interface to interact with clients or user, similarly in between user and database, interface is provided in application.
-
storage data
-
control data
-
redundant data
-
accurate data
C
Correct answer
Explanation
Dulpicate data in database is called as data redundancy in database. In order to avoid redundancy we use the technique of normalization.
-
Lock the database
-
Change the password
-
Lock all the rows or tables
-
Lock one row
A
Correct answer
Explanation
By locking the database it makes it unsharable and nobody can share it.