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
-
Decision table
-
Pseudocodes
-
Structured table
-
Data dictionaries
-
Data dictionary
-
Decision table
-
Data flow diagram
-
All of the above
-
database
-
file
-
record
-
field
C
Correct answer
Explanation
In database terminology, a single entry in a telephone book, containing information about one person, is analogous to a record. A database is the entire book, and a field is a specific piece of data like a name or phone number.
-
network
-
tree
-
chain
-
All of above
D
Correct answer
Explanation
Network, tree, and chain data structures can all represent one-to-many relationships. Therefore, all of these are valid logical structures for such relationships.
-
4GL
-
SQL
-
Query language
-
HLL
C
Correct answer
Explanation
Query languages are designed specifically to allow users to access and manipulate data within a database management system. While SQL is a specific type of query language, 'Query language' is the broader, correct classification.
-
record and files
-
data and elements
-
record and relationships
-
all of the above
D
Correct answer
Explanation
A database schema provides the blueprint for the database, defining the structure of records, the data elements contained within them, and the relationships between different data entities.
-
Width
-
Language
-
Spelling
-
All of above
A
Correct answer
Explanation
In data management, the width (or length) of a data item is a critical characteristic for storage allocation and processing. While spelling and language are properties of data, width is a structural characteristic.
-
data
-
files
-
fields
-
all of above
C
Correct answer
Explanation
A record is composed of several distinct data items, each of which is stored in a specific field. Fields represent the individual attributes of the record.
-
relations
-
domains
-
queries
-
none of these
-
users
-
separate files
-
database
-
DBA
B
Correct answer
Explanation
A database environment typically includes users, the database itself, and the Database Administrator (DBA). Separate files are generally a characteristic of older file management systems, not the integrated database environment.
-
store data input by a user
-
retrieve information from files
-
answer queries
-
both (2) and (3)
D
Correct answer
Explanation
Report generators are used to retrieve information from files and present it in a structured format, which effectively answers user queries about the data.
-
tuple
-
entity
-
degree
-
attribute
D
Correct answer
Explanation
In the relational model, a table is a relation, rows are tuples, and columns are referred to as attributes.
-
physical data model
-
record based logical model
-
object based logical model
-
all of these
C
Correct answer
Explanation
The Entity-Relationship (E-R) model is a high-level conceptual data model used to describe the real-world entities and their relationships, which classifies it as an object-based logical model.
-
module
-
relational model
-
schema
-
sub schema
D
Correct answer
Explanation
A sub-schema is a subset of the database schema that defines the specific view of the data for a particular user or application.
-
DBA
-
The end user
-
The systems programmer
-
Client
A
Correct answer
Explanation
The Database Administrator (DBA) is responsible for the overall design, maintenance, and security of the database, which includes managing the conceptual level of the DBMS.