Interview Questions

Q:

State one similarity and difference between WHERE Clause and HAVING Clause?

Answer

Similarity: Both WHERE and HAVING Clause filters out records based on one or more conditions.


Difference: WHERE Clause can only be applied to a static non-aggregated column whereas HAVING is needed for aggregated columns.

Report Error

View answer Workspace Report Error Discuss

Subject: SQL

1 3869
Q:

What is ‘Amortization’?

Answer

The repayment of the loan by instalment to cover principal amount with interest is known as ‘Amortization’.


 

Report Error

View answer Workspace Report Error Discuss

Subject: Bank Interview

0 3866
Q:

What is a DB2 bind?

Answer

A DB2 bind is a process that builds an access path to DB2 tables. 

Report Error

View answer Workspace Report Error Discuss

0 3864
Q:

What is a Wrapper class?

Answer

Wrapper classes wrap primitive values in a class and offers utility to access them through objects. Some of the primitive wrapper data types are:


Byte, short, int, long, float, double, char, Boolean.


Example: 


Create a class name VectorAdd to populate it with integer values using the add(int, object) method.


public class VectorAdd


{


       public static void main(String argv[])


       {


             Vector v = new Vector();


             v.add(0,new Integer(10));


             v.add(1,new Integer(20));


             v.add(2,new Integer(30));


             for(int i=0; i < v.size();i ++)


             {


                  Integer iw =(Integer) v.get(i);


                  System.out.println(iw);


             }


       }


}

Report Error

View answer Workspace Report Error Discuss

Subject: C++

0 3848
Q:

What were your starting and final levels of compensation?

Answer

Interviewers expect a candidate for employment to be able to provide the details of their compensation history. Be prepared to tell the interviewer how much you earned at each of your prior positions.


Make sure that what you tell the interviewer matches what you listed on your job application. Refresh your memory prior to the interview by reviewing your salary history, so, you can speak in detail and accurately. Don't exaggerate or inflate your earnings. Many employers will check references and confirm your salary history prior to making a job offer. A discrepancy between what you reported and what the employer says could knock you out of contention for the job.

Report Error

View answer Workspace Report Error Discuss

Subject: Work History

15 3839
Q:

Which of the following is a function of inventory?

A) to take advantage of quantity discounts B) to decouple various parts of the production process
C) to provide a selection of goods for anticipated customer demand and to separate the firm from fluctuations in that demand D) All the above
 
Answer & Explanation Answer: D) All the above

Explanation:

All the above given statements are functions of Inventory.

 

Inventory or stock is the goods and materials that a business holds for the ultimate goal of resale. Inventory management is a discipline primarily about specifying the shape and placement of stocked goods.


The primary function of inventory is to use marketing and production to increase profitability, to get the maximum amount for the business' investment. There are other functions of inventory, such as balancing supply and demand, improving efficiency, establishing a safety stock and geographical specialization.

Report Error

View Answer Report Error Discuss

Filed Under: Business Intelligence
Exam Prep: AIEEE , Bank Exams , CAT
Job Role: Analyst , Bank Clerk , Bank PO

0 3838
Q:

Why static methods cannot access non static variables or methods?

Answer

A static method cannot access non static variables or methods because static methods doesnt need the object to be accessed. So if a static method has non static variables or non static methods which has instantiated variables they will no be intialized since the object is not created and this could result in an error.

Report Error

View answer Workspace Report Error Discuss

Subject: Java

9 3834
Q:

What are three ways to reduce page load time?

Answer

There are many answers here: Reduce image sizes, remove unnecessary widgets, HTTP compression, put CSS at the top and script references at the bottom or in external files, reduce lookups, minimize redirects, caching, etc.

Report Error

View answer Workspace Report Error Discuss

4 3834