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:

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 3831
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 3829
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:

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 3826
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
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 3810
Q:

What is a stub network?

A) A network with only one entry and no exit point. B) A network that has only one entry and exit point.
C) A network with more than one exit point. D) A network with more than one exit and entry point.
 
Answer & Explanation Answer: B) A network that has only one entry and exit point.

Explanation:

A stub network has only one default path to non-local hosts and no outside network knowledge. Non-local stub network traffic uses a single logical path when traveling in and out of the network.

 

Stub networks are essentially local area networks (LAN) that either do not connect to the outside and relay data packets internally or are dead-end LANs that know of only one network exit. Stub networks may have multiple connections but use one path to single points of destination.

 

Hence, a stub network is a network that has only one entry and exit point.

Report Error

View Answer Report Error Discuss

3 3803