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

There are 5 fixed values to be prompted for a field in user interface. What is to be selected in Table edit tab of the property?

  1. a. Local List

  2. b. RemoteList

  3. c. FieldValue

  4. d. ClassKey
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

For a small, fixed set of 5 values, Local List is the correct choice in the Table Edit tab. Remote List is for external data sources, FieldValue is for dynamic lists stored in database, and ClassKey is for keyed access.

Multiple choice technology web technology

How to refer the decision table? Decision table can be referred from three other rules

  1. a. From decision shape of flow rule

  2. b. In an activity you can evaluate the decision table using Property-Map-DecisionTable. By doing so, we can set a property value with the return value of the decision table

  3. c. Decision table can be referred from R-D-E

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

Decision tables in Pega can be referenced three ways: from decision shapes in flows, using Property-Map-DecisionTable method in activities, and through Rule-Declare-Expression. Option D correctly lists all three methods. Each approach serves different use cases in Pega applications.

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).

Multiple choice technology databases

Merge Syntax

  1. A. MERGE INTO <<target_table_name>> USING <<source_table_name>> WHEN MATCHED THEN UPDATE ------ WHEN NOT MATCHED THEN INSERT -------

  2. B. MERGE <<target_table_name>> USING <<source_table_name>> WHEN MATCHED THEN UPDATE ------ WHEN NOT MATCHED THEN INSERT -------

  3. C. MERGE INTO <<target_table_name>> USING <<source_table_name>> WHEN EXISTS THEN UPDATE ------

  4. D. MERGE INTO <<target_table_name>> USING <<source_table_name>> WHEN NOT MATCHED THEN INSERT ------

  5. Both A and D
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

MERGE syntax requires INTO keyword before the target table, followed by USING and the source table. Option A shows the correct syntax: MERGE INTO target USING source WHEN MATCHED THEN UPDATE WHEN NOT MATCHED THEN INSERT. Option B is missing INTO, C uses wrong clause (EXISTS), D only has INSERT, and E is incorrect.