Computer Knowledge

Database Management Systems

5,344 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 a common navigation pattern used in Information Architecture?

  1. Hierarchical navigation

  2. Sequential navigation

  3. Breadcrumbs

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

Hierarchical navigation, sequential navigation, and breadcrumbs are all common navigation patterns used in Information Architecture.

Multiple choice

Which of the following is a best practice for organizing content in Information Architecture?

  1. Group related content together.

  2. Use clear and concise labels.

  3. Provide multiple navigation paths to the same content.

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

Grouping related content together, using clear and concise labels, and providing multiple navigation paths to the same content are all best practices for organizing content in Information Architecture.

Multiple choice

Which data modeling technique is suitable for representing hierarchical relationships in geographical data warehousing?

  1. Entity-Relationship (ER) modeling

  2. Object-Oriented (OO) modeling

  3. Relational modeling

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

Hierarchical data modeling is a technique that is well-suited for representing hierarchical relationships in geographical data warehousing. It allows for the organization of data in a tree-like structure, where each parent node can have multiple child nodes.

Multiple choice

Which type of relationship in a relational data model represents a one-to-many relationship between two entities?

  1. One-to-One (1:1)

  2. One-to-Many (1:M)

  3. Many-to-One (M:1)

  4. Many-to-Many (M:N)
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

In a relational data model, a one-to-many (1:M) relationship represents a scenario where one record in a table can be related to multiple records in another table. This type of relationship is often used to model parent-child relationships or hierarchical structures.

Multiple choice

Which data modeling technique is commonly used for representing temporal data in geographical data warehousing?

  1. Entity-Relationship (ER) modeling

  2. Object-Oriented (OO) modeling

  3. Relational modeling

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

Temporal data modeling is a specialized technique used to represent and manage temporal data, such as historical records or time-series data. It allows for the storage, retrieval, and analysis of data over time, which is crucial for many applications in geographical data warehousing.

Multiple choice

Which type of relationship in a relational data model represents a many-to-many relationship between two entities?

  1. One-to-One (1:1)

  2. One-to-Many (1:M)

  3. Many-to-One (M:1)

  4. Many-to-Many (M:N)
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

In a relational data model, a many-to-many (M:N) relationship represents a scenario where multiple records in one table can be related to multiple records in another table. This type of relationship is often used to model associative entities or intersection entities.

Multiple choice

What is the principle of 'Data Minimization' in the context of Data Privacy?

  1. Organizations should collect only the minimum amount of data necessary for a specific purpose

  2. Organizations should retain data for as long as possible to ensure its availability

  3. Organizations should share data with third parties without obtaining consent

  4. Organizations should use data for purposes other than those for which it was originally collected
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Data Minimization is a fundamental principle of Data Privacy, emphasizing the importance of collecting and processing only the necessary data for a specific purpose.

Multiple choice

Which of the following is NOT a common data access control model?

  1. Discretionary Access Control (DAC)

  2. Mandatory Access Control (MAC)

  3. Role-Based Access Control (RBAC)

  4. Attribute-Based Access Control (ABAC)
Reveal answer Fill a bubble to check yourself
Correct answer
Explanation

Mandatory Access Control (MAC) is not a common data access control model. DAC, RBAC, and ABAC are more commonly used.

Multiple choice

In DAC, who is responsible for granting and revoking access permissions?

  1. The data owner

  2. The system administrator

  3. The user

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

In DAC, the data owner is responsible for granting and revoking access permissions.

Multiple choice

In ABAC, access permissions are granted based on:

  1. The user's role

  2. The user's attributes

  3. The resource's attributes

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

In ABAC, access permissions are granted based on the user's role, the user's attributes, and the resource's attributes.

Multiple choice

Which phase of the data lifecycle involves the initial creation and capture of data?

  1. Storage

  2. Processing

  3. Acquisition

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

Acquisition is the first phase of the data lifecycle, where data is initially created or captured from various sources.

Multiple choice

Which data classification method categorizes data based on its sensitivity and criticality?

  1. Data lineage

  2. Data profiling

  3. Data classification

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

Data classification involves categorizing data into different classes based on its sensitivity, criticality, and regulatory requirements.

Multiple choice

Which data lifecycle phase involves transforming raw data into a more usable and meaningful format?

  1. Storage

  2. Processing

  3. Acquisition

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

Processing is the phase where raw data is transformed into a more usable and meaningful format through various operations such as cleaning, filtering, and aggregation.

Multiple choice

Which data lifecycle phase involves storing data in a secure and accessible manner?

  1. Storage

  2. Processing

  3. Acquisition

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

Storage is the phase where data is stored in a secure and accessible manner, enabling authorized users to retrieve it when needed.

Multiple choice

Which data lifecycle phase involves the systematic disposal or archiving of data that is no longer needed?

  1. Storage

  2. Processing

  3. Acquisition

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

Disposition is the phase where data that is no longer needed is systematically disposed of or archived, ensuring compliance with data retention policies and regulations.