DETAILED READ SECTION

Database Utilities Creation Coding Exercises



Data connectivity one major requirement for test engineers to test along with data correctness. And this can be made possible if you have right set of Database Utilities in your automation framework which can be extended as per your data testing needs.


In this post, We are sharing common Database Utilities which can be used in live projects and also same can be used while solving coding exercises as given by overseas employers to test coding skills of Automation QAs.


Exercise 1:

Write method to Get all data from table in vector format


Exercise 2:

Write method to Get list of all available tables in database


Exercise 3:

Write method to Get list of column names for particular table


Exercise 4:

Write method to Get Column List for all available tables from data base


Exercise 5:

Write method to Establish Connection for given username and password


Exercise 6:

Write method to Execute database query for given username and password


Exercise 7:

Write method to Execute Update Query for given username and password


Exercise 8:

Write method to Execute Procedure Call for given username and password


#NGAutomation

Building better QA for tomorrow