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

Reason(s) for normalization is/are

  1. structure data

  2. simplify maintenance, eg: updates

  3. simplify retrieval, eg: query

  4. all of the above
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Normalization is used to organize data to reduce redundancy (structure), improve data integrity (maintenance), and optimize the efficiency of data retrieval (querying).

Multiple choice

Major advantage(s) of systems developed using DBMS as compared to systems using conventional file system, is/are

  1. that the DBMS involves simultaneous updates of all data structures to keep the status current

  2. that conventional file system applications are inflexible

  3. that ad-hoc queries are not possible in conventional file system applications

  4. all of the above
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

DBMS systems offer advantages over file systems by providing data independence, better query capabilities, and centralized control, making all listed options valid.

Multiple choice

The data flow diagram

  1. depicts relationships between data objects

  2. depicts functions that transform the data flow

  3. indicates how data are transformed by the system

  4. indicates both (2) and (3)
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

null

Multiple choice

Which of the following best describes the objects that are listed initially in an object table?

  1. They are problem-domain objects that definitely become solution-domain objects.

  2. They are problem-domain objects that may or may not become solution-domain objects.

  3. They are solution-domain objects that definitely become problem-domain objects.

  4. They are solution-domain objects that may or may not become problem-domain objects.
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

null

Multiple choice

In the client/server model, the database

  1. is downloaded to the client upon request

  2. is shared by both the client and server

  3. resides on the client side

  4. resides on the server side
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

null