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

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.

Multiple choice

Which data lifecycle phase involves analyzing data to extract meaningful insights and patterns?

  1. Storage

  2. Processing

  3. Analytics

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

Analytics is the phase where data is analyzed to extract meaningful insights, patterns, and trends, enabling organizations to make informed decisions.