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
-
data link
-
data base
-
data file
-
data record
B
Correct answer
Explanation
In the hierarchy of data organization, the database is the highest level, containing all related data files and records.
-
to check all input data
-
to check all spellings
-
to collect and organize input data
-
to output data
C
Correct answer
Explanation
The primary function of a database is to provide a structured way to collect, store, manage, and organize input data so it can be retrieved efficiently.
D
Correct answer
Explanation
In data processing contexts, a batch refers to a group of related records or transactions that are processed together as a single unit.
-
inverted organization
-
regular organization
-
multi-list organization
-
hashed organization
D
Correct answer
Explanation
Hashed organization uses a mathematical function (hash function) to map keys directly to storage locations, providing very fast direct access to records.
-
dBASE 1V
-
4th dimension
-
Fox Pro
-
Reflex
D
Correct answer
Explanation
dBASE, 4th Dimension, and FoxPro are classic relational database management systems. Reflex is a flat-file database program, not a relational one.
-
users
-
separate files
-
database
-
data-base administrator
B
Correct answer
Explanation
A database environment typically consists of users, the database itself, and a database administrator. Separate files are not a core component of the database environment definition.
-
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.
-
write through
-
write before
-
write after
-
none of these
A
Correct answer
Explanation
Write-through is a caching strategy where data is written to the cache and the underlying storage simultaneously, ensuring consistency between the two.
-
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.