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 technology security
  1. Access control lists (ACLs)

  2. Capability lists

  3. Triples

  4. Properties

Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Columns of an access matrix represent objects, and the list of permissions for a given object across all subjects is called an Access Control List (ACL). In contrast, rows represent subjects and correspond to capability lists. Triples represent (subject, object, rights) entries, and properties are unrelated attributes.

Multiple choice technology security
  1. Detective

  2. Corrective

  3. Preventive

  4. Administrative

Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Database views are preventive controls because they restrict user access to specific rows, columns, or subsets of data. By limiting what data users can see or query, views prevent unauthorized access to sensitive information. They don't detect violations (detective) or correct issues (corrective) - they proactively restrict access.

Multiple choice technology databases
  1. Authorization impacted

  2. Authentication impacted

  3. Billing period data unavailable

  4. alert info unavailable

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The DSS (likely Directory Security Service or similar) handles authentication - verifying user identity. If it goes down, users cannot log in or authenticate, though authorized users' existing sessions may continue to function temporarily. Authorization (permissions) and billing data are handled by separate services.

Multiple choice technology security
  1. Use it for overwriting current logs

  2. Inform stakeholders and degauss the media

  3. Keep it safely and securely in the fire proof safe

  4. format the media

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

To solve this question, the user needs to have knowledge of data retention policies and best practices for managing defective media.

Option A: Using the defective media for overwriting current logs is not recommended. The data on the defective media is potentially corrupted or lost, and using it for overwriting current logs can result in further data loss or inconsistency.

Option B: This is the correct answer. Informing stakeholders and degaussing the media is the best approach for managing defective media. Degaussing the media involves exposing it to a magnetic field to erase all data stored on it. This is a secure and effective way to dispose of defective media.

Option C: Keeping the defective media safely and securely in a fireproof safe may seem like a good idea, but it is not an effective way to manage defective media. The data on the defective media is still potentially corrupted or lost, and there is no guarantee that it will remain secure in the safe.

Option D: Formatting the media is not recommended. Formatting may not be effective in erasing all data, and it may also overwrite any remaining data on the media, making it difficult or impossible to recover.

Therefore, the correct answer is:

The Answer is: B. Inform stakeholders and degauss the media.

Multiple choice technology security
  1. Previlged User Monitoring

  2. Application Activity Monitoring

  3. Cyberattack Protection

  4. Database Recovery

Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

A Database Activity Monitor (DAM) is designed to monitor, log, and analyze database transactions for compliance and security (such as privileged user and application activity monitoring, and cyberattack protection). Database recovery is a function of database backup/restore systems and DBMS engines, not a DAM tool.

Multiple choice
  1. DataAdapter Object

  2. DataReader Object

  3. DbConnection

  4. DbCommand

  5. DataTable

Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

The DataAdapter object acts as a mediator between the DataSet object and the database. This helps the data set to contain data from more than one databases or other data source. It must be provided with a set of data commands and a database connection used to fill the DataSet and update a database.

Multiple choice
  1. SQLDatabase

  2. SQLite database

  3. access database

  4. android database

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Android's built-in database support is SQLite, a lightweight relational database engine. Developers interact with it through Android's SQLite API and SQLiteDatabase class, not through SQLDatabase, Access, or any custom 'android database'.

Multiple choice
  1. hash map

  2. key–value pair

  3. built in database

  4. None of these

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

SharedPreferences stores data as key-value pairs internally. Under the hood, these are saved as XML files in the app's private directory, but the abstraction model is a simple key-value map, not a hash map (the internal implementation detail) or a built-in database.

Multiple choice
  1. SQLiteHelper

  2. SQLiteDatabase

  3. SQLiteOpenHelper

  4. SQLiteConnector

Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

SQLiteOpenHelper is the helper class that manages database creation, version management, and upgrades. It provides onCreate() and onUpgrade() callback methods. The actual database instance is SQLiteDatabase, but SQLiteOpenHelper is the class you extend to implement database management.