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 crystal report-reporting
  1. Database Fields

  2. Formula Fields

  3. Another Text Object

  4. Special Fields

Reveal answer Fill a bubble to check yourself
A,C,D Correct answer
Explanation

Text objects in Crystal Reports can embed database fields to display data, other text objects for complex formatting, and special fields like page numbers or dates. Formula fields are typically separate objects that perform calculations, not embedded content within text objects.

Multiple choice sap abap
  1. Index Table

  2. Hashed table

  3. Sorted Table

  4. Standard Table

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

SAP ABAP defines three Standard Internal Table types: Standard Table (default, unsorted), Sorted Table (automatically sorted by key), and Hashed Table (accessed by hash algorithm). 'Index Table' is not a separate table type - it's a category that includes Standard and Sorted tables which can be accessed by index. The question asks what is NOT a type.

Multiple choice sap abap
  1. Call transaction

  2. Session method

  3. Direct input method

  4. All of the Above

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

BDC (Batch Data Communication) in SAP supports three techniques: Call Transaction (direct, synchronous processing), Session Method (creates sessions to be processed later), and Direct Input Method (for bulk data transfer via special interface). Since all three are valid techniques, 'All of the Above' is the correct answer.

Multiple choice sap abap
  1. Table

  2. Function Module

  3. Domain

  4. Structure

Reveal answer Fill a bubble to check yourself
A,C,D Correct answer
Explanation

In the ABAP Data Dictionary, the core objects are Tables (store data), Domains (define field technical properties like type and length), and Structures (define complex types without storage). Function Modules are code objects stored in the Function Builder, not dictionary objects used for data definitions.

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