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

Multiple choice

___________________ , whose vocabulary and rules focus on the conceptual and physical representation of a system.

  1. The UML is a language for modeling

  2. The UML is a language for visualising

  3. The UML is a language for specifying

  4. The UML is a language for constructing

  5. The UML is a language for documenting
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

In UML modeling language, vocabulary and rules focus on the conceptual and physical representation of a system. 

Multiple choice

Which of the following schemas in distributed databases consists of fragments that are a part of logical portions of the global relation and that are physically dispersed at different sites of the network?

  1. Global schema

  2. Fragmentation schema

  3. Allocation schema

  4. Local mapping schema

  5. Physical schema
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

This schema in distributed databases consists of fragments that are a part of logical portions of the global relation and that are physically dispersed at different sites of the network.

Multiple choice

Which of the following fragmentations in distributed database requires knowledge of the logical properties of the data and the statistical properties of the data such as the number of references of applications to the fragments?

  1. Primary fragmentation

  2. Horizontal fragmentation

  3. Derived horizontal fragmentation

  4. Vertical fragmentation

  5. Global fragmentation
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

This type of fragmentation in distributed database requires knowledge of the logical properties of the data and the statistical properties of the data such as the number of references of applications to the fragments.

Multiple choice

Which of the following features of distributed database allows application developers and administrators to hide the physical location of database objects from applications and users?

  1. Distributed query optimisation

  2. Remote procedure calls

  3. Location transparency

  4. Site autonomy

  5. Distributed transactions
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

This feature of distributed database allows application developers and administrators to hide the physical location of database objects from applications and users.