Interview Questions

Q:

How to check that the file object is pointing a file on HD?

Answer

boolean isFile();

Report Error

View answer Workspace Report Error Discuss

Subject: Java

0 2224
Q:

What is the use of super call?

Answer

By using super call we can call super class constructors  from sub class constructors and we can initialize super class private data.

Report Error

View answer Workspace Report Error Discuss

Subject: Java

0 2224
Q:

Define stored procedure. What are its advantages and disadvantages?

Answer

A stored procedure is a segment of declarative SQL statements stored inside the database catalog. A stored procedure can be invoked by triggers, other stored procedures or applications such as Java, C#, PHP, etc.


Advantages 



- Typically stored procedures help increase the performance of the applications. Once created, stored procedures are compiled and stored in the database. However MySQL implements the stored procedures slightly different. MySQL stored procedures are compiled on demand. After compiling a stored procedure, MySQL puts it to a cache. And MySQL maintains its own stored procedure cache for every single connection. If an application uses a stored procedure multiple times in a single connection, the compiled version is used, otherwise the stored procedure works like a query.


- Stored procedures helps reduce the traffic between application and database server because instead of sending multiple lengthy SQL statements, the application has to send only name and parameters of the stored procedure.


- Stored procedures are reusable and transparent to any applications. Stored procedures expose the database interface to all applications so that developers don’t have to develop functions that are already supported in stored procedures.


- Stored procedures are secure. Database administrator can grant appropriate permissions to applications that access stored procedures in the database without giving any permission on the underlying database tables.


Disadvantages


- If you use a lot of stored procedures, the memory usage of every connection that is using those stored procedures will increase substantially. In addition, if you overuse a large number of logical operations inside store procedures, the CPU usage will also increase because database server is not well-designed for logical operations.


- A constructs of stored procedures make it more difficult to develop stored procedures that have complicated business logic.


- It is difficult to debug stored procedures. Only few database management systems allow you to debug stored procedures. Unfortunately, MySQL does not provide facilities for debugging stored procedures.


-It is not easy to develop and maintain stored procedures. Developing and maintaining stored procedures are often required specialized skill set that not all application developers possess. This may lead to problems in both application development and maintenance phases.

Report Error

View answer Workspace Report Error Discuss

0 2223
Q:

The balance of an account is determined by

A) Sum of credits and debits B) Difference of credits and debits
C) Product of credits and debits D) None of the above
 
Answer & Explanation Answer: B) Difference of credits and debits

Explanation:

The balance of an account is determined by the difference of credits amount and debits amount in the sheet.

Report Error

View Answer Report Error Discuss

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

0 2222
Q:

What is ADB in Android ?

Answer

Adb is short for Android Debug Bridge. It allows developers the power to execute remote shell commands. Its basic function is to allow and control communication towards and from the emulator port.

Report Error

View answer Workspace Report Error Discuss

3 2222
Q:

How to insert Javascript in HTML?

Answer

We can insert JavaScript in HTML using <Script tag>. JavaScript can be enclosed in <script type = text/javascript> and ending with </script>.


Example: 


<html> 


  <body> 


        <script type="text/javascript"> 


               ...JavaScript….


         </script> 


   </body> 


</html>

Report Error

View answer Workspace Report Error Discuss

Subject: Web Technology

0 2222
Q:

What is Payroll Journal?

Answer

A payroll journal is like a payroll register. It has salary, bonuses, commission in other words earnings, any deductions such as 401k, fsa etc, state and income taxes etc.
It shows the gross salary less any deductions "Net pay" for the period.

Report Error

View answer Workspace Report Error Discuss

0 2222
Q:

Cheque deposited but not cleared means

Answer

A Bank Reconciliation Statement is a statement prepared periodically by a customer to explain the divergence (difference) between the bank balance as per cash book and the bank balance as per Pass Book. It clearly shows the two differing balances and the outstanding items which causes the balances to disagree.


The objective of preparing such a statement is to know the causes of differences between the two balances and pass necessary correcting or adjusting entries in the books of the firm. But it is to be noted that some differences are automatically adjusted. For example - A cheque that has been sent for collection, but not yet collected, causes a difference between the balance as shown by the pass book and the balance as shown by the cash book, but no adjusting entry is required in the cash book for such a difference because, the bank will credit the firm’s account as soon as the cheque is collected.

Report Error

View answer Workspace Report Error Discuss

Subject: Finance Exam Prep: AIEEE , Bank Exams , CAT
Job Role: Analyst , Bank Clerk , Bank PO

0 2218