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

Which generation tool interacts with the DBMS?

  1. Ist generation

  2. IInd generation

  3. IIIrd generation

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

Fourth-generation languages (4GL) are designed to be closer to human language and are specifically built to interact with databases (DBMS) using tools like SQL.

Multiple choice

Which of the following is called the security technique(s) while Committing Transactions in Oracle P/L SQL?

  1. It makes the changes permanent and affects the savepoints.

  2. The changes are not final.

  3. The changes are not visible to other users of the database instance.

  4. The newest Database Express Edition issues an implicit COMMIT statement before and after any data definition language (DDL) statement.

  5. The data restoration process will be at one point.
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

The changes are visible to user, but not to other users of the database instance. It makes the database secure and authenticated.

Multiple choice

Which of the following is the incorrect statement about the P/L SQL package in the database?

  1. A package in a PL/SQL unit is a combination of related programs.

  2. Packages allow you to hide implementation details from client programs.

  3. It does not allow client programs to access the database only by invoking PL/SQL subprograms.

  4. The package subprograms must be qualified with package names when invoked from outside the package.

  5. The package subprograms are arranged in a well defined module for each user.
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Many Oracle customers follow this practice strictly, allowing client programs to access the database only by invoking PL/SQL subprograms.

Multiple choice

Which of the following databases in RDBMS contains data assisting needs of middle management to monitor and control business activities by effective and efficient management of men, machines and money?

  1. Strategic planning database

  2. Control database

  3. Operational database

  4. Single global database

  5. Storage database
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

This type of database in RDBMS contains data assisting needs of middle management to monitor and control business activities by effective and efficient management of men, machines and money.

Multiple choice

Which of the following HDBMS (Hierarchical DBMS) modules processes HSQL query statement and translates them into intermediate tree representation containing algebraic operations?

  1. Terminal interface

  2. Schema processor

  3. Query processor

  4. Query optimiser and Access planner

  5. Query Execution module
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

This HDBMS module processes HSQL query statement and translates them into an intermediate tree representation containing algebraic operations.