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
  1. computer technicalities

  2. faster transactions

  3. real time system

  4. data corrections

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

Real-time processing means data is updated immediately as transactions occur, keeping files current with the latest transaction data. This contrasts with batch processing, where updates are done periodically. Real-time systems are essential for applications requiring up-to-the-minute accuracy.

Multiple choice
  1. File Management System

  2. Network Database System

  3. Relation Database System

  4. Hierarchical Database System

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

File Management Systems (FMS) were the earliest method for storing computerized data, using flat files to organize information before more sophisticated database systems were developed.

Multiple choice
  1. File Management System

  2. Network Database System

  3. Relation Database System

  4. Hierarchical Database System

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

Hierarchical database systems organize data in a tree-like structure with parent-child relationships, where each parent can have multiple children but each child has only one parent. Examples include IMS (IBM Information Management System) and Windows Registry. File management systems don't inherently use parent-child structures, network databases use graph structures, and relational databases use tables with relationships.

Multiple choice
  1. Data Definition Language

  2. Direct Definition Language

  3. Data Defined Language

  4. Daily Definition Language

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

This is correct because DDL, in oracle, is known as Data Definition Language and it is also used in Oracle to create and remove database objects. It is a SQL plus command and it has an online commands interpreter. The main example of Data Definition Language (DDL) are - CREATE, ALTER, DROP. 

Multiple choice
  1. Relational Direct Management System

  2. Regional Database Management System

  3. Relational Database Management System

  4. All of the above

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

RDBMS means Relational Detabase Management System which provides the user facility to store and retrieve data in a manner consistent with defined model. RDBMS provides the user facility to store and retrieve data in a manner consistent with a defined model. The relational model has three models (1) Structural model to build the model (2) Integrity component and (3). Manipulation component. 

Multiple choice
  1. Data Manipulation Language

  2. Design Manipulation Language

  3. Divided Manipulation Language

  4. Data Master Language

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

Right answer because DML is one category in SQL Commands which is known as Data Manipulation Language. DML (Data Manipulation Language) is used to manipulate the data in the database. For example-: INSERT, DELETE, UPDATE, SELECT etc.

Multiple choice
  1. Data Control Language

  2. Data Cost Control Language

  3. Demand Control Language

  4. Database Control Language

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

Right answer because the full name of DCL is  Data Control Language and  there are three SQL Commands in Oracle. These are; DDL(Data Definition Language) , DML (Data Manipulation Language) and DCL (Data Control Language).   

Multiple choice
  1. Database Mechanical System

  2. Database Management System

  3. Database Machine System

  4. None of these

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

DBMS stands for Database Management System, which is software that manages databases. It provides an interface for users to create, retrieve, update, and delete data in a systematic way. Examples include MySQL, PostgreSQL, Oracle, and Microsoft SQL Server. The other options are incorrect expansions of the acronym.

Multiple choice
  1. database

  2. table

  3. entity relationship diagram

  4. virtual table

  5. schema

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

A view is a virtual table.