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 general knowledge
  1. Scientific Data Transmission Model

  2. Scientific Data Tabulation Method

  3. Study Data Tabulation Model

  4. None of the above

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

SDTM stands for Study Data Tabulation Model. It is a standard developed by CDISC for organizing and structuring data from clinical trials. The SDTM model provides a framework for submitting clinical trial data to regulatory authorities like the FDA in a standardized format, facilitating data review and submission processes.

Multiple choice general knowledge
  1. Clinical Data Management System

  2. Clinical Data for Medical Sciences

  3. Closed Demographic data Management Study

  4. None of the above

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

CDMS stands for Clinical Data Management System, a specialized software used to collect, clean, and manage clinical trial data. Option A correctly identifies this standard industry terminology. Options B and C incorrectly expand the acronym with unrelated terms.

Multiple choice general knowledge
  1. Oracle

  2. .Net

  3. Salesforce

  4. SAP

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

The TCS Legal Management Solution is built on the SAP platform. SAP is widely used in enterprise applications, including legal practice management. TCS has developed industry-specific solutions on SAP, including this legal management offering that provides case management, client tracking, and practice management capabilities.

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. reboot file

  2. reload file

  3. .autorelabel file

  4. .auto load file

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

Creating a .autorelabel file in the root directory triggers SELinux to relabel all files on the next system reboot. This is the correct method to reset SELinux security contexts after making extensive changes. The other options are not valid SELinux commands.

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.