Interview Questions

Q:

Difference between a query and a statement in SQL?

Answer

An SQL statement is a string of characters that conforms to the syntax and format specified in the international standard.


A query is a statement that returns a record-set.

Report Error

View answer Workspace Report Error Discuss

Subject: SQL

0 2500
Q:

My SQL statement SELECT AVG(SALARY) FROM EMP yields inaccurate results. Why?

Answer

Because SALARY is not declared to have NULLs and the employees for whom the salary is not known are also counted.


 

Report Error

View answer Workspace Report Error Discuss

0 2498
Q:

What are the benefits of data integration?

Answer

Following are the benefits of data integration:


- Makes reporting, monitoring, placing customer information across the enterprise flexible and convenient.


- Data usage is efficient.


- Cost Effective.


- Risk adjusted profitability management as it allows accurate data extraction.


- Allows timely and reliable reporting, as data quality is the prime technology for business challenges.

Report Error

View answer Workspace Report Error Discuss

0 2498
Q:

Define and explain COM?

Answer

COM is the component Object Model is a system whch creates application which are binary form that is language independent , object oriented ,modular and reusable .

Report Error

View answer Workspace Report Error Discuss

0 2497
Q:

Can you work in shifts?

Answer

Say “Yes” if you have made up your mind to work for a call center. Call centers would usually work 24 X 7 which needs some executives to be always present in the center. This means that you would need to work in shifts. 

Report Error

View answer Workspace Report Error Discuss

Subject: Call Center

1 2496
Q:

How do you handle errors in CICS programs?

Answer

Check EIBRESP after the call or use the HANDLE condition.


 

Report Error

View answer Workspace Report Error Discuss

0 2492
Q:

What is PHP?

Answer

PHP: Hypertext Preprocessor is open source server-side scripting language that is widely used for web development. PHP scripts are executed on the server. PHP allows writing dynamically generated web pages efficiently and quickly. The syntax is mostly borrowed from C, Java and perl. PHP is free to download and use.


 

Report Error

View answer Workspace Report Error Discuss

Subject: PHP

0 2491
Q:

What is mesh network?

Answer

A network in which there are multiple network links between computers to provide multiple paths for data to travel.

Report Error

View answer Workspace Report Error Discuss

Subject: Network Administration
Job Role: IT Trainer

0 2490