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
-
Audit trail
-
Security
-
File and data integrity
-
None of the above
D
Correct answer
Explanation
Audit trails, security, and data integrity are all standard features and functions provided by modern Relational Database Management Systems (RDBMS).
-
Field
-
Record
-
File
-
Directory
-
_
A
Correct answer
Explanation
Data has several parts, known as a record, which can be divided into fields. It is an area in a fixed location in a unit of data. It is also known as a set of data.
D
Correct answer
Explanation
A Database Management System (DMS or DBMS) is software designed to define, manipulate, retrieve, and manage data in a database.
-
Field
-
Flag
-
Database
-
Record
B
Correct answer
Explanation
A flag is a bit or a set of bits used to store a status or indicate a condition about a piece of data or a process, such as a zero flag or carry flag in a CPU.
-
Database
-
Data flow
-
Process
-
None of the above
C
Correct answer
Explanation
Process is represented in circles that convert data into information. But sometimes, it is represented by rounded edged rectangles.
-
Database tables
-
Attribute tables
-
Decision tables
-
None of the above
C
Correct answer
Explanation
Decision tables are tabular techniques used for defining logical rules. Decision tables are non-procedural process specification tools, which are used to make a model a complex decision making process.
-
Data dictionary
-
Data warehouse
-
Data mining
-
None of the above
A
Correct answer
Explanation
Data about data is called meta data and collection of meta data is called as data dictionary. Data dictionary is complete listing of data elements pertaining to the system.
-
Data element
-
Data flows and data stores
-
Data structure
-
All of the above
D
Correct answer
Explanation
A data dictionary defines three classes of item : - Data element, Data structure and data flow, and Data stores. So, option 4 is correct.
-
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.
-
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.