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
-
Database blocks
-
Schema
-
Physical structure
-
Extent
-
Segment
C
Correct answer
Explanation
The physical structure in oracle database consists of datafiles, redo log files and control files.
-
atomicity
-
isolation
-
consistency
-
durability
-
rollback
C
Correct answer
Explanation
This rule of database software states that every transaction must preserve the integrity constraints.
-
object
-
post relational
-
dimensional model
-
domain/key normal form
-
SQL
B
Correct answer
Explanation
The models like PICK aka MultiValue and MUMPS aka M comes under post-relational model.
-
master/slave replication
-
multimaster
-
quorum
-
schema
-
data dictionary
C
Correct answer
Explanation
This type of replication is the result of read and write requests calculated by querying a majority of replicas.
-
query optimiser
-
DML precompiler
-
selection operation
-
query plan
-
projection operation
D
Correct answer
Explanation
This is a set of steps used to access information is a SQL relational database management system.
-
Attribute based queries
-
Textual queries
-
Visual queries
-
Metadata descriptors
-
Visual descriptors
B
Correct answer
Explanation
This type of queries use a term based specification of the desired images that can be matched to textual image descriptors.
-
Weak
-
Subclass
-
Base
-
Shared subclass
-
Category
C
Correct answer
Explanation
This entity types in DBMS represents the central objects of the system.
-
network
-
hierarchical
-
relational
-
object relational
-
object model
B
Correct answer
Explanation
This data model in DBMS organises data into a structure, which appears as a tree.
-
vertical fragmentation
-
horizontal fragmentation
-
summary data
-
duplicate data
-
functional dependency
B
Correct answer
Explanation
This is the denormalization technique in DBMS in which the database table is split by rows that reduces the number of records per table and hence, drives the performance.
-
centralised database
-
data model
-
CODASYL
-
database server
-
IMS
C
Correct answer
Explanation
This is a standard in DBMS environment that specifies the process of storing the data into network database and retrieving the data from network database.
-
data type
-
abstract data type
-
data set
-
data structure
-
identifier
B
Correct answer
Explanation
A set of values (carrier set) and operations on those values is called Abstract Data type (ADT). Example: For Boolean ADT carrier set is {True, False} and negation, conjunction, etc. are operations on it.
-
Double Hashing
-
Linear Hashing
-
Buckets
-
Probe Sequence
-
Dynamic Hashing
B
Correct answer
Explanation
It is a dynamically updateable disk based index structure which implements a hashing scheme and grows or shrinks one bucket at a time.
-
Structural part
-
Manipulative part
-
Set of integrity rules
-
Logical design
-
Physical design
A
Correct answer
Explanation
This model comprises a set of rules according to which databases can be constructed.
-
Structural part
-
Table spaces
-
Partitioned tables
-
Views
-
None of these
B
Correct answer
Explanation
This physical design structure comprises one or more data files, which are physical structures with the operating system one is using.
-
Data cube
-
Indexing
-
Physical storage
-
Data modelling
-
Parallelism
D
Correct answer
Explanation
Data modelling is the process of modelling and formalising data requirements in an intrinsic part of the database design process.