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 general knowledge
  1. Integration Data Manipulate Structure

  2. Internet Data Management system

  3. International Data Minded System

  4. Integrated Database Management System

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

IDMS stands for Integrated Database Management System, which is a specific network database management system product. Option D correctly identifies this standard expansion. Options A, B, and C are incorrect combinations of words that do not represent the actual meaning of IDMS.

Multiple choice general knowledge
  1. Database market leader Oracle will force customers to use Solaris as prefered OS.

  2. SAP and IBM concerns have forced EU to raise issues on the deal.

  3. It's regarding accquire of Sun's open source MySQL database product.

  4. EU suspects the deal value is very less.

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

The EU's primary objection to Oracle's acquisition of Sun Microsystems concerned MySQL, Sun's open-source database product. Regulators feared Oracle could harm MySQL's open-source nature given Oracle's dominance in the proprietary database market. This was about competition in the database market, not OS preferences, concerns from SAP/IBM, or the deal's financial valuation.

Multiple choice general knowledge science & technology
  1. Flat file, network, relational, and objected oriented

  2. Hierarchical, indexed, network, and relational

  3. Hierarchical, flat file, network, and objected oriented

  4. Hierarchical, network, relational, and objected oriented

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

The four fundamental database models are hierarchical (tree structure), network (graph structure allowing many-to-many relationships), relational (table-based with SQL), and object-oriented (stores objects directly). Option D correctly lists these four types, though 'objected oriented' contains a typo.

Multiple choice general knowledge science & technology
  1. Java Database Community

  2. Java Database Connectivity

  3. Java Development Connectivity

  4. Java Database Classes

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

JDBC stands for Java Database Connectivity, a Java API that defines how a client may access a database. It provides methods to query and update data in a database, and is oriented towards relational databases. The other options are fabricated or incorrect expansions.

Multiple choice general knowledge science & technology
  1. Oracle Database Lite

  2. Oracle Mobile

  3. Oracle Micro

  4. Oracle Database Mini

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

Oracle Database Lite was indeed Oracle's lightweight database solution designed specifically for mobile devices and embedded systems. It provided a smaller footprint version of Oracle's enterprise database for resource-constrained environments. The other options (Mobile, Micro, Mini) are not actual Oracle product names for mobile databases.

Multiple choice general knowledge science & technology
  1. A tool to provide database statistics from Compuware

  2. A data mining and predictive analytics module of WebFocus BI Suite from Information Builders

  3. A tool from HP for developing statistical reporting applications

  4. IBMs DB2 statistics used by DBAs

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

RStat is the data mining and predictive analytics module within Information Builders' WebFocus BI Suite. The other options are incorrect - Compuware, HP, and IBM DB2 are not associated with RStat.

Multiple choice general knowledge
  1. Microsoft Database

  2. Microsoft Access Database

  3. Microsoft DBase

  4. Microsoft Data Backup

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

MDB is an abbreviation that can refer to Microsoft Database or Microsoft Access Database. In the context of Microsoft products, it most commonly refers to Microsoft Access Database (.mdb file extension), which was the database file format used by Microsoft Access prior to the ACCDB format.

Multiple choice general knowledge
  1. Airways

  2. Standard Terminal Arrival (STAR)

  3. Runways

  4. Vertical Navigation (VNAV)

  5. Standard Instrument Departure (SID)

Reveal answer Fill a bubble to check yourself
A,B,C,E Correct answer
Explanation

Navigation databases contain procedural data needed for flight planning: airways (routes), SIDs (instrument departure procedures), STARs (standard arrival routes), and runway information. VNAV (Vertical Navigation) is a flight mode capability, not a data element stored in the navigation database.

Multiple choice general knowledge
  1. Microsoft

  2. Sun

  3. IBM

  4. Cisco

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

SQL (Structured Query Language) was developed by Donald D. Chamberlin and Raymond F. Boyce at IBM in the early 1970s. It was originally called SEQUEL. Microsoft developed SQL Server (a database system), Sun was known for Java and MySQL acquisition, and Cisco focuses on networking equipment.

Multiple choice general knowledge
  1. Red List

  2. Red Book

  3. Blue Book

  4. White List

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

A White List in card-based systems contains the database of all authorized card numbers that are permitted to process transactions. This is a security measure to ensure only valid, approved cards can be used. Red List and other color-coded lists refer to different security concepts in payment systems.