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
-
Integration Data Manipulate Structure
-
Internet Data Management system
-
International Data Minded System
-
Integrated Database Management System
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.
-
Database market leader Oracle will force customers to use Solaris as prefered OS.
-
SAP and IBM concerns have forced EU to raise issues on the deal.
-
It's regarding accquire of Sun's open source MySQL database product.
-
EU suspects the deal value is very less.
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.
-
column
-
relation
-
row
-
operator
C
Correct answer
Explanation
In relational database terminology, a row (also called a tuple or record) represents a single complete entry in a table. Columns contain attributes/fields, and a row contains all the values for one entity. A relation is the table itself, not a single record.
-
Flat file, network, relational, and objected oriented
-
Hierarchical, indexed, network, and relational
-
Hierarchical, flat file, network, and objected oriented
-
Hierarchical, network, relational, and objected oriented
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.
-
DB2PIAC
-
DBQPIAC
-
IAC
-
None Of the above.
-
Java Database Community
-
Java Database Connectivity
-
Java Development Connectivity
-
Java Database Classes
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.
-
Oracle Database Lite
-
Oracle Mobile
-
Oracle Micro
-
Oracle Database Mini
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.
-
A tool to provide database statistics from Compuware
-
A data mining and predictive analytics module of WebFocus BI Suite from Information Builders
-
A tool from HP for developing statistical reporting applications
-
IBMs DB2 statistics used by DBAs
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.
-
Microsoft Database
-
Microsoft Access Database
-
Microsoft DBase
-
Microsoft Data Backup
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.
-
IBM
-
Oracle
-
Microsoft
-
None of these
C
Correct answer
Explanation
Microsoft SQL Server Express is the free edition of Microsoft's SQL Server database system. Express editions are lightweight versions of enterprise software. Oracle and IBM have their own database products but not called Express.
-
Airways
-
Standard Terminal Arrival (STAR)
-
Runways
-
Vertical Navigation (VNAV)
-
Standard Instrument Departure (SID)
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.
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.
-
Ingress
-
PostgreSQL
-
MySql
-
All of the Above
D
Correct answer
Explanation
Ingress, PostgreSQL, and MySQL are all open source databases. Ingress was one of the earliest open source databases, while PostgreSQL and MySQL remain among the most widely used open source databases today.
-
Red List
-
Red Book
-
Blue Book
-
White List
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.
-
Tables
-
Macros
-
Oureies
-
Datasheets