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

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.

Multiple choice

Which of the following is the correct data structure for solid models?
  1. solid part $\rightarrow$faces$\rightarrow$edges $\rightarrow$vertices
  2. solid part$\rightarrow$edges $\rightarrow$faces$\rightarrow$vertices
  3. vertices$\rightarrow$edges$\rightarrow$faces$\rightarrow$solid parts
  4. vertices$\rightarrow$faces$\rightarrow$edges$\rightarrow$solid part
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Correct data structure for solid models is given by,

Vertices $\rightarrow$ edges $\rightarrow$ faces $\rightarrow$ solid parts