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 common type of game engine architecture?

  1. Component-based architecture

  2. Entity-component-system architecture

  3. Data-oriented architecture

  4. Object-oriented architecture
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Data-oriented architecture is not a common type of game engine architecture. The other options, component-based architecture, entity-component-system architecture, and object-oriented architecture, are widely used in game engine development.

Multiple choice

Which of the following is a key principle of Information Architecture?

  1. Consistency

  2. Redundancy

  3. Complexity

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

Consistency in IA ensures that similar information is presented in a uniform manner, making it easier for users to understand and navigate the information space.

Multiple choice

Which of the following is a common IA technique for organizing information?

  1. Card sorting

  2. Tree testing

  3. A/B testing

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

Card sorting is a technique used to gather insights into how users group and categorize information, helping IA professionals understand users' mental models.

Multiple choice

Which data privacy principle emphasizes the need for transparency and accountability in data processing?

  1. Transparency

  2. Accountability

  3. Purpose limitation

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

The principle of transparency requires organizations to be open and transparent about their data processing activities, including the purposes of processing, the categories of personal data processed, and the recipients of the data.

Multiple choice

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

  1. Relational Database Management System (RDBMS)

  2. NoSQL Database Management System

  3. Hierarchical Database Management System

  4. Network Database Management System
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Network Database Management System is not a common type of database management system. It is an older data model that organizes data in a network structure, where records are linked together based on their relationships.

Multiple choice

Which data visualization technique is commonly used to display the hierarchical structure of a manufacturing organization or process?

  1. Treemap

  2. Organizational Chart

  3. Flowchart

  4. Mind Map
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

An organizational chart is used to visualize the hierarchical structure of an organization, displaying the relationships between different departments, teams, and individuals.

Multiple choice

Which of the following is a common data storage model for IoT analytics?

  1. Relational Database

  2. NoSQL Database

  3. Data Warehouse

  4. Graph Database
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

NoSQL databases, such as MongoDB, Cassandra, and HBase, are often used for IoT analytics due to their scalability, flexibility, and ability to handle large volumes of unstructured data.

Multiple choice

In the context of data deduplication, what is a chunk?

  1. A small unit of data that is processed and deduplicated individually

  2. A large collection of data that is stored on a single storage device

  3. A type of data compression algorithm that removes duplicate data

  4. A method for transmitting data over a network efficiently
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

In data deduplication, a chunk is a small unit of data, typically a few kilobytes in size, that is processed and deduplicated individually.

Multiple choice

What is the purpose of a backup window?

  1. To specify the time period during which backups are allowed to run

  2. To specify the maximum amount of time that a backup can take

  3. To specify the frequency with which backups are performed

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

A backup window is a time period during which backups are allowed to run. This is typically done to avoid interfering with normal business operations.

Multiple choice

What are the three main components of information architecture?

  1. Organization, labeling, and navigation.

  2. Content, structure, and design.

  3. Data, information, and knowledge.

  4. Users, tasks, and context.
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Information architecture is the art and science of organizing and labeling web sites, intranets, online communities and software applications in order to make them easy to find and use.

Multiple choice

What are the different types of databases?

  1. Relational databases, NoSQL databases, and hierarchical databases.

  2. MySQL, PostgreSQL, and Oracle.

  3. Local databases and remote databases.

  4. Public databases and private databases.
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

There are three main types of databases: relational databases, NoSQL databases, and hierarchical databases. Relational databases are the most common type of database. They store data in tables, and the data in each table is related to the data in other tables. NoSQL databases are designed to handle large amounts of data that does not fit well into a relational database. Hierarchical databases store data in a tree-like structure.

Multiple choice

Which data warehouse architecture is characterized by a central, integrated database?

  1. Centralized

  2. Distributed

  3. Hybrid

  4. Cloud-based
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

In a centralized data warehouse architecture, all data is stored and managed in a single, unified database.

Multiple choice

What is the process of extracting, transforming, and loading data into a data warehouse called?

  1. Data integration

  2. Data cleansing

  3. Data warehousing

  4. ETL (Extract, Transform, Load)
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

ETL is the process of extracting data from various sources, transforming it to a consistent format, and loading it into the data warehouse.

Multiple choice

Which data warehouse component is responsible for managing and organizing data?

  1. Data mart

  2. Metadata repository

  3. Data warehouse bus

  4. OLAP (Online Analytical Processing) server
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The metadata repository stores information about the data in the data warehouse, including its structure, relationships, and definitions.

Multiple choice

What is the primary function of a data mart?

  1. To provide a subset of data from the data warehouse to specific user groups

  2. To facilitate data mining and predictive modeling

  3. To improve data quality and consistency

  4. To manage and organize data
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Data marts are created to provide specific user groups with a tailored subset of data from the data warehouse, optimizing performance and security.