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

How long does it take to become anorexic?

Answer

Normally it takes about 22 days to become anorexic, but for some people it can be as little as 16 days or as many as 42 days.


Of course this depends a little bit on your starting weight/BMI and the health condition of the person.


 

Report Error

View answer Workspace Report Error Discuss

6 3838
Q:

Embedded SQL is which of the following?

A) The process of making an application capable of generating specific SQL code on the fly. B) Hard-coded SQL statements in a trigger.
C) Hard-coded SQL statements in a program language such as Java. D) Hard-coded SQL statements in a procedure.
 
Answer & Explanation Answer: C) Hard-coded SQL statements in a program language such as Java.

Explanation:
Report Error

View Answer Report Error Discuss

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

2 3833
Q:

A Credit may signify a

A) Increase in the liability account B) Decrease in an asset account
C) Increase in the capital stock account D) All of the above
 
Answer & Explanation Answer: D) All of the above

Explanation:

A credit may signify a decrease in an asset account or an increase in a liability or capital stock account. 

 

A debit may signify an increase in an asset account.

Report Error

View Answer Report Error Discuss

Filed Under: Accounts Payable
Exam Prep: AIEEE , Bank Exams , CAT
Job Role: Analyst , Bank Clerk , Bank PO

1 3832
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 3827
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 3826
Q:

Why do you want to be a lawyer?

Answer

“I have a general inclination to stand for the rights of humans. Maybe that is why they elected me as the college President of Students’ Union . I have studied Law for 4 years; I have matured a keen interest in Intellectual Property and would love to try the field in corporate law. I am additionally an articulate and assertive spokesperson. Having said that, I believe I have the keenness to practice law , skill set, and proper attitude and mold a career for myself.”

Report Error

View answer Workspace Report Error Discuss

Subject: Law

6 3825
Q:

What is ‘Bill Purchase’?

Answer

In ‘Bill Purchase’ the loan will be created for the full value of the draft and the interest will be recovered when the actual payment comes. For example, a ‘Sight draft’ is presented for which the loan is created for 100% of the draft value. The money is received after 7 days, and then the interest will be recovered for 7 days along with the principal amount.


 

Report Error

View answer Workspace Report Error Discuss

Subject: Bank Interview

0 3823