Interview Questions

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

They should be initialized during the time of declaration itself otherwise it is a compilation eror

This depends on the user's browser and OS.
In the case of Netscape with Windows OS,all the cookies are stored in a single file called

cookies.txt
c:\Program Files\Netscape\Users\username\cookies.txt
In the case of IE,each cookie is stored in a separate file namely username@website.txt.
c:\Windows\Cookies\username@Website.txt

When there are no more users of the application Application_End event occurs

HR-Human Resources:

To be a good HR person we need to have excellent  communication skills,interpersonal skills, good friendly attitude, talkative, decision-making skills etc.

An HR is the backbone of a  company. Right from recruiting the suitable person to training and then efficiency appraisal and then compensation and then exit interview...everything every step involves an HR.

So, if you wish to be a soul of the company not just a part of it, you should be an HR.

We can use the preg_match() function with “/.*@(.*)$/” as the regular expression pattern.
For example:
preg_match("/.*@(.*)$/","https://info@abc.com",$data);
echo $data[1];
?>

Key Fields - (PROCOPT=K)

- Used to sequence the database and can't be changed

- It is the field within a segment, used to identify the occurrence of the segment

- Used to maintain the IMS segments in ascending sequence.

Search Fields - (PROCOPT=G)

- Used to search for a segment, without the segment being sequenced on that field

- A segment need not have a key or search field.

Both types of fields can be used to search the database.

Datastage has two components

-Client Components – Designer, Director, Manager and Administrator

-Server Components – Server, Repository and Plug-ins.