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
-
Can be updated by the end users
-
Contains numerous naming conventions and formats
-
Organised around important subject areas
-
Contains only current data
-
None of these
C
Correct answer
Explanation
A data warehouse is a large repository of data collected from various sources within an organization. It is specifically organized around important subject areas to support decision-making and analysis.
-
Structures
-
Field markers
-
Field definition
-
Field names
-
None of these
D
Correct answer
Explanation
In a database, a field is a single piece of information. The labels used to identify these pieces of information within a table are called field names.
-
data redundancy
-
information overload
-
duplicate data
-
data inconsistency
-
none of these
D
Correct answer
Explanation
Data inconsistency occurs when the same data exists in different formats or values across multiple files or tables, often because an update was not propagated to all locations.
-
minimize the number of relationships
-
minimize the number of entities
-
minimize the number of tables
-
minimize the number of redundancy
-
none of these
D
Correct answer
Explanation
Normalization in database design aims to minimize redundancy by organizing data efficiently and eliminating duplicate information. It does not minimize relationships, entities, or tables directly; these may increase during normalization. The phrasing should be 'minimize redundancy' but the intent is correct.
-
QBE
-
SQL
-
OLAP
-
Sequel Server
-
None of these
B
Correct answer
Explanation
SQL (Structured Query Language) is the standard language used for managing and manipulating data held in a relational database management system.
-
data dictionary
-
data table
-
data record
-
data field
-
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. It defines the structure of the database by storing metadata.
-
hardware system used to create, maintain and provide controlled access to a database
-
hardware system used to create, maintain, and provide uncontrolled access to a database
-
software system used to create, maintain, and provide uncontrolled access to a database
-
software system used to create, maintain, and provide controlled access to a database
-
None of these
D
Correct answer
Explanation
A Database Management System (DBMS) is software that allows users to define, create, maintain, and control access to a database. It acts as an interface between the user and the database.
-
Tree
-
Relational Structure
-
Network
-
Chain
-
It is a physical representation of the data.
-
It allows a many-to-many relationship.
-
It is conceptually simple.
-
It will be dominant database of the future.
B
Correct answer
Explanation
A network database structure allows a record to have multiple parent records, which facilitates many-to-many relationships, unlike the hierarchical model which is restricted to one-to-many.
-
data elements
-
records and files
-
records relationships
-
all of the above
D
Correct answer
Explanation
A database schema is the skeleton structure that represents the logical view of the entire database, including data elements, records, files, and the relationships between them.
-
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.
-
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.