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
-
algorithm
-
logical model
-
analytical
-
none of these
B
Correct answer
Explanation
A data structure is a logical model or a way of organizing data in a computer so that it can be used efficiently. It is not an algorithm itself, but rather the structure that algorithms operate upon.
-
The records form a sequence
-
The files form a sequence
-
The elements from a sequence
-
The logics form a sequence
-
array
-
station
-
node
-
none of these
C
Correct answer
Explanation
In the context of linked lists and many other data structures, the individual unit containing data is called a node.
-
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.
-
Text
-
Graphics
-
Both (1) and (2)
-
None of the above
C
Correct answer
Explanation
In mail merge, a data source contains variable information (like names, addresses, or even graphics) that changes for each recipient in the merged document.
-
Object reuses protection
-
ProtectedData
-
Mandatory access control
-
Protection of memory
-
Authentication of users
A
Correct answer
Explanation
In this security feature, operating systems clear all space to be reassigned before allowing the next user to have access to it.
-
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.