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
-
Data element
-
Elementary data item
-
Data entry
-
Database Management
B
Correct answer
Explanation
An elementary data item is a data unit that cannot be subdivided into smaller meaningful units in the context of the data structure.
-
files
-
paths
-
sectors
-
cylinders
C
Correct answer
Explanation
Each track on a disk is divided into smaller segments called sectors, which are the smallest addressable units of storage.
-
class
-
object
-
method
-
signature
B
Correct answer
Explanation
An object is an instance of a class that encapsulates both data (fields) and the methods (operations) that act on that data.
-
The Log Writer Process
-
The Database Writer Process
-
The Checkpoint Process
-
The Process Monitor Process
-
The System Monitor Process
C
Correct answer
Explanation
The Checkpoint Process is responsible for updating file headers in the database data files.
-
Only 1
-
Only 2
-
Only 3
-
1 and 2
-
2 and 3
A
Correct answer
Explanation
The dynamic performance view V$LOG contains information about all current redo logs.
-
Data dictionary
-
Indexes
-
Clusters
-
System Global Area
-
Library Cache
A
Correct answer
Explanation
Data dictionary consists of a special collection of tables that contains information about all user objects in the database.
-
Database buffer cache
-
KEEP buffer pool
-
RECYCLE buffer pool
-
nK buffer cache
-
Shared pool
D
Correct answer
Explanation
nK buffer cache, one of the several specialised database buffer caches designed to hold block sizes different from the default database block size.
-
It has high performance and scalability.
-
It uses dynamic resources.
-
It has continuous availability of data and applications.
-
It has single administrator which cannot manage hundreds of servers.
-
It has advanced integration features that allow applications and data to run anywhere in the network.
D
Correct answer
Explanation
It is a false statement. Oracle infrastructure automates many functions so that a single administrator can manage hundreds of servers. So, this option is correct.
-
SGA
-
PGA
-
data dictionary
-
views
-
disk files
C
Correct answer
Explanation
In order to parse SQL statements, the Oracle instance frequently accesses data dictionary.
-
TABLESPACE_MIGRATE_FROM_LOCAL
-
TABLESPACE_MIGRATE_TO_LOCAL
-
TABLESPACE_RELOCATE_BITMAPS
-
TABLESPACE_FIX_BITMAPS
-
TABLESPACE_REBUILD_BITMAPS
B
Correct answer
Explanation
TABLESPACE_MIGRATE_TO_LOCAL can be used for a locally managed system tablespace.
-
stack-space
-
session-information
-
private SQL-area
-
sorting area
-
strain area
C
Correct answer
Explanation
Private SQL-area holds information such as bind-variables and runtime-buffers.
-
Data and index files
-
Online redo log files
-
Temp files
-
Archive log files
-
Offline redo log files
B
Correct answer
Explanation
Online redo log files hold the transactional history of the database.
-
data files
-
tablespaces
-
data segments
-
extents
-
data blocks
B
Correct answer
Explanation
The Oracle RDBMS stores data logically in the form of tablespaces.
-
Platform Specific Release Number
-
Component Specific Release Number
-
Major Database Release Number
-
Database Maintenance Release Number
-
Application Server Release Number
E
Correct answer
Explanation
The third number tells about the Application Server Release Number.
-
Regional Data Base Management systems
-
Rational Data Base Management systems
-
Relational Data Base Management Systems
-
Requested Data Base Management systems
C
Correct answer
Explanation
RDBMS stands for Relational Database Management System. It is a type of database management system that stores data in the form of related tables.