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

The database environment has all of the following components except

  1. users

  2. separate files

  3. database

  4. DBA
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

A database environment typically includes users, the database itself, and the Database Administrator (DBA). Separate files are generally a characteristic of older file management systems, not the integrated database environment.

Multiple choice

Report generators are used to

  1. store data input by a user

  2. retrieve information from files

  3. answer queries

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

Report generators are used to retrieve information from files and present it in a structured format, which effectively answers user queries about the data.

Multiple choice

E-R Model comes under

  1. physical data model

  2. record based logical model

  3. object based logical model

  4. all of these
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

The Entity-Relationship (E-R) model is a high-level conceptual data model used to describe the real-world entities and their relationships, which classifies it as an object-based logical model.

Multiple choice

Which of the following is not a record based logical model?

  1. Network model

  2. Object-oriented model

  3. Relational model

  4. Hierarchical model
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Record-based logical models include the Relational, Network, and Hierarchical models. The Object-oriented model is an object-based logical model, not a record-based one.

Multiple choice

PDU means

  1. Parallel Data Unit

  2. Positve Data Unit

  3. Poly Data Unit

  4. Protocol Data Unit
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

PDU stands for Protocol Data Unit, which is the unit of data exchanged between peer entities in the same layer.

Multiple choice

SDU means

  1. Service Data Unit

  2. Several Data Unit

  3. Seperate Data Unit

  4. None of these
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

SDU stands for Service Data Unit, which is the data unit passed between layers when requesting services. It's the user data that needs to be transmitted.

Multiple choice

A database query is an example for

  1. message stream

  2. byte stream

  3. datagram

  4. request-reply service
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

A database query involves sending a request and waiting for a specific reply. This request-reply pattern is a distinct communication model used in client-server interactions.

Multiple choice

Which of the following is not true about Electronic Data Interchange (EDI)?

  1. EDI (Electronic Data Interchange) is transfer of data from one computer system to another by standardised message formatting, without the need for human intervention.

  2. It is used by organisations that make a large number of regular transactions.

  3. Mass customisation is an example of EDI.

  4. The process of taking from a company specific format and fitting into the EDI standard electronic format is called mapping.

  5. An EDI standard electronic format for a business format is called dataset.
Reveal answer Fill a bubble to check yourself
E Correct answer
Explanation

 An EDI standard electronic format for a business format is called transaction set. Hence, it is an incorrect statement about EDI.