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 is not a widely used database management system?

  1. MySQL

  2. PostgreSQL

  3. Oracle Database

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

MongoDB is not as widely used as the other three database management systems, especially for enterprise applications.

Multiple choice

Which of the following is a common data storage format used in oceanographic data management?

  1. NetCDF

  2. HDF5

  3. CSV

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

NetCDF (Network Common Data Form) is a widely used data storage format in oceanographic data management due to its ability to store multidimensional scientific data along with metadata, making it suitable for representing complex oceanographic datasets.

Multiple choice

Which of the following is a common method for data quality control in oceanographic data management?

  1. Range checks

  2. Consistency checks

  3. Duplicate data removal

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

Range checks are a common method for data quality control in oceanographic data management, as they involve comparing data values against expected or known ranges to identify potential errors or outliers.

Multiple choice

Which of the following is a common data sharing platform used in oceanographic data management?

  1. Ocean Data Portal

  2. National Oceanographic Data Center (NODC)

  3. Global Ocean Observing System (GOOS)

  4. Intergovernmental Oceanographic Commission (IOC)
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

The Ocean Data Portal is a widely used data sharing platform in oceanographic data management, providing access to a vast collection of oceanographic data from various sources, including research institutions, government agencies, and international organizations.

Multiple choice

What is the concept of data minimization in the context of big data analytics?

  1. Collecting only the data that is necessary for a specific purpose

  2. Storing data for a limited period of time

  3. Anonymizing or pseudonymizing data to protect individual privacy

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

Data minimization in the context of big data analytics involves collecting only the data that is necessary for a specific purpose, storing data for a limited period of time, and anonymizing or pseudonymizing data to protect individual privacy.

Multiple choice

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

  1. Vital statistics

  2. Hospital discharge data

  3. Disease surveillance data

  4. Health insurance claims data
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Health insurance claims data is not a type of health data because it is not collected for public health purposes.

Multiple choice

What is the primary source of vital statistics data?

  1. Birth certificates

  2. Death certificates

  3. Marriage certificates

  4. Divorce certificates
Reveal answer Fill a bubble to check yourself
Correct answer
Explanation

Birth certificates and death certificates are the primary sources of vital statistics data.

Multiple choice

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

  1. Patient demographics

  2. Clinical data

  3. Financial data

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

Environmental data is not typically considered health data, as it does not relate to the health of individuals or populations.

Multiple choice

Which of the following is NOT a common type of database management system (DBMS)?

  1. Relational DBMS

  2. Hierarchical DBMS

  3. Network DBMS

  4. Object-Oriented DBMS
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Object-Oriented DBMS is not a common type of DBMS, as relational DBMSs are the most widely used type.

Multiple choice

Which of the following is a popular knowledge representation formalism for representing real-world objects and their relationships?

  1. Semantic Networks

  2. Frames

  3. Ontologies

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

Semantic Networks, Frames, and Ontologies are all popular knowledge representation formalisms for representing real-world objects and their relationships.

Multiple choice

Which of the following is a resource that provides access to research databases and journals?

  1. Library

  2. Online databases

  3. Interlibrary loan

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

Library, online databases, and interlibrary loan are all resources that provide access to research databases and journals.

Multiple choice

Which of the following is NOT a key component of a clinical decision support system?

  1. Knowledge base

  2. Inference engine

  3. User interface

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

Data analytics modules are typically not considered core components of clinical decision support systems, although they can be integrated to provide additional insights and support.

Multiple choice

How can data users ensure that the data they are using meets the required quality standards?

  1. Check the metadata of the data

  2. Contact the data provider

  3. Validate the data against known standards

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

Data users can ensure that the data they are using meets the required quality standards by checking the metadata of the data, contacting the data provider, and validating the data against known standards.

Multiple choice

Which of the following is NOT a type of metadata commonly used in data warehousing?

  1. Technical metadata

  2. Business metadata

  3. Operational metadata

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

Operational metadata is not a type of metadata commonly used in data warehousing. Technical metadata, business metadata, and structural metadata are the three main types of metadata used in data warehousing.

Multiple choice

Which of the following is NOT a common metadata management tool used in data warehousing?

  1. Data profiling tools

  2. Data integration tools

  3. Data quality tools

  4. Data governance tools
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Data integration tools are not typically used for metadata management in data warehousing. Data profiling tools, data quality tools, and data governance tools are commonly used for this purpose.