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
-
Transaparent table
-
Pooled table
-
Cluster table
-
Internal table
C
Correct answer
Explanation
Transparent tables can be buffered (single or full record), Pooled tables use table buffers, and Internal tables are in-memory structures. Cluster tables cannot be buffered - they store complex data structures across multiple rows and are always read directly from the database. Buffering would be ineffective due to their clustered nature.
-
User Maintenance
-
Document maintenance
-
DB Performance Monitor
-
Data browser, view/add table data
D
Correct answer
Explanation
SE16 is the data browser transaction in SAP. It provides direct access to database tables, allowing users to view, browse, and sometimes edit table data. This is essential for data inspection and troubleshooting without writing ABAP code.
-
DB Performance Monitor
-
Business objects builder
-
Message Maintenance
-
SAP Data transfer workbench
A
Correct answer
Explanation
ST04 is the database performance monitor transaction in SAP. It provides real-time and historical statistics about database activity including buffer hit ratios, SQL statement performance, table access statistics, and overall database health metrics.
-
Atomicity Consistency Isolation Durability
-
Atomic Consistent Isolate Durability
-
Atomicity Consistency Isolation Durable
-
Atomicity Consistency Isolated Durabille
A
Correct answer
Explanation
ACID in database systems represents the four key properties that guarantee reliable transaction processing: Atomicity (all-or-nothing execution), Consistency (database remains valid), Isolation (transactions don't interfere), and Durability (committed data persists). Option A correctly uses the consistent noun form 'Durability' rather than 'Durable'.
A
Correct answer
Explanation
ODBC does stand for Open Database Connectivity, a standard API for accessing database management systems. It allows applications to communicate with different databases using a common interface, regardless of the underlying database system.
-
String
-
Field
-
Database
-
Record
C
Correct answer
Explanation
A database is defined as an organized collection of related data or files stored together, typically with a structured format that allows efficient retrieval, updating, and management. Files contain related records, records contain related fields, and fields contain the actual data items. This hierarchical organization is fundamental to database management systems.
-
String
-
Field
-
Database
-
Record
C
Correct answer
Explanation
A database is an organized collection of related data files that allows for efficient storage, retrieval, and management. Records are individual entries, fields are attributes within records, and strings are data types - none represent the collection itself.
-
String
-
Field
-
Database
-
Record
C
Correct answer
Explanation
A database is an organized collection of related data files that allows for efficient storage, retrieval, and management. Records are individual entries, fields are attributes within records, and strings are data types - none represent the collection itself.
-
String
-
Field
-
Database
-
Record
C
Correct answer
Explanation
A database is an organized collection of related data files or records. The question has a typo ('calles' should be 'called'), but the concept is correct. A string is a sequence of characters, a field is a single data element, and a record is a complete set of related fields - none of these represent a collection of files.
-
The DBA
-
System
-
Oracle
-
SYS
D
Correct answer
Explanation
In Oracle databases, the SYS user owns the data dictionary tables and associated objects. The data dictionary contains metadata about the database structure, users, privileges, and all database objects. It's a critical component that Oracle uses to manage and control the database, accessible through views like DBA_, ALL_, and USER_.
-
With an SQL query
-
With an XML query
-
With ETL data extraction
-
With WebData scrapper
A
Correct answer
Explanation
Data for Excel reports in Quality Center is defined using SQL queries. These queries extract data from the QC database to populate the report with specific, filtered information.
-
OCB/OCD
-
DBA/DBD
-
OCA/OCP
-
None of the above
C
Correct answer
Explanation
OCA (Oracle Certified Associate) and OCP (Oracle Certified Professional) are Oracle Corporation's database certification programs. These certifications validate expertise in Oracle database administration, with OCA being the entry-level and OCP the professional-level credential.
-
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.