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

What do you understand by the term DFD?

  1. It is a tool of structured analysis.

  2. It shows the relationship between the data and the process involved in the system.

  3. Both (1) and (2)

  4. It is a graphical tool which shows the various transition between the states.

  5. None of these
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

DFD stands for data flow diagram which is one of the tools of structured analysis, mainly used to show the flow of data in the system.

Multiple choice

Which of the following is not specific to a particular database management product?

  1. Object-relational mapping

  2. Conceptual schema

  3. Logical schema

  4. Physical data model

  5. Semantic web
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

A logical schema is a data model of a specific problem domain expressed in terms of a particular data management technology.Without being specific to a particular database management product, it is in terms of either relational tables and columns, object-oriented classes, or XML tags. This is as opposed to a conceptual data model, which describes the semantics of an organisation without reference to technology, or a physical data model, which describes the particular physical mechanisms used to capture data in a storage medium.

Multiple choice

What is a data mart?

  1. A repository of data

  2. A data transaction technique

  3. A data processor

  4. A data updation location

  5. A data dump yard
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

A data mart is a repository of data gathered from operational data and other sources that are designed to serve a particular community of knowledge workers.

Multiple choice

How can you define a weak entity type?

  1. It is dominant entity type.

  2. It is coordinate entity type.

  3. It is parent entity type.

  4. It is child entity type.

  5. None of these
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

An entity type that is existence dependent on some other entity type is called as child/weak entity type.

Multiple choice

The basic goal of computer process is to convert data into

  1. files

  2. graphs

  3. information

  4. tables

  5. None of these
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Information is accurate, organised and specific for a purpose. When information is entered into a computer, it is referred to as data. After processing, data is converted into information.

Multiple choice

Advantage of ODBC

  1. adds on additional layer

  2. standardized API

  3. fully Automated

  4. none
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

none

Multiple choice

The code that processes the SQL request and the data reside on the same address

  1. groupware server

  2. workflow servers

  3. database servers

  4. transaction servers
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Database servers process SQL requests and store data, typically on the same system or address space. This co-location improves performance by reducing network latency. Groupware servers (A) facilitate collaboration, workflow servers (B) manage business processes, and transaction servers (D) handle transaction processing.