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

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

Multiple choice

An abstract data type is used to

  1. link data from remote databases

  2. prevent users from getting to database security information

  3. provide a conceptual view of the data so it is easier to understand

  4. store complex data structure to represent the properties of objects
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

null

Multiple choice

The primary difference between the Relational database (RDB) and Object Oriented database (OODB) models is

  1. OODB incorporates methods in with the definition of the data structure, while RDB does not

  2. OODB supports multiple objects in the same database while RDB only supports a single table per database

  3. RDB allows the definition of the relationships between the different tables, while OODB does not allow the relationships to be defined between objects

  4. RDB supports indexes, while OODB does not support indexes
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

null