Interview Questions

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 2505
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 2504
Q:

What do you think about the challenges faced by a Business Analyst ?

Answer

Change management is the biggest challenge in each and every industry. After requirements stage when development is started client will come-up with some new changes or enhancements. 


Cross departmental or cross team management – like conflict management between teams. Also individuals. This requires soft skills and smartness. 


Communication problems – In real time this can happen. You might be good in speaking and understanding the English language. BUT sometimes it happens like Different people across the globe speak different style of English. In USA itself Mexico people speak English differently. Romans speak different English. So at initial level to understand the accent can be a challenge but after some time you will become perfect. 

Report Error

View answer Workspace Report Error Discuss

0 2503
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 2503
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 2502
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 2501
Q:

When someone clicks your ad, the actual amount you’re charged will be

A) The minimum needed to hold your ad position, under the maximum cost-per-click limit B) The minimum needed to hold your ad position or 50% of your maximum cost-per-click bid, whichever is greater
C) The minimum needed to hold your ad position but never more than 120% of your maximum cost-per-click bid, whichever is greater D) The minimum needed to hold your ad position but never less than 50% of your maximum cost-per-click bid, whichever is greater
 
Answer & Explanation Answer: A) The minimum needed to hold your ad position, under the maximum cost-per-click limit

Explanation:

When_someone_clicks_your_ad,_the_actual_amount_you’re_charged_will_be1551856891.png image

When someone clicks your ad, the actual amount you’re charged will be " The minimum needed to hold your ad position, under the maximum cost-per-click limit ".

Report Error

View Answer Report Error Discuss

4 2500
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 2497