Computer Knowledge

Database Management Systems

5,344 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 of the following is true?

  1. Logical design is software dependent.

  2. In a distributed database, database is stored in one physical location.

  3. Conceptual design translates the logical design into internal model.

  4. Logical design is software independent.

  5. None of these
Reveal answer Fill a bubble to check yourself
A Correct answer
Multiple choice

Which of the following statements is incorrect about Decision Support System?

  1. Decision Support System is computer based information system.

  2. Decision Support System uses analytical models and specialised databases.

  3. Decision Support System is necessary for the manager's perspective.

  4. Decision Support System is needed at each step in the organisational task.

  5. Decision Support System can be performed by any member in the business hierarchy.
Reveal answer Fill a bubble to check yourself
E Correct answer
Explanation

DSS can be performed by the manager or the topmost employee of the organisational hierarchy.

Multiple choice

Which systems are well integrated systems that store, retrieve and process different types of data such as text, graphics, images, full motion video, audio and animation?

  1. Office automation systems

  2. Multimedia system

  3. Executive information systems

  4. Word processing

  5. Query support
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

These systems are well integrated systems that store, retrieve, and process different types data such as text, graphics, images, full motion video, audio and animation.

Multiple choice

Which databases help to store the data where it is most needed or used, and help to customize the data to meet the needs of individual business units?

  1. Object oriented database

  2. Relational database

  3. Entity

  4. Distributed database

  5. Client server architecture model
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Distributed databases help to store the data where it is most needed or used, and help to customize the data to meet the needs of individual business units.