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

An abstract data type is used to

  1. link data from remote databases

  2. prevent users from getting to database security information

  3. provide a conceptual view of the data so it is easier to understand

  4. store complex data structure to represent the properties of objects
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

null

Multiple choice

The primary difference between the Relational database (RDB) and Object Oriented database (OODB) models is

  1. OODB incorporates methods in with the definition of the data structure, while RDB does not

  2. OODB supports multiple objects in the same database while RDB only supports a single table per database

  3. RDB allows the definition of the relationships between the different tables, while OODB does not allow the relationships to be defined between objects

  4. RDB supports indexes, while OODB does not support indexes
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

null

Multiple choice

The process of maintaining a log of all access-related activities of the user in the system including user login, resource access, etc. is

  1. data management

  2. authorisation

  3. security auditing

  4. securitisation

  5. None of these
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Security auditing is the process of evaluating system reports to find whether the system is according to the standard security norms or not. It includes collection of information like user’s access activities, resource access, etc.

Multiple choice

In OLTP, normalisation of database is done to

  1. make the operational data dynamic

  2. facilitate insertion, deletion and updation of data

  3. store the data at microscopic level

  4. reduce the response time of the system

  5. facilitate queries and analysis
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

OLTP stands for 'on line transaction processing'. In it, normalisation of database is done to facilitate insertion, deletion and updation of data.