Computer Knowledge

Database and SQL

3,929 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 web technology

Use Edit Input rules (Rule-Edit-Input) to

  1. convert input data to a standard format

  2. test prperty values

  3. perform a database INSERT

  4. define and enforce comparison relationships among property values
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Edit Input rules (Rule-Edit-Input) are used to convert input data into a standard format. They normalize user input before processing. They are not used for testing property values, database operations, or enforcing comparison relationships.

Multiple choice technology web technology

Trigger rule is performed when

  1. Database Save

  2. Database Update

  3. Database Deletion

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

Trigger rules in Pega are declarative rules that automatically execute processing when specific database operations occur. They can be configured to run on save (create), update, or delete operations, making 'All of the above' the correct answer.

Multiple choice technology web technology

For short medium lists which change often following should be specified in TableEdit tab of Property

  1. Local List

  2. Field Value

  3. Remote List

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

For short to medium-sized lists that change frequently, the TableEdit tab should specify 'Field Value' as the source. Field Values allow easy addition, modification, and removal of list entries without code changes. Option A (Local List) is for hardcoded lists, option C (Remote List) is for external data sources, and option D (Prompt List) is for dynamic prompts. Field Value (B) is the best choice for frequently changing short/medium lists.

Multiple choice technology web technology

Trigger rule is performed when

  1. Database Save

  2. Database Update

  3. Database Deletion

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

A Rule-Declare-Trigger is executed automatically by the Pega engine when an instance of a specified class is saved (inserted/updated) or deleted in the database, making all of the database events trigger sources.

Multiple choice technology web technology

These are the Classes mapping to respective tables Class Table Work-Object PC_Work Work- PC_Work Policy-Admin-Work PC_PolAdmin If a new class created under “Policy-Admin-Work” class group which table it will be saved.

  1. a. PC_Work

  2. b. PC_Other

  3. c. PC_PolAdmin

  4. d. Base Table
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Classes inherit table mapping from their parent class. Policy-Admin-Work maps to PC_PolAdmin table, so any class created under it (like Policy-Admin-Work-MyClass) will also map to PC_PolAdmin.

Multiple choice technology web technology

Which declarative rule is used to run an activity when the value of a specified property changes ?

  1. Declare Expressions

  2. Declare Constraint

  3. Declare Trigger

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

Declare OnChange is specifically designed to execute activities when a property value changes. Declare Expressions (A) compute derived property values. Declare Constraint (B) validates property relationships. Declare Trigger (C) doesn't exist as a standard Pega declarative rule type.

Multiple choice technology web technology

Where do u have the group by option

  1. List View

  2. Summary View

  3. Both a and b

  4. none of the above
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Summary View in PRPC provides the group by functionality for aggregating and organizing data. List View displays individual records without grouping capabilities. The group by option is specifically available when you switch to Summary View to create aggregated reports.

Multiple choice technology databases

Which two statements about views are true? (Choose two.)

  1. A view can be created as read only.

  2. A view can be created as a join on two or more tables. AND Insert and delete operations cannot be performed on views using functions

  3. A view cannot have an ORDER BY clause in the SELECT statement.

  4. A view cannot be created with a GROUP BY clause in the SELECT statement.
Reveal answer Fill a bubble to check yourself
A,B,C,D Correct answer
Multiple choice technology databases

In which case would you use a FULL OUTER JOIN?

  1. Both tables have NULL values.

  2. You want all unmatched data from one table.

  3. You want all matched data from both tables.

  4. You want all unmatched data from both tables.

  5. One of the tables has more data than the other.
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

FULL OUTER JOIN returns ALL matched AND unmatched data from BOTH tables. It combines the results of both LEFT OUTER JOIN and RIGHT OUTER JOIN. Option D is correct - it returns all unmatched data from both tables (along with matched data).

Multiple choice technology databases

Which data dictionary table should you query to view the object privileges granted to the user on specific columns?

  1. USER_TAB_PRIVS_MADE

  2. USER_TAB_PRIVS_RECD

  3. USER_COL_PRIVS_MADE

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

USER_COL_PRIVS_RECD shows column-level object privileges that the current user has RECEIVED. The other options show different privilege views: USER_TAB_PRIVS_MADE (table privileges granted to others), USER_TAB_PRIVS_RECD (table privileges received), USER_COL_PRIVS_MADE (column privileges granted to others).