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

Multiple choice technology databases

When WORKAREA_SIZE_POLICY is set to AUTO, the work areas are sized to accomplish which two goals? (Choose two)

  1. To tune memory using the existing *_AREA_SIZE parameters.

  2. To allocate memory to work areas in order to optimize throughput only.

  3. To allocate memory to work areas in order to optimize response time only.

  4. To allocate memory to work areas in order to optimize both throughput and response time.

  5. To ensure that the overall size of the PGA will never exceed the value of PGA_AGGREGATE_TARGET.
Reveal answer Fill a bubble to check yourself
D,E Correct answer
Explanation

When WORKAREA_SIZE_POLICY is set to AUTO, Oracle automatically manages PGA memory allocation. The policy aims to optimize both throughput (overall processing volume) and response time (individual query speed), while ensuring the total PGA memory stays within the PGA_AGGREGATE_TARGET limit.

Multiple choice technology databases

What should you look at first to compute the number of undo blocks that are consumed and estimate the size of the undo tablespace needed to handle the workload on your system?

  1. UNDOSTAT

  2. ROLLSTAT

  3. TRANSACTION

  4. DBA_UNDO_EXTENTS

  5. DBA_ROLLBACK_SEGS
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

The V$UNDOSTAT view (or UNDOSTAT) contains historical statistics to monitor and estimate the undo space requirements and transaction workloads on an Oracle database.

Multiple choice technology databases

Your database contains at least one undo tablespace. You attempt to start an instance in Automatic Undo Management mode, but without specifying an undo tablespace in the initialization parameter file. What happens?

  1. The instance will not start.

  2. The instance starts up and uses the SYSTEM rollback segment for all undo entries.

  3. The instance starts up and uses the SYSTEM tablespace for the automatic undo segments.

  4. The instance starts up and uses the first available undo tablespace for the automatic undo segments.
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

In Automatic Undo Management mode, if no UNDO_TABLESPACE parameter is specified, Oracle automatically selects the first available undo tablespace. The instance starts successfully and uses this available undo tablespace. It doesn't fail, and doesn't fall back to SYSTEM rollback segments or tablespace for undo data.

Multiple choice technology databases

When WORKAREA_SIZE_POLICY is set to AUTO, the work areas are sized to accomplish which two goals? (Choose two)

  1. To tune memory using the existing *_AREA_SIZE parameters.

  2. To allocate memory to work areas in order to optimize throughput only.

  3. To allocate memory to work areas in order to optimize response time only.

  4. To allocate memory to work areas in order to optimize both throughput and response time.

  5. To ensure that the overall size of the PGA will never exceed the value of PGA_AGGREGATE_TARGET.
Reveal answer Fill a bubble to check yourself
D,E Correct answer
Explanation

When WORKAREA_SIZE_POLICY is set to AUTO, Oracle automatically allocates memory to work areas to optimize both throughput and response time, while ensuring total PGA memory stays within the PGA_AGGREGATE_TARGET limit.

Multiple choice technology web technology

What is a DB config file?

  1. File used for database connectivity

  2. File used to define data format

  3. File used to hold lookup data

  4. File used to store Data Byte size
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

A DB config file in Ab Initio contains connection parameters like database type, hostname, port, username, and credentials required to establish database connectivity for components like Input Table and Output Table.

Multiple choice technology databases

Which one the following occurs when the extract phase of the ETL is going on

  1. Data is collected from multiple data sources

  2. Data is loaded into data warehouse

  3. Meta data is built

  4. None of the above
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

The E (Extract) phase of ETL is where data is collected from multiple source systems - databases, files, APIs, logs, etc. The T (Transform) phase cleans and converts this data. The L (Load) phase writes it to the data warehouse, so options B and C are incorrect for the extract phase.

Multiple choice technology databases

Which one of the query languages are specialized for Data mining models

  1. Structured Query Language

  2. XQuery

  3. Data Mining Extensions

  4. Multi dimensional Expressions
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Data Mining Extensions (DMX) is a query language specifically designed for creating and working with data mining models in Microsoft SQL Server Analysis Services. SQL is for general databases, XQuery queries XML, and MDAX (Multi-dimensional Expressions) is for OLAP cubes, not data mining.

Multiple choice technology databases

If you are using a validation which looks for similar matches in data when cleansing data. Which one the following types of validation works

  1. Balloon

  2. Fuzzy

  3. Strict

  4. Cloud
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Fuzzy validation is the correct technique for finding similar matches when cleansing data. Fuzzy matching allows for approximate string comparisons that can catch near-duplicates, typos, and variations that strict exact matching would miss. Balloon, Strict, and Cloud are not validation types used for similarity matching in data cleansing.

Multiple choice technology platforms and products

The Integration Server WmPublic package comes with many useful services. Some of the services in the pub.schema Folder can be used to:

  1. Validate objects and the pipeline

  2. Generate services that interact with external databases

  3. Perform string manipulation and substitution operations

  4. Convert DTD files to XSD schemas
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

The WmPublic package's pub.schema folder contains validation services for objects and pipeline data. These services validate document structures, field types, and ensure data integrity before processing. The other options describe different functionality (database interaction is in pub.sql, string manipulation in pub.string, DTD/XSD conversion in pub.xml).

Multiple choice technology testing

Following are properties of Data-Driven Framework. Select all which are true.

  1. A framework where test input and output values are read from data files.

  2. Test case is contained in the data file and not in the script.

  3. Kewords are most important aspect of this framework.

  4. Only test data is contained in the data files.
Reveal answer Fill a bubble to check yourself
A,D Correct answer
Explanation

Data-Driven Framework separates test data from test logic - input/output values come from data files (A), and only test data resides in those files (D). Test logic remains in scripts, making B false. Keywords are central to keyword-driven frameworks, not data-driven (C false).

Multiple choice technology testing

A framework where test case and test data is contained in the data file.

  1. A hybrid framework using Keyword and Data Driven framework.

  2. Data Driven Framework.

  3. Table-Driven Framework.

  4. None of the above.
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

A hybrid framework combining Keyword and Data Driven approaches allows test cases (keywords/steps) and test data to be stored together in external data files, separating test logic from the execution engine.

Multiple choice technology testing

According to Mercury, which framework they have modeled for automation in QTP. If you refer to Mercury guide.

  1. Keyword Driven

  2. Data Driven

  3. Record & Play

  4. All of the above.
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Mercury (HP) QTP was built on the fundamental Record & Playback capability. While Mercury later promoted Keyword Driven Framework as the best practice, the question asks what framework they 'modeled' - referring to the core automation approach built into the tool itself. The most basic framework type is Record & Play, which captures user interactions exactly as performed.

Multiple choice technology enterprise content management

CQL acts as an abstraction Layer, between the Physical and Logical Implementation of LLWCM DB

  1. None of the above

  2. False

  3. Partially True

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

CQL (likely Context Query Language or similar) serves as an abstraction layer between physical implementation (how data is stored) and logical implementation (how data is conceptually organized) in the LLWCM database. Abstraction layers hide complexity and provide a uniform interface, making this statement accurate.