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 sap abap
  1. Transaparent table

  2. Pooled table

  3. Cluster table

  4. Internal table

Reveal answer Fill a bubble to check yourself
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.

Multiple choice abap
  1. User Maintenance

  2. Document maintenance

  3. DB Performance Monitor

  4. Data browser, view/add table data

Reveal answer Fill a bubble to check yourself
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.

Multiple choice abap
  1. DB Performance Monitor

  2. Business objects builder

  3. Message Maintenance

  4. SAP Data transfer workbench

Reveal answer Fill a bubble to check yourself
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.

Multiple choice general knowledge
  1. Atomicity Consistency Isolation Durability

  2. Atomic Consistent Isolate Durability

  3. Atomicity Consistency Isolation Durable

  4. Atomicity Consistency Isolated Durabille

Reveal answer Fill a bubble to check yourself
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'.

Multiple choice general knowledge science & technology
  1. String

  2. Field

  3. Database

  4. Record

Reveal answer Fill a bubble to check yourself
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.

Multiple choice general knowledge science & technology
  1. String

  2. Field

  3. Database

  4. Record

Reveal answer Fill a bubble to check yourself
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.

Multiple choice general knowledge science & technology
  1. String

  2. Field

  3. Database

  4. Record

Reveal answer Fill a bubble to check yourself
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.

Multiple choice general knowledge science & technology
  1. String

  2. Field

  3. Database

  4. Record

Reveal answer Fill a bubble to check yourself
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.

Multiple choice general knowledge
  1. The DBA

  2. System

  3. Oracle

  4. SYS

Reveal answer Fill a bubble to check yourself
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_.

Multiple choice general knowledge science & technology
  1. OCB/OCD

  2. DBA/DBD

  3. OCA/OCP

  4. None of the above

Reveal answer Fill a bubble to check yourself
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.

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.