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
-
Table
-
Group
-
Attribute
-
DBMS
-
Row
C
Correct answer
Explanation
An attribute means property of data.
-
barrier
-
interface
-
referee
-
obstacle
-
guide
B
Correct answer
Explanation
Interface is the means of interaction.
-
accurate data
-
redundant data
-
related data
-
grouped data
-
null data
B
Correct answer
Explanation
Redundancy means duplicate/repeated data.
-
Dbase iv
-
Oracle 7.1
-
SQL
-
Ingress
-
Foxpro 2.1
B
Correct answer
Explanation
Oracle is client server application development.
-
physical level
-
logical level
-
conceptual level
-
view
-
file level
A
Correct answer
Explanation
It shows how data is actually stored.
-
root
-
collision
-
primary key
-
composite key
-
duplicate record
A
Correct answer
Explanation
Hash value points to the element exactly using index.
-
Reconstruction condition
-
Completeness condition
-
Disjoint condition
-
None of these
B
Correct answer
Explanation
This condition in data fragmentation states that all data of the global relation must be mapped into fragments.
-
Availability and reliability of distributed data
-
Workload distribution
-
Storage costs and processing locality
-
Processing locality
D
Correct answer
Explanation
This objective in the design of the data distribution can be achieved by having redundant fragment allocation meeting the site requirements.
-
Data localisation
-
Global query optimisation
-
Query decomposition
-
None of these
C
Correct answer
Explanation
This is the layer of query processing that decomposes the distributed calculus query into an algebraic query on global relations.
-
Third Party Administration Tools
-
SNMP Support
-
Enterprise Manager
-
None of these
C
Correct answer
Explanation
This tool in Oracle distributed database systems is a database administration tool, which allows an user to perform database administration task with the convenience of a Graphical User Interface (GUI).
-
Transparent SQL access
-
Distributed transactions
-
Procedural Access
-
None of these
B
Correct answer
Explanation
This feature of heterogeneous service agent or Oracle gateway allows a transaction that can span both Oracle and non-Oracle systems.
-
View level
-
Physical level
-
Logical level
-
Virtual level
-
None of these
B
Correct answer
Explanation
This is the low level and here, data is stored.
-
generalization
-
aggregation
-
attribute inheritance
-
specialization
-
none of these
D
Correct answer
Explanation
The process of designating sub grouping within an entity set is called specialization.
-
Simplifies how data is stored
-
Simplifies what data is stored in the database
-
Collects the information stored in the database at a particular moment
-
Simplifies database interaction with the system
-
None of these
D
Correct answer
Explanation
View level is the highest level of abstraction that describes only part of the database and simplifies their interaction with the system.
-
Database design at logical level
-
Different views of the database
-
Database design at physical level
-
Complex low-level data structure
-
None of these
B
Correct answer
Explanation
This is done by sub-schema.