Interview Questions

Q:

How do you handle error condition while writing stored procedure or accessing stored procedure from java ?

Answer

Stored procedure should return error code if some operation fails but if stored procedure itself fail than catching SQLException is only choice.

Report Error

View answer Workspace Report Error Discuss

Subject: Java

1 4524
Q:

How is 3G different from 2G?

Answer

- Packet data speed is higher in 3G, and it is up to 384 KBPS
- Voice and sms speed is also 384 KBPS in 3G
- 2G utilizes different switching techniques for voice and data, where as  3G uses single switching, irrespective of data
- 3G has at least 2MB of data link of a mobile, where in 2G the data rate is in KBPS
- 3G has WiMAX facility for faster VOIP and internet
- 2G uses GSM TDMA technology with narrowband 200Khz.
- 3G uses CDMA technology with broadband 5Mhz, with same frequency carrier and time.

Report Error

View answer Workspace Report Error Discuss

3 4511
Q:

What do you mean by friend function in C++ ?

Answer

Friends can be either functions or other classes. The class grants friends unlimited access privileges.

* The declaration of the function should be preceded by the keyword 'friend'.
* The function definition will not use the keyword or the scope operator '::'.


Thus, a friend function is an ordinary function or a member of another class.

Report Error

View answer Workspace Report Error Discuss

15 4506
Q:

How to convert JSON Text to a JavaScript Object ?

Answer

One of the most common use of JSON is to fetch JSON data from a web server (as a file or as an HttpRequest), convert the JSON data to a JavaScript object, and then it uses the data in a web page.


The eval() function can compile and execute any JavaScript. This represents a potential security problem.


It is safer to use a JSON parser to convert a JSON text to a JavaScript object. A JSON parser will recognize only JSON text and will not compile scripts.

Report Error

View answer Workspace Report Error Discuss

2 4503
Q:

Explain Row level and statement level trigger.

Answer

Row Level Trigger :
Row Level Trigger is fired each time row is affected by Insert, Update or Delete command. If statement doesn’t affect any row, no trigger action happens.

Statement Level Trigger :
This kind of trigger fires when a SQL statement affects the rows of the table. The trigger activates and performs its activity irrespective of number of rows affected due to SQL statement.

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle

0 4492
Q:

What is C-Sharp (C#) and its advantages ?

Answer

C# is a type-safe, managed and object oriented language, which is compiled by .Net framework for generating intermediate language (IL).


Below are some of the features supported in C# -
* Constructors and Destructors
* Properties
* Passing Parameters
* Arrays
* Main
* XML Documentation and
* Indexers


Below are the advantages of C# -


* Easy to learn
* Object oriented
* Component oriented
* Part of .NET framework

Report Error

View answer Workspace Report Error Discuss

Subject: .NET
Job Role: IT Trainer , Analyst

1 4490
Q:

What is a VSAM slot?

Answer

A relative record dataset (RRDS) consists of a specified number of areas called slots. Each slot is identified by a relative record number (RRN) which indicates its relative position in the file.

Report Error

View answer Workspace Report Error Discuss

0 4486
Q:

What is RAROC?

Answer

RAROC is a risk-adjusted framework for profitability measurement and profitability management. It is a tool for measuring risk-adjusted financial performance. And it provides a uniform view of profitability across businesses (Strategic Business Units / divisions). RAROC and related concepts such as RORAC and RARORAC are mainly used within (business lines of) banks and insurance companies. RAROC is defined as the ratio of risk-adjusted return to economic capital.

Report Error

View answer Workspace Report Error Discuss

Subject: Finance

0 4481