Krishna Logo
krishnatraining.com starting new branches in ellicottcity, germantown
Divied
Ria / Kumar @ 1-(877) 864-8462

 

Loading
Latest News
Home Navigation Divied
INTERVIEW Navigation Divied DATABASE INTERVIEW QUESTIONS
Showing 1 - 10 of 157 Previous | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | Next
DATABASE INTERVIEW QUESTIONS
1How U Do The Back End Testing In QTP?

Ans: First of all we have to know what back end is testing. Back end testing is nothing but checking the correctness of the Database.
With QTP we can write a script which going to connect the
Backend I mean a database of our inquiry then we can set it on the Datatable where we can compare the backend data with
The real one and determine If there is any inconsistency and so on so forth.


2How To Do Testing For Performance Related Issues?

Ans: Testing can be done whether indexes have been created on particular table or not,as indexes are used to increase the performance.


3What Are Pros Of Back End Testing?

Ans:
PROS:

1. The back end is no longer a “black box”
to testers. Many bugs can be effectively found and fixed in the early development stage. Take Forecast LRS as an example; the number of bugs in a back
end was more than 30% of total number of bugs in the project.
2. When back end bugs are fixed, the system quality is dramatically increased.


4How To Do Functional Testing in Backend?

Ans: A back end structure is divided into number of tests
Based on application functionality. The tests focus input and output conditions but not structure or implementation.


5How To Do Boundary Testing In Backend?

Ans: To check the boundary conditions of columns.


6How To Do Stress Testing In Backend?

Ans: Testing database under heavy loads.
e.g.: testing the table which has large number of records
Used by number of users at the same time.


7How Are Integration Tests Done In SQL Server?

Ans: Integration tests should be performed after the above component testing is done. It should call stored procedures intensively to select, update, insert and delete records in different tables and different sequences.

The main purpose is to see any conflicts and incompatibility.

  • Conflicts between schema and triggers
  • Conflicts between stored procedures and schema
  • Conflicts between stored procedures and triggers


8What Is Benchmark Testing?

Ans: When a system does not have data problems or user interface bugs, system performance will get much attention. The bad system performance can be found in benchmark testing.

Four issues must be included:

  • System level performance
  • Major functionality (Pick up most-likely-used functions/features)
  • Timing and statistics (Minimal time, maximal time and average time)
  • Access volume (A large number of machines and sessions must be involved.)


Ans: here are several phases in back end testing. The first step is to acquire design specifications for an SQL server. The second step is test specification design. The next step is to implement the tests in this design with SQL code. The test sp...  


10Differences Between Back End Testing And Front End Testing?

Ans: It is not easier to understand and verify a back end than a front end because a front end usually has friendly and intuitive user interfaces.
A back end has its own objects, such as, tables, stored procedures and triggers. Data integrity and protection is critical. Performance and multi-user support are big issues. Slowness in operation can be vital to the project’s future.
There are no sufficient tools for back end testing. SQL language is mainly a testing tool. MS Access and MS Excel can be used to verify data but they are not perfect for testing. However, there are a large number of test tools available for front end testing.
To be able to do back end testing, a tester must have strong background in SQL server and SQL language. It is relatively difficult to find testers who understand both SQL server and SQL testing. This causes a shortage of back end testers.


Showing 1 - 10 of 157 Previous | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | Next
Training Schedules
NEW JERSEY-WEEKEND
Schedule: Mon, 6 Oct 2014
Oct
06
ALPHARETTA-ATLANTA
Schedule: Sat, 4 Oct 2014
Oct
04
AUSTIN-TEXAS-WEEKEND
Schedule: Sat, 4 Oct 2014
Oct
04
IRVING-TX-WEEKEND
Schedule: Sat, 23 Aug 2014
Aug
23
VIRGINIA-QA WEEKEND MORNING
Schedule: Sat, 7 Jun 2014
Jun
07
Online Batch(Weekday Evening...
Schedule: Mon, 30 Jun 2014
Jun
30
ONLINE WEEKEND-QA
Schedule: Sat, 31 May 2014
May
31
Shadow Bottom
   
© 2005 - 2014 Krishna Training.