Interview Questions

Q:

In terms of DB2 indexing, what is the root page?

Answer

The simplest DB2 index is the B-tree and the B-tree's top page is called the root page. The root page entries represent the upper range limits of the index and are referenced first in a search. 


 

Report Error

View answer Workspace Report Error Discuss

0 2477
Q:

What is an Index? Explain how to create an Index.

Answer

An index is a object which is used to improve performance during retrieval of records.


CREATE [UNIQUE] INDEX index_name 


ON employee[emp_id, emp_name,dept_id]


[COMPUTE STATISTICS]


The UNIQUE keyword is used when combined values of the index should be unique.


The COMPUTE STATISTICS during the creation of index optimizes the plan of execution of the SQL statement and improves performance.

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle

0 2475
Q:

What are the three levels of definition for the VSAM DEFINE?

Answer

They are DEFINE CLUSTER, DATA and INDEX.

Report Error

View answer Workspace Report Error Discuss

0 2473
Q:

Explain the validation controls. How many validation controls in ASP.NET 4.0?

Answer

Validation controls are responsible to validate the data of an input control. Whenever you provide any input to an application, it performs the validation and displays an error message to user, in case the validation fails.

ASP.NET 4.0 contains the following six types of validation controls:

   => CompareValidator - Performs a comparison between the values contained in two controls.
   => CustomValidator - Writes your own method to perform extra validation.
   => RangeValidator- Checks value according to the range of value.
   => RegularExpressionValidator - Ensures that input is according to the specified pattern or not.
   =>  RequiredFieldValidator - Checks either a control is empty or not.
   => ValidationSummary - Displays a summary of all validation error in a central location.

Report Error

View answer Workspace Report Error Discuss

Subject: .NET

0 2473
Q:

What is correlated query? Explain its uses.

Answer

In a correlated query, the outer query is related to the inner query. This means one or more columns in the outer query are referenced. It’s used when the outer queries value is being used by inner query. For example, we need to find which employee had more perks in the current month than they did in the previous month. The correlated subquery is executed for each row of perks information in the parent query to first determine what the perks were for each employee in the previous month. This data, in turn, is compared to perks for each employee in the current month, and only those employees whose perks in the current month were greater that their previous month's perks are returned.

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle

0 2472
Q:

What is the return type of the main() method?

Answer Main() method doesn't return anything hence declared void.
Report Error

View answer Workspace Report Error Discuss

Subject: Java

0 2472
Q:

OMO refers to

Answer

Open Market Operations (OMO) refer to the buying and selling of government securities in the open market in order to expand or contract the amount of money in the banking system.

Report Error

View answer Workspace Report Error Discuss

Subject: Bank Interview Exam Prep: AIEEE , Bank Exams , CAT
Job Role: Analyst , Bank Clerk , Bank PO

0 2471
Q:

RBI issued currency notes under which system

A) Maximum Fiduciary System B) Proportional Reserve System
C) Fixed Fiduciary System D) Fixed Minimum Reserve System
 
Answer & Explanation Answer: D) Fixed Minimum Reserve System

Explanation:

RBI issued currency notes under Fixed Minimum Reserve System.

Report Error

View Answer Report Error Discuss

Filed Under: Finance
Exam Prep: AIEEE , Bank Exams , CAT
Job Role: Analyst , Bank Clerk , Bank PO

2 2469