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 process of combining data from different sources into a single dataset called?

  1. Data Integration

  2. Data Fusion

  3. Data Merging

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

Data integration involves combining data from different sources into a single dataset, often with the goal of creating a more comprehensive and accurate representation of the real world.

Multiple choice

Which Indian logical principle has been employed in the design of database management systems to ensure data integrity?

  1. Anvaya-vyatireka

  2. Tarka

  3. Upamana

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

Anvaya-vyatireka, the principle of concomitance and absence, has been utilized in database management systems to establish relationships between data items and enforce referential integrity constraints.

Multiple choice

Which type of health data includes information about a patient's lifestyle and behaviors?

  1. Administrative data

  2. Clinical data

  3. Epidemiological data

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

Behavioral data is a type of health data that includes information about a patient's lifestyle and behaviors, such as their diet, physical activity, and smoking habits.

Multiple choice

Which of the following is NOT a type of health data?

  1. Clinical data

  2. Demographic data

  3. Financial data

  4. Behavioral data
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Financial data is not typically considered health data, as it does not directly relate to the health status of an individual or population.

Multiple choice

Which of the following is NOT a common data management standard used in astroinformatics?

  1. FITS

  2. VOX

  3. CSV

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

CSV (Comma-Separated Values) is not a common data management standard in astroinformatics, as it is not well-suited for handling large and complex astronomical datasets.

Multiple choice

Which of the following is NOT a common data management standard used in astroinformatics?

  1. FITS

  2. VOX

  3. CSV

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

CSV (Comma-Separated Values) is not a common data management standard in astroinformatics, as it is not well-suited for handling large and complex astronomical datasets.

Multiple choice

What is the concept of 'Data Lake' in Big Data Analytics?

  1. A centralized repository for storing raw data

  2. A platform for processing and analyzing data

  3. A tool for visualizing data

  4. A method for data security
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

A Data Lake is a centralized repository designed to store large amounts of raw data in its native format. It serves as a central location for storing data from various sources, enabling easy access and analysis by data scientists and analysts.

Multiple choice

What is the term used to describe the process of transforming raw data into a structured format?

  1. Data cleaning

  2. Data integration

  3. Data normalization

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

Data wrangling is the process of transforming raw data into a structured format suitable for analysis. It involves tasks such as data cleaning, data integration, data normalization, and data transformation.

Multiple choice

Which technology is used for storing and managing large volumes of unstructured data?

  1. NoSQL databases

  2. NewSQL databases

  3. Graph databases

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

NoSQL databases, NewSQL databases, and Graph databases are all technologies used for storing and managing large volumes of unstructured data. NoSQL databases are designed for scalability and flexibility. NewSQL databases combine the scalability of NoSQL with the consistency of traditional relational databases. Graph databases are optimized for storing and querying interconnected data.

Multiple choice

Which of the following is NOT a type of health data?

  1. Vital statistics

  2. Disease surveillance data

  3. Health survey data

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

Genomic data is not typically considered health data in the context of disease prevention and public health, as it is more related to genetics and personalized medicine.

Multiple choice

What are the three main types of health data?

  1. Patient demographics, clinical data, and financial data

  2. Patient demographics, clinical data, and patient satisfaction

  3. Patient demographics, clinical data, and utilization data

  4. Patient demographics, clinical data, and outcomes data
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

The three main types of health data are patient demographics, clinical data, and utilization data.

Multiple choice

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

  1. Volume

  2. Variety

  3. Veracity

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

Veracity refers to the accuracy and trustworthiness of data, which is not a defining characteristic of Big Data.

Multiple choice

Which of the following is NOT a common Big Data technology?

  1. Hadoop

  2. Spark

  3. Hive

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

MySQL is a relational database management system, not specifically designed for Big Data processing.

Multiple choice

What is the most common type of legal research database?

  1. LexisNexis

  2. Westlaw

  3. Google Scholar

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

LexisNexis is a subscription-based legal research database that provides access to a wide range of legal materials, including case law, statutes, regulations, and law reviews.

Multiple choice

Which of the following is NOT a common type of spatial data query?

  1. Range query

  2. Nearest neighbor query

  3. Buffer query

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

Join query is a type of database operation that combines data from multiple tables based on a common field or attribute. While range query, nearest neighbor query, and buffer query are all common types of spatial data queries, join query is not specific to spatial data and is used in relational database management systems for combining data from different tables.