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 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 mainframe

The Guardian error number "ERROR 12" represents

  1. Invalid File

  2. File is full; cannot write

  3. File is in Use

  4. Cannot find the file
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Guardian error 12 represents 'File is in Use' - meaning the requested file is locked by another process. This is a file access conflict error, not a file-not-found or file-full error. The file exists but cannot be accessed due to an existing lock.

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.

Multiple choice technology

Which of the following stage(s) support "Reference link with multi row result set" ? I. ODBC Stage II. UniVerse Stage III. OraBulk Stage IV. DB2 stage

  1. I & II Only

  2. I & IV Only

  3. III Only

  4. II & IV Only
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

The claimed answer indicates that ODBC Stage (I) and UniVerse Stage (II) support reference links with multi-row result sets, while OraBulk Stage (III) and DB2 stage (IV) do not support this feature. Reference links allow lookup operations that can return multiple rows for matching keys.

Multiple choice technology

Which three are keyless pertitioning method?

  1. Entire

  2. Modulus

  3. Round Robin

  4. Random

  5. Hash
Reveal answer Fill a bubble to check yourself
A,C,D Correct answer
Explanation

Entire, Round Robin, and Random partitioning methods are keyless - they distribute data without using a key field. Hash and Modulus require key values to determine partition assignment.

Multiple choice technology programming languages

Which of the following statements are true about WS-Addressing correlation id?

  1. The correlation ID enables Oracle BPEL Server to correlate the response with the appropriate requesting instance

  2. The correlation ID carries transaction information between BPEL processes

  3. The developer needs to set the value of the correlation ID while coding the BPEL process

  4. The correlation ID is automatically set by the BPEL engine at run-time
Reveal answer Fill a bubble to check yourself
A,D Correct answer
Explanation

The correlation ID in WS-Addressing enables proper message routing between request and response. It is automatically generated by the BPEL engine at runtime - developers do not set it manually. It carries routing information, not transaction data.