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
-
SQL server 2005
-
MS Access
-
MS Excel
-
SQL Server Express
D
Correct answer
Explanation
ASP.NET 2.0's membership and roles system stores user authentication and authorization data in SQL Server Express by default. This provides a free, embedded database option for user management without requiring a full SQL Server license.
-
As many rows as the number of disconnected lines
-
One
-
No new rows will be generated
-
As many as the actual lines in the account.
A
Correct answer
Explanation
A disconnected order generates one row per disconnected line in OE. Each line needs its own row for proper tracking and processing.
-
As many rows as the number of disconnected lines
-
One
-
No new rows will be generated
-
As many as the actual lines in the account.
-
Server Explorer
-
Solution Explorer
-
Properties Window
-
Toolbox
A
Correct answer
Explanation
Server Explorer in Visual Studio enables you to work with database connectivity - you can create, modify, and delete database connections, view database objects, and drag tables onto your designer. Solution Explorer manages project files, Properties Window shows component settings, and Toolbox contains UI controls.
-
unordered and non hierarchical data base
-
sequential and hierarchical data base
-
sequential and non hierarchical data base
-
unordered and hierarchical data base
C
Correct answer
Explanation
GSAM (Generalized Sequential Access Method) is designed for sequential, non-hierarchical data storage. Unlike other DL/I access methods, GSAM does not organize data in hierarchical parent-child relationships but processes records sequentially.
-
MyCo-Orders
-
Orders
-
MyCoOrders
-
mycoorders
C
Correct answer
Explanation
Pega's naming convention for RuleSets recommends PascalCase (compound words with each word capitalized, no spaces or hyphens). 'MyCoOrders' follows this convention correctly. 'MyCo-Orders' uses a hyphen (incorrect), 'Orders' is a single word (not a proper compound), and 'mycoorders' is lowercase (incorrect). The correct format is company name concatenated with purpose, both in PascalCase.
-
One-to-one
-
Many-to-one
-
One-to-many
-
Many-to-many
D
Correct answer
Explanation
A Folder can contain multiple items, and each item can belong to multiple Folders simultaneously. This many-to-many relationship is fundamental to Pega's folder structure, allowing flexible categorization where a work object can appear in different folders without duplication.
-
Is any set of related work objects
-
Causes the system to store the instances corresponding to two or more concrete classes that have a common key format in a single database table
-
Is unrelated to your application’s Reporting requirements
-
None of the above
B
Correct answer
Explanation
A class group enables multiple concrete classes with a common key format to share a single database table. This optimizes storage and supports reporting across related classes. Class groups are directly related to reporting requirements in Pega applications.
A
Correct answer
Explanation
The java.sql package provides JDBC interfaces for connecting to relational databases, issuing SQL statements, and processing result sets. This matches the definition, so the True option is correctly marked.
A
Correct answer
Explanation
DB2 is indeed a relational database management system (RDBMS) from IBM. It follows the relational model with tables, rows, columns, keys, and uses SQL as its query language. This is a fundamental characteristic of DB2.
A
Correct answer
Explanation
SSIS connection managers provide connectivity to various data sources. Analysis Services Connection Manager is indeed available for connecting to SSAS cubes and databases. This is a standard connection manager type in SSIS.
B
Correct answer
Explanation
OLE DB Connection Manager is commonly used to connect to Oracle databases in SSIS. The statement claims OLE DB is NOT used, which is false. OLE DB providers for Oracle are standard in SSIS.
A
Correct answer
Explanation
OLE DB Command in Data Flow can execute stored procedures per row. It passes row values as parameters to the stored procedure. This is a valid approach for parameterized database calls in data flow.
-
Oracle Advanced Queuing
-
DBMS_JOB
-
DBMS_SQL
-
Pipelined Functions
C
Correct answer
Explanation
Oracle Advanced Queuing enables asynchronous message processing. DBMS_JOB schedules jobs for concurrent execution. Pipelined Functions allow streaming and parallel processing. DBMS_SQL is for dynamic SQL execution within a single program - it does NOT facilitate running multiple PL/SQL programs simultaneously.
-
SELECT name FROM USER_DEPENDENCIES WHERE referenced_name = 'DBMS_OUTPUT.PUT_LINE'
-
SELECT name from ALL_SOURCE WHERE owner = USER AND name = 'DBMS_OUTPUT.PUT_LINE'
-
SELECT DISTINCT name from ALL_SOURCE WHERE INSTR (text, 'DBMS_OUTPUT.PUT_LINE') > 0
-
SELECT DISTINCT name from USER_SOURCE WHERE INSTR (UPPER (text), 'DBMS_OUTPUT.PUT_LINE') > 0
D
Correct answer
Explanation
USER_SOURCE contains PL/SQL source code for your schema. INSTR(UPPER(text), 'DBMS_OUTPUT.PUT_LINE') searches within the code body for calls to that procedure. DISTINCT removes duplicates. Option A uses dependencies (not body content). B searches wrong column and uses ALL_SOURCE. C uses ALL_SOURCE instead of USER_SOURCE.