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

Which of the following database is designed to support information managers and pharmacovigilance in complying with the regulatory requirements of a licensed drug?

  1. EMBL

  2. Index Medicus

  3. Embase

  4. PubMed

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

Embase (often styled EMBASE for Excerpta Medica dataBASE) is a biomedical and pharmacological database of published literature designed to support information managers and pharmacovigilance in complying with the regulatory requirements of a licensed drug.

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

Which of the following characteristics of OLAP means that the system is targeted to deliver most responses to users within about five seconds, with the simplest analyses taking no more than one second and very few taking more than 20 seconds?

  1. Fast

  2. Analysis

  3. Shared

  4. Multidimensional

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

This characteristic of OLAP means that the system is targeted to deliver most responses to users within about five seconds,  with the simplest analyses taking no more than one second and very few taking more than 20 seconds.

Multiple choice

Which of the following tasks in data transformation includes a large variety of rudimentary conversions of single fields for two primary reasons - one to standardise among data extractions from disparate source systems, and the other to make the fields usable and understandable to the users?

  1. Selection

  2. Splitting / Joining

  3. Conversion

  4. Summarization

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

This task in data transformation includes a large variety of rudimentary conversions of single fields for two primary reasons -  one to standardise among the data extractions from disparate source systems, and the other to make the fields usable and understandable to the users.

Multiple choice

Which of the following data warehouses is the integration of heterogeneous business intelligence systems set to provide analytical capabilities across different functions of an organisation?

  1. Real time data warehouse

  2. Federated data warehouse

  3. Distributed data warehouse

  4. Either Real time data warehouse or Distributed data warehouse

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

This type is the integration of heterogeneous business intelligence systems set to provide analytical capabilities across different functions of an organisation.