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
-
A set of values
-
A processed data
-
A collection of record
-
None of these
B
Correct answer
Explanation
In information technology, information is defined as data that has been processed, organized, or structured to make it meaningful and useful.
C
Correct answer
Explanation
Data is defined as raw facts, values, or a set of values that have not yet been processed or contextualized.
-
A collection of similar entities
-
A collection of related records
-
A collection of related items
-
None of these
C
Correct answer
Explanation
A record in a database or data structure is a collection of related data items (fields) that represent a single entity.
-
key
-
information
-
data time
-
record
A
Correct answer
Explanation
A key is a specific field in a record that uniquely identifies that record, allowing it to be distinguished from others in a database.
-
A collection of record which can be ordered or unordered.
-
A collection of data type which can be ordered or unordered.
-
A collection of different values.
-
A collection of elements which can be ordered or unordered.
D
Correct answer
Explanation
A list is a general data structure representing a collection of elements that can be ordered or unordered. The other options are too specific or incorrectly define the scope of a list.
-
Sort
-
Field
-
Search
-
Recoding
A
Correct answer
Explanation
The PL/SQL engine is responsible for processing the procedural parts of a block, while the SQL engine handles the SQL statements.
-
Database Migrate System
-
Database Management System
-
Data Manipulating System
-
Database Management Storage
B
Correct answer
Explanation
DBMS is the standard acronym for Database Management System, the software used to manage databases.
-
user_types
-
user_source
-
user_data
-
user_code
A
Correct answer
Explanation
The USER_TYPES data dictionary view in Oracle provides information about user-defined types created in the database.
-
data type
-
data items and data variables
-
integers
-
none of the above
B
Correct answer
Explanation
A structure (struct) in C is a user-defined data type that groups together related data items of potentially different types under a single name.
-
entities
-
attributes
-
both (1) and (2)
-
none of these
C
Correct answer
Explanation
Slot-and-filler systems, such as frames or semantic networks, organize knowledge into entities and their associated attributes. Inheritance is facilitated by the hierarchical structure of these entities and attributes.
-
Target database
-
Duplicate database
-
Local agent
-
Media management application
-
Media management catalogue
A
Correct answer
Explanation
This component of RMAN environment contains the control files, datafiles and optional archived redo logs.
-
Shrinking phase
-
Local agent
-
Serialisability
-
Exclusive mode
-
Atomicity
E
Correct answer
Explanation
It requires that if a transaction is interrupted by a failure, its partial results are not at all taken into consideration.
-
Queue monitor
-
Log writer
-
Recoverer
-
Mounting the database
-
Lock manager server
C
Correct answer
Explanation
This background process is used to resolve distributed transactions that are pending due to a network failure or system failure in a distributed database.
-
Queue monitor
-
Log writer
-
Recoverer
-
Mounting the database
-
Lock manager server
C
Correct answer
Explanation
This background process is used to resolve distributed transactions that are pending due to a network failure or system failure in a distributed database.