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 is the name of the open source project that provides a distributed database for storing and querying large amounts of data?

  1. Cassandra

  2. MongoDB

  3. Elasticsearch

  4. HBase
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Cassandra is an open source project that provides a distributed database for storing and querying large amounts of data.

Multiple choice

What is the name of the open source project that provides a distributed data warehousing platform?

  1. Hive

  2. Presto

  3. Impala

  4. Drill
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Hive is an open source project that provides a distributed data warehousing platform.

Multiple choice

Which of the following is an example of a DSS?

  1. A spreadsheet

  2. A database

  3. A simulation model

  4. All of the above
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

All of the above are examples of DSSs.

Multiple choice

What is the importance of data standardization in Chemical Information Science?

  1. It ensures consistent representation of chemical data

  2. It facilitates the integration of chemical data from different sources

  3. It enables the development of interoperable chemical information systems

  4. All of the above
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Data standardization is important in Chemical Information Science as it ensures consistent representation of chemical data, facilitates the integration of chemical data from different sources, and enables the development of interoperable chemical information systems.

Multiple choice

What are the three main types of health economics data?

  1. Primary data, secondary data, and tertiary data

  2. Microeconomic data, macroeconomic data, and health care data

  3. Cost data, utilization data, and quality data

  4. Inpatient data, outpatient data, and emergency department data
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

The three main types of health economics data are cost data, utilization data, and quality data.

Multiple choice

Which of the following is NOT a characteristic of Big Data?

  1. Volume

  2. Variety

  3. Velocity

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

Veracity refers to the accuracy and reliability of data, which is not a defining characteristic of Big Data. The three main characteristics of Big Data are Volume, Variety, and Velocity.

Multiple choice

What is the primary benefit of using Apache Druid for time-series data analysis?

  1. Fast query performance

  2. Scalability and fault tolerance

  3. Support for real-time data ingestion

  4. All of the above
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Apache Druid is a specialized distributed system designed for time-series data analysis. It offers fast query performance, scalability, fault tolerance, and support for real-time data ingestion, making it a suitable choice for analyzing large volumes of time-series data.

Multiple choice

Which distributed database is commonly used for storing and querying large-scale structured data?

  1. Apache Cassandra

  2. Apache HBase

  3. MongoDB

  4. PostgreSQL
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Apache Cassandra is a widely used distributed database designed for handling large-scale structured data. It provides high scalability, fault tolerance, and efficient query performance, making it suitable for applications that require fast access to large data sets.

Multiple choice

Which classification system is widely used in public libraries in the United States?

  1. Dewey Decimal Classification

  2. Library of Congress Classification

  3. Universal Decimal Classification

  4. Bliss Bibliographic Classification
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

The Dewey Decimal Classification (DDC) is a widely used library classification system that organizes books and other library materials by subject. It is used in many public libraries, school libraries, and academic libraries in the United States and other countries.

Multiple choice

Which classification system is used to organize books in the Library of Congress?

  1. Dewey Decimal Classification

  2. Library of Congress Classification

  3. Universal Decimal Classification

  4. Bliss Bibliographic Classification
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The Library of Congress Classification (LCC) is a classification system that is used to organize books and other library materials in the Library of Congress. It is also used in many other libraries around the world.

Multiple choice

Which classification system is used to organize books in the British Library?

  1. Dewey Decimal Classification

  2. Library of Congress Classification

  3. Universal Decimal Classification

  4. Bliss Bibliographic Classification
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

The Bliss Bibliographic Classification (BBC) is a classification system that is used to organize books and other library materials in the British Library. It is also used in some other libraries around the world.

Multiple choice

Which classification system is used to organize books in the National Library of China?

  1. Dewey Decimal Classification

  2. Library of Congress Classification

  3. Universal Decimal Classification

  4. Chinese Library Classification
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

The Chinese Library Classification (CLC) is a classification system that is used to organize books and other library materials in the National Library of China. It is also used in some other libraries in China.

Multiple choice

Which classification system is used to organize books in the Russian State Library?

  1. Dewey Decimal Classification

  2. Library of Congress Classification

  3. Universal Decimal Classification

  4. Library-Bibliographical Classification
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

The Library-Bibliographical Classification (LBC) is a classification system that is used to organize books and other library materials in the Russian State Library. It is also used in some other libraries in Russia.

Multiple choice

What is a geodatabase in ArcGIS?

  1. A collection of feature classes, feature datasets, and tables that are stored in a single file.

  2. A collection of feature classes, feature datasets, and tables that are stored in a relational database.

  3. A collection of feature classes, feature datasets, and tables that are stored in a cloud-based database.

  4. All of the above.
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

All of the above statements are true. A geodatabase is a collection of feature classes, feature datasets, and tables that are stored in a single file, a relational database, or a cloud-based database.

Multiple choice

Which of the following is NOT a common type of decision support system (DSS)?

  1. Model-driven DSS

  2. Data-driven DSS

  3. Knowledge-based DSS

  4. Communication-driven DSS

  5. Group DSS
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Communication-driven DSS is not a common type of DSS.