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 2493
Q:

What are pass by reference and pass by value ?

Answer

When an object is passed by value, this means that a copy of the object is passed. Thus, even if changes are made to that object, it doesn’t affect the original value. 


When an object is passed by reference, this means that the actual object is not passed, rather a reference of the object is passed. Thus, any changes made by the external method, are also reflected in all places.

Report Error

View answer Workspace Report Error Discuss

Subject: Java

0 2491
Q:

By monitoring ad campaign performance, an advertiser may obtain the information needed to

A) determine if campaigns are meeting overall marketing and conversion goals B) create additional AdWords accounts for low-performing keywords
C) compare campaign performance to that of individual competitors D) create duplicate ad groups with identical keywords and different ad variations
 
Answer & Explanation Answer: A) determine if campaigns are meeting overall marketing and conversion goals

Explanation:

By monitoring ad campaign performance an advertiser may obtain the information needed to determine if campaigns are meeting overall marketing and conversion goals compare campaign performance to that of other advertisers create separate adwords accounts for low-performing keywords create duplicate ad groups with identical keywords and different ad variations.

Report Error

View Answer Report Error Discuss

Filed Under: Advertising and Media

4 2490
Q:

How to set cookies in PHP?

Answer

The function setcookie() is used to define a cookie that is to be sent along with HTTP headers. The cookie must be sent prior to any output from the script as is the protocol restriction. After setting the cookies, they can be used when the next page is loaded by using $_COOKIE or $HTTP_COOKIE_VARS arrays.

Report Error

View answer Workspace Report Error Discuss

Subject: PHP

0 2490
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 2489
Q:

What is Wi-Fi technology and over which frequency band it operates?

Answer

Wi-Fi technology is a technology used for transmitting a signal using the 802.11 specifications works a lot like it does with a basic Ethernet hub: They’re both two-way forms of communication, and they both use the same frequency to both transmit and receive, often referred to a half-duplex. WLANs used radio frequencies (RFs) that are radiated into the air from an antenna that creates radio waves. These waves can be absorbed, refracted, or reflected by walls, water, and metal surfaces, resulting in low signal strength. So because of this vulnerability to surrounding environmental factors, it’s pretty apparent that wire-less will never offer us the same robustness as a wired network can, but that still doesn’t mean we’re not going to use or run the wireless or Wi-Fi.

Report Error

View answer Workspace Report Error Discuss

0 2486
Q:

Data structure suitable for an application discussed in?

A) procedural design B) architectural design
C) data design D) interface design
 
Answer & Explanation Answer: C) data design

Explanation:
Report Error

View Answer Report Error Discuss

1 2485
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 2485