Computer Knowledge

Database and SQL

4,213 Questions

Master structured query language commands, database joins, table constraints, and alias generation. This section covers relational database management concepts and query outputs essential for technical aptitude. These technical questions feature prominently in banking IT officer exams and computer knowledge sections.

SQL queries and aliasesDatabase table constraintsDatabase joins and transformationsStored procedures and functions

Database and SQL Questions

Multiple choice technology databases

A trigger name in SQL 2005 cannot start with #.

  1. True

  2. False
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Trigger names cannot begin with # or ## because those prefixes designate temporary and global temporary objects respectively. Triggers are permanent schema objects that must follow regular identifier naming rules. The # prefix is reserved for temporary tables and temporary stored procedures that are automatically cleaned up when the session ends.

Multiple choice technology databases

Choose the correct option:

  1. A CTE is created using the WITH statement

  2. A CTE is created using the SELECT statement

  3. A CTE is created using the CREATE statement

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

A Common Table Expression (CTE) is defined using the WITH clause followed by the CTE name and its query. The WITH statement initiates a temporary named result set that can be referenced within a SELECT, INSERT, UPDATE, or DELETE statement. CTEs are not created with SELECT or CREATE keywords.

Multiple choice technology web technology

Which is used for Renames clause?

  1. 88

  2. 77

  3. 66

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

In COBOL, level number 66 is used for the RENAMES clause, which allows you to regroup existing data items under an alternative name for easier reference. Level 88 is for condition names, 77 is for independent data items, and 01 is for record-level descriptions. The RENAMES clause must immediately follow the last item it's renaming.

Multiple choice technology packaged enterprise solutions

Modifier list types in Oracle Pricing are

  1. Discount List Surcharge List Freight and Special Charges List

  2. Freight and Special Charges List

  3. Surcharge List

  4. Discount List
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

In Oracle Advanced Pricing, the standard modifier list types include Discount List, Surcharge List, and Freight and Special Charges List. Other choices only represent individual types, whereas the correct option lists these primary standard types together.

Multiple choice technology packaged enterprise solutions

The DQM features in the Customers Workbench lets you

  1. Perform advanced searches for parties and customer accounts with user–defined criteria in the Search Criteria window.

  2. Prevent duplicate entries by determining if the customer account that you are creating or updating is a potential duplicate of any existing account

  3. Both

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

DQM (Data Quality Management) in the Customers Workbench provides two key capabilities: (1) performing advanced searches with user-defined criteria through the Search Criteria window, and (2) preventing duplicate customer accounts by identifying potential duplicates during creation or update. Both functions are core DQM features.

Multiple choice technology packaged enterprise solutions

This functionality is for numbering orders

  1. Document Sequence

  2. Transaction Types

  3. Processing Constraints

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

Document Sequence in Oracle is the feature that automatically generates unique sequential numbers for orders and other transactions. Transaction Types define category classifications, while Processing Constraints control business rules.

Multiple choice technology packaged enterprise solutions

Explain the field 'Respond to sales order changes' in Oracle WIP parameters = Never

  1. The corresponding work order will not be placed on hold if you de-link the configured item from the sales order, or if the sales order is placed on hold.

  2. The work order will be placed on hold if you de-link the configured item from the sales order, or if the sales order is placed on hold.

  3. The work order will be placed on hold if it is the only work order reserved to that sales order. If there are more than one work orders for the sales order, this will not happen. If you cancel sales order lines with ATO items, this parameter, is ignored b

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

Setting the 'Respond to sales order changes' parameter to 'Never' ensures that changes to a sales order (like placing it on hold or de-linking) will not automatically place the corresponding WIP work order on hold.

Multiple choice technology packaged enterprise solutions

Each record in (row) in relational database corresponds to one of the following in Process Commander. In other words, one row in table is created whenever following of process commander is created.

  1. Flow for a class

  2. Model for a class

  3. Activity for a class

  4. Flow action for a class

  5. Instance of any class
Reveal answer Fill a bubble to check yourself
E Correct answer
Explanation

Pega maps concrete classes to relational database tables. When a class instance is saved, a corresponding row is created in the associated table. Rules like flows, models, activities, and flow actions are definitions rather than the general runtime instances that map to rows, making 'Instance of any class' correct.

Multiple choice technology packaged enterprise solutions

Which of the following options in the Change Tracking field enable backward chaining? (Select all that apply)

  1. When used if no value present

  2. When used if property is missing

  3. Whenever used

  4. Whenever inputs change
Reveal answer Fill a bubble to check yourself
A,B,C Correct answer
Explanation

The options "Whenever used", "When used if no value present", and "When used if property is missing" all represent backward chaining strategies where calculation is triggered by property retrieval. Conversely, "Whenever inputs change" is a forward chaining strategy where calculations are pushed automatically as soon as source values update.

Multiple choice technology packaged enterprise solutions

Which of the following rules cannot be called by an expression in a manner in which property changes are tracked?

  1. Decision Trees

  2. Decision Tables

  3. Map

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

Activities cannot be called by expressions in a way that tracks property changes. While decision trees, decision tables, and map values can be executed within declare expressions to support automatic change tracking, activities are procedural and do not support Pega's automatic declarative dependency tracking.

Multiple choice technology

What is the use of Modify stage?

  1. Null_Handling

  2. Datatype conversion

  3. move or keep column

  4. None of the Above

  5. All the Above
Reveal answer Fill a bubble to check yourself
E Correct answer
Explanation

The Modify stage in DataStage performs multiple data manipulation functions: null handling (managing null values), datatype conversion (changing data types), and column management (moving, renaming, or dropping columns). These are all core capabilities of this stage.

Multiple choice technology

What are the operations performed in modify stage?

  1. Null handling

  2. Type conversion

  3. Dropping a particular column

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

The Modify stage in DataStage can perform multiple data modification operations: null handling (setting null values), type conversions (changing data types), and dropping columns (removing unwanted columns). Since all these operations are supported by the Modify stage, "All the above" is the correct answer.