Interview Questions

Q:

What is JDBC ?

Answer

JDBC technology is an API (included in both J2SE and J2EE releases) that provides cross-DBMS connectivity to a wide range of SQL databases and access to other tabular data sources, such as spreadsheets or flat files. With a JDBC technology-enabled driver, you can connect all corporate data even in a heterogeneous environment.

Report Error

View answer Workspace Report Error Discuss

Subject: Java

0 1982
Q:

What report are provided to accounting dept. from payroll every month? What reports are generate at end month, qtr & year end in payroll dept?

Answer

For making accounting entries the accounting dept will need the total transactions of the particular payroll run grouped into various expenditure/liability/Income items like salary,loans,ees pension,ers pension,tax, PF/NI etc. This information should be employee wise & relevant cost center of the employee(in a large organisation).

Mostly payroll will have expenses/liabilities only. Few payrolls might have Income also.

To be specific to the reports bit of your question following reports are produced

1) Net pay reconciliations report
2) Deductions report comprising all voluntary and non voluntary deductions
3) Payments report
4) Costing report
5) Exceptions report
6) High pay salary report
7) No pay salary report

Report Error

View answer Workspace Report Error Discuss

0 1980
Q:

A database is used to

A) store data B) modify data
C) extract data D) All of the above
 
Answer & Explanation Answer: D) All of the above

Explanation:

A database is used to store, modify, extract and to search for the data within it.

Report Error

View Answer Report Error Discuss

2 1979
Q:

How to Estimate Testing effort ?

Answer

Time Estimation method for Testing Process:


 


Step 1 : count number of use cases (NUC) of system 


Step 2 : Set Avg. Time Test Cases(ATTC) as per test plan 


Step 3 : Estimate total number of test cases (NTC) 


Total number of test cases = Number of Use Cases X Avg. Test Cases per a use case 


Step 4 : Set Avg. Execution Time (AET) per a test case 


Step 5 : Calculate Total Execution Time (TET) 


TET = Total number of test cases * AET 


Step 6 : Calculate Test Case Creation Time (TCCT)


usually we will take 1.5 times of TET as TCCT


TCCT = 1.5 * TET


Step 7 : Time for Re-Test Case Execution (RTCE) this is for retesting


usually we take 0.5 times of TET


RTCE = 0.5 * TET


Step 8 : Set Report generation Time (RGT


usually we take 0.2 times of TET


RGT = 0.2 * TET


Step 9 : Set Test Environment Setup Time (TEST)


it also depends on test plan


Step 10 : Total Estimation time = TET + TCCT+ RTCE + RGT + TEST + some buffer.


 

Report Error

View answer Workspace Report Error Discuss

Subject: QA Testing

0 1978
Q:

Explain how to create users through SQL PLUS.

Answer

We need to first login to the data base as: SQLPLUS followed by user_name/password. Then we need to execute the following query:


CREATE USER user_name IDENTIFIED BY abcd; in this query a user_name suggest the user that is created which has a password abcd which is required for login in database.

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle

0 1975
Q:

How to call argument constructor?

Answer

new ClassName( arg1, arg2, .... argN);


Ex:


Class sample {


   Sample(int a) {


   System.out.println("arg con a =" +a);


   }


}


class Demo {


    Public static void main( String[] args) {


     Sample s1= new Sample(23);


     Sample s2= new Sample(45);


    }


}

Report Error

View answer Workspace Report Error Discuss

Subject: Java

0 1974
Q:

What is recovery/error testing?

Answer

Recovery/error testing is testing how well a system recovers from crashes, hardware failures, or other catastrophic problems.

Report Error

View answer Workspace Report Error Discuss

Subject: QA Testing

0 1973
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 1972