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 technology programming languages
  1. Data Element

  2. Domain

  3. Predefined

  4. All the Above

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

In ABAP Dictionary, the Domain defines the complete technical definition of a field - including data type, length, decimal places, and output format. The Data Element provides semantic information and references a Domain, but the technical attributes come from the Domain. 'Predefined' is not a valid concept in this context. So Domain is the correct answer.

Multiple choice technology programming languages
  1. One

  2. Multiple

  3. Two

  4. None

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

In the SAP ABAP Dictionary, a data element defines semantic properties and can be associated with at most one domain, which defines the technical properties like data type and length. A data element cannot reference multiple domains simultaneously.

Multiple choice technology programming languages
  1. Nothing

  2. Domain

  3. Values

  4. Data Element

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

Search help parameters must be assigned to Data Elements. The Data Element provides the necessary type information (via its Domain) and semantic description needed for the search help to function correctly. You don't assign Domains directly to search help parameters, and 'Nothing' or 'Values' are not valid answers.

Multiple choice technology programming languages
  1. True

  2. False

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

Function modules in SAP ABAP must be assigned to a function group. The function group serves as a container and provides shared memory context for all function modules within it. You cannot create a function module without specifying a function group.

Multiple choice technology programming languages
  1. BAPIRET2

  2. BAPIRETURN

  3. BAPIRET

  4. All the Above

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

All three structures (BAPIRET2, BAPIRETURN, BAPIRET) are used as return parameter types in SAP BAPIs. BAPIRET2 is the current standard and recommended type. BAPIRETURN is the older/obsolete structure. BAPIRET is also a return structure type. The question uses 'All the Above' to acknowledge that all are valid return parameter structures, though BAPIRET2 is the modern choice.

Multiple choice technology packaged enterprise solutions
  1. Data Element

  2. Domain

  3. Predefined

  4. All the Above

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

In SAP ABAP Dictionary, a field's complete technical definition (data type, length, decimal places, output format) is defined by its domain. The domain specifies all technical attributes, while the data element contains the semantic description (field labels, documentation) and references the domain. 'Predefined' is not a valid Dictionary object, and 'All the Above' is incorrect because only the Domain defines technical attributes.

Multiple choice technology packaged enterprise solutions
  1. Nothing

  2. Domain

  3. Values

  4. Data Element

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

Search help parameters must be assigned to a data element. The data element provides the parameter's definition including its semantic properties (description) and references a domain for technical attributes (data type, length). This ensures the search help parameter knows what type of data to handle and how to describe it to users.

Multiple choice technology
  1. Transaction processing system

  2. Decision support system

  3. Executive information system

  4. Management information system

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

Decision Support Systems (DSS) are specifically designed to summarize data and prepare reports for functional areas by analyzing organizational data. Management Information Systems (MIS) also provide reports but are more operational. Transaction Processing Systems handle routine transactions, and Executive Information Systems serve senior executives with strategic information.

Multiple choice technology
  1. Organized mainly hieratically.

  2. Processed in distributed fashion

  3. Organized for end users

  4. Are non routine and do not recur often

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

Transaction processing systems typically process transactions in a distributed fashion across different locations and systems to support business operations. Data is organized operationally, not hierarchically for end users. TPS data is routine and recurring, unlike the non-routine nature of analytical systems.

Multiple choice technology
  1. Are organized by end users

  2. Are coded consistently

  3. Are updated in real time

  4. Are organized in a hierarchical structure

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

Data warehouse data is organized in a hierarchical structure (dimensions and facts organized in schemas like star schema) to facilitate querying and analysis. Unlike TPS data, warehouse data is not updated in real-time (it's periodically refreshed). Data is coded consistently but that's not the primary characteristic mentioned in options.

Multiple choice technology
  1. Subset of an organizational data store

  2. Usually oriented to a specific purpose or major data subject

  3. Are analytical data stores designed to focus on specific business functions

  4. All of the above

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

A data mart is all of these: a subset of an organizational data store (focused scope), usually oriented to specific purposes or major data subjects (like sales, finance), and is an analytical data store designed for specific business functions. Data marts are smaller, more focused versions of data warehouses serving particular departments or business lines.

Multiple choice technology databases
  1. TIMESTAMP

  2. INTERVAL MONTH TO DAY

  3. INTERVAL DAY TO SECOND

  4. INTERVAL YEAR TO MONTH

  5. TIMESTAMP WITH DATABASE TIMEZONE

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

TIMESTAMP, INTERVAL DAY TO SECOND, and INTERVAL YEAR TO MONTH are valid Oracle datetime types. Option B 'INTERVAL MONTH TO DAY' doesn't exist (it should be MONTH TO YEAR or DAY TO MONTH). Option E 'TIMESTAMP WITH DATABASE TIMEZONE' doesn't exist (should be WITH TIMEZONE or WITH LOCAL TIMEZONE).

Multiple choice technology testing
  1. CO1 might be received into any other test bed ( Due to incorrect configuration in ALSB/WLI end points)

  2. Oracle Database is pointing to more than one WLI instance

  3. Order might be back ordered

  4. Both a and b

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

If CO1 is sent but not visible, it could be due to incorrect routing in ALSB/WLI endpoints to another test bed, or the Oracle Database pointing to multiple WLI instances. Back-ordering is an Oracle status and does not prevent transmission visibility.

Multiple choice technology testing
  1. wli_logging.XXRCI_commonlog

  2. XXRCI.XXRCI_ERROR_TRACKING

  3. None of the above

  4. all

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

For tracking inbound interface errors (like CO2 documents) in custom Oracle integrations, errors are typically logged in a common logging table like wli_logging.XXRCI_commonlog. XXRCI.XXRCI_ERROR_TRACKING is a distractor.