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 packaged enterprise solutions

What is the flow action used to create new versions of existing file attachments.

  1. CreateNewVersion

  2. CreateNewAttachment

  3. CreateNewVersionAttachment

  4. EditAttachment
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

EditAttachment is the correct flow action in Pega PRPC for creating new versions of existing file attachments. CreateNewVersion and CreateNewAttachment are not standard flow actions. The EditAttachment action handles versioning by creating a new version when editing an existing attachment.

Multiple choice technology databases

How do you ensure re start ability of jobs within a sequencer.What options need to be checked for this?

  1. Automatically handle activities that fail

  2. Add checkpoints so sequence is restartable on failure

  3. Log warnings after activities that finish with status other than ok

  4. Log report messages after each job run
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

To enable restartability in a DataStage sequence, you add checkpoints. Checkpoints save the state of the sequence after each job, allowing the sequence to resume from the last checkpoint after failure, rather than restarting from the beginning.

Multiple choice technology mainframe

What are the various types of VSAM Data Organizations available?

  1. PSDS, KADS, RRDS, VRRDS, LRDS

  2. ESDS, KSDS, RRDS, VRRDS, LDS

  3. ESDS, KRDS, RRDS, VLDS, VKDS

  4. PSDS, RKDS, KSDS, FRDS, LLDS
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

VSAM datasets support five types of organizations: Entry Sequenced (ESDS), Key Sequenced (KSDS), Relative Record (RRDS), Variable-length Relative Record (VRRDS), and Linear Data Sets (LDS). Other options are incorrect because they introduce invalid abbreviations such as PSDS, KADS, or LLDS, which do not exist in VSAM storage systems.

Multiple choice technology testing

What are the tools used for Database Testing?

  1. DataGenerator and TestDataGenerator

  2. Load Runner and QTP

  3. Winrunner

  4. Quality Center
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

DataGenerator and TestDataGenerator are specialized tools for database testing that create realistic test data for validation. While LoadRunner, QTP, WinRunner, and Quality Center are testing tools, they focus on performance, functional, or test management rather than data generation. Data generation is critical for comprehensive database testing.

Multiple choice technology testing

What is used to check data loading during database testing?

  1. Query Tracker

  2. Query Loader

  3. Query Analyser

  4. Query Modifier
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Query Analyzer tools help monitor, trace, and analyze database queries during testing. They allow testers to verify data loads are executing correctly and efficiently by examining query execution plans, performance metrics, and results.

Multiple choice technology databases

What technique can Framework Manager modelers use to implement a time dimension for models that lack a time dimension?

  1. Create relationships from date fields inone dimension to date fields in another dimension.

  2. Use parameter maps to map date values in one query subject to date values in another query subject.

  3. Use theTime Dimension wizard togenerate a time dimension and create the appropriate relationships.

  4. Identify a time dimension table source, import into the model and create relationships to fact query subjects.
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

To implement a time dimension, Framework Manager modelers import an existing time dimension table into the model. They then create relationships between this time dimension and fact query subjects to enable temporal analysis.

Multiple choice technology databases

In Framework Manager, when using star schema groupings inthe business view, conformed dimensions can be identified bywhich one of the following?

  1. Using a different query subject icon for display inthe studios.

  2. Viewing the properties of the query subjects in Report Studio.

  3. Viewing the properties of the query subjects in Framework Manager.

  4. Using the same name for the dimension in each star schema grouping.
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

In Framework Manager's business view with star schema groupings, conformed dimensions are identified by using the same dimension name across multiple star schemas. This naming convention indicates that the dimension shares the same meaning and structure across different fact tables.

Multiple choice technology databases

If authors want to perform OLAP-style queries directly against a relational database, which Framework Manager modeling technique will a modeler use?

  1. Create regular and measure dimensions and set scope.

  2. Create shortcuts to regular dimensions and fact query subjects.

  3. Create star schema groupings for dimension and fact query subjects.

  4. Create relationships between regular dimensions andmeasure dimensions.
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

OLAP-style queries against relational databases (ROLAP) are enabled in Framework Manager by creating regular dimensions for descriptive attributes and measure dimensions for numeric facts, then setting their scope appropriately. This allows dimensional analysis directly on relational sources without pre-built cubes. Shortcuts and star schema groupings are different modeling techniques, and relationships between dimensions are fundamental modeling steps, not specific to enabling OLAP queries.

Multiple choice technology databases

What is true of a Framework Manager model of an operational database lacking a time dimension?

  1. Virtual star schema models require a time dimension for multi-fact queries.

  2. Report authors cannot create multi-fact, time-based queries.

  3. Time-based rollups for multi-fact queries may be difficult to handle.

  4. Report authors cannot create multi-fact, time-based queries unless using a union.
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

A time dimension is critical for multi-fact queries that need to align facts across time periods. Without it, time-based rollups (aggregating by day, month, quarter, etc.) become difficult because Framework Manager cannot automatically generate the necessary time joins and period alignments. Virtual star schemas do not strictly require a time dimension for all multi-fact queries, and authors can still create multi-fact time-based queries using other techniques like unions, though it becomes more complex.

Multiple choice technology databases

Which of the following do not help you execute multiple PL/SQL programs simultaneously?

  1. Oracle Advanced Queuing

  2. DBMS_JOB

  3. DBMS_SQL

  4. Pipelined Functions
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

DBMS_SQL is a package for dynamic SQL operations within a single session - it parses and executes SQL statements sequentially. Oracle Advanced Queuing, DBMS_JOB, and Pipelined Functions all support concurrent/parallel execution of multiple programs through queuing, job scheduling, and parallel query pipelining respectively.

Multiple choice technology security

What should I log from within my application?

  1. Login and logout of users, Critical transactions (eg. fund transfer across accounts), Failed login attempts, Account lockouts, Violation of policies

  2. Login and logout of users, Critical transactions (eg. fund transfer across accounts), Failed login attempts, Account lockouts, Violation of policies, Forgot password correct and wrong credentials

  3. Login and logout of users, Critical transactions (eg. fund transfer across accounts), Failed login attempts, Account lockouts, Violation of policies, password sharing logs

  4. Login and logout of users, Critical transactions (eg. fund transfer across accounts), Failed login attempts, Account lockouts, Violation of policies, password sharing logs, race condition logs
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Application security logging must capture authentication events (login, logout, failed attempts), policy violations, and critical transactions. Option B correctly adds 'Forgot password correct and wrong credentials' - this is crucial because it captures both successful and failed password reset attempts, which are sensitive authentication events. Options A, C, D are incorrect - C and D incorrectly include 'password sharing logs' and 'race condition logs' which are not standard application logging practices.

Multiple choice technology security

A tool that can perform ODBC commands on a SQL Server

  1. PSQL

  2. SQLCMD

  3. OSQL

  4. Postgre SQL
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

OSQL is a legacy command-line utility for SQL Server that uses ODBC APIs to run queries. PSQL and PostgreSQL are associated with PostgreSQL, and SQLCMD uses OLE DB or modern drivers rather than primarily targeting raw ODBC commands.