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
-
Scientific Data Transmission Model
-
Scientific Data Tabulation Method
-
Study Data Tabulation Model
-
None of the above
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.
-
Clinical Data Management System
-
Clinical Data for Medical Sciences
-
Closed Demographic data Management Study
-
None of the above
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.
-
Oracle
-
.Net
-
Salesforce
-
SAP
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.
-
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.
-
reboot file
-
reload file
-
.autorelabel file
-
.auto load file
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.
-
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.