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
-
Data Element
-
Domain
-
Predefined
-
All the Above
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.
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.
-
Nothing
-
Domain
-
Values
-
Data Element
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.
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.
-
BAPIRET2
-
BAPIRETURN
-
BAPIRET
-
All the Above
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.
-
Data Element
-
Domain
-
Predefined
-
All the Above
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.
A
Correct answer
Explanation
In the SAP ABAP Dictionary, a data element represents the semantic definition of a field, while a domain represents its technical definition. A data element can be assigned to exactly one domain to inherit its data type, length, and value range.
-
Nothing
-
Domain
-
Values
-
Data Element
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.
-
Transaction processing system
-
Decision support system
-
Executive information system
-
Management information system
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.
-
Organized mainly hieratically.
-
Processed in distributed fashion
-
Organized for end users
-
Are non routine and do not recur often
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.
-
Are organized by end users
-
Are coded consistently
-
Are updated in real time
-
Are organized in a hierarchical structure
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.
-
Subset of an organizational data store
-
Usually oriented to a specific purpose or major data subject
-
Are analytical data stores designed to focus on specific business functions
-
All of the above
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.
-
TIMESTAMP
-
INTERVAL MONTH TO DAY
-
INTERVAL DAY TO SECOND
-
INTERVAL YEAR TO MONTH
-
TIMESTAMP WITH DATABASE TIMEZONE
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).
-
CO1 might be received into any other test bed ( Due to incorrect configuration in ALSB/WLI end points)
-
Oracle Database is pointing to more than one WLI instance
-
Order might be back ordered
-
Both a and b
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.
-
wli_logging.XXRCI_commonlog
-
XXRCI.XXRCI_ERROR_TRACKING
-
None of the above
-
all
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.