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
-
Database Fields
-
Formula Fields
-
Another Text Object
-
Special Fields
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.
-
Index Table
-
Hashed table
-
Sorted Table
-
Standard Table
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.
-
Call transaction
-
Session method
-
Direct input method
-
All of the Above
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.
-
Table
-
Function Module
-
Domain
-
Structure
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.
-
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.
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.