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

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.

Multiple choice

Which of the following database links is used to access remote database to a user, which requires an account on the remote database with the same username as its account on the local database?

  1. Connected user link

  2. Fixed user link

  3. Auditing database links

  4. Current user link

  5. Synonyms
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

This database link is used to access remote database to a user, which requires an account on the remote database with the same username as its account on the local database.