Posts

Database Testing

https://www.youtube.com/watch?v=epvNp7xLtg8 1)What is  a Database? Database is an organized collection of data, which provides efficient retrieval of the data. 2) What is DBMS? DBMS: Data base  Management System.  It is system of systematic  way of  Creating, Storing, Retrieving and Managing of data. Ex: File system, XML 3) What is RDBMS? Relational Database Management System: Is a database system based on relational model. Ex: SQL Server, Oracle 4) What is Database testing? Database testing is a process of testing the behavior of the database with reference to front-end web/desktop application. Any changes made in the front end should change backend and vice versa Data Integrity Data Validity Data base performance Testing of functions, procedure and triggers  5) What do we need to check in Database testing ? Constraint check Verification of a field size and type Stored procedures, Triggers Performance based issues 6) How do you test Data Integrity? What do you ...

Excel Shortcuts

https://www.youtube.com/watch?v=DnizzffAphc

Integration Testing

https://www.youtube.com/watch?v=jAipY2qFuuk     1) What is Integration  testing? Integration testing is to Integrate/combine the unit tested module and test them as a combined unit . Integration testing tests integration or interfaces between components, interactions to different parts of the system such as an operating system, file system and hardware. The individual modules are first tested (unit testing). Once the modules are unit tested, they are integrated to validate that they communicate with each and function as per the requirements. 2) When should be Integration testing implemented ? At the end of the cycle Simultaneously with the development. 3) What are the types of Integration testing techniques? A) Big Bang Approach : In Big Bang integration testing all modules are integrated simultaneously, after which everything is tested as a whole. Advantage : testers get completely developed module. Challenge of testing which does not exist does not exist. Disadva...

Excel Basics

https://www.youtube.com/watch?v=KzXn0JJTTsI Row is a horizontal stack of cells and labelled by numbers ex row 1, row 2 and so on. Column is a vertical stack of cells and labelled by alphabets Column A, Column B and so on. Shortcut Copy  Ctrl C Cut Ctrl  X Paste Ctrl V Undo Ctrl Z    

Add 3 digit numbers mentally

https://www.youtube.com/watch?v=wCln1fzvaDQ Tips for mental addition Start from left Avoid using  words like "plus", and" as that takes time to process. Practice, practice Learn compliments.            

Regression Testing

https://www.youtube.com/watch?v=qaANTCZt20g What is Regression testing? It is a type of software testing that verifies that software performs correctly after the change or defect fix. Changes may include software enhancements, patches, hardware, networking, data structure, configuration changes, etc. In other words purpose of regression testing is to identify that  new defects are not introduced in the system after the change. 2) At what levels regression testing should be done? At all levels mainly Unit Testing, Integration testing and System Testing: Focus on testing is different at different levels. 3) What are the types of Regression testing techniques? Corrective Regression Testing: Progressive Regression Testing: Retest-All Strategy:. Selective Strategy: (dependencies between a test case and the program entities it covers) 4) What should be the frequency of regression testing? Ideally Regression testing should be done after bug fix and after any change to the syste...

Manual Testing vs Automated Testing

https://www.youtube.com/watch?v=2yPpaez1MPk Manual Testing  is a process carried by testing team to find the defects  and to confirm that application works as per the requirements. Testers manually execute test cases without using any automation tools. Tester plays an important role as end user and verify all features of the application work as per requirements. Identify any unexpected behavior or bug Manual testing is necessary find feasibility of automation. 100% automation is difficult task for any software. In Manual testing the designed test cases or test scenarios will be executed and any differences between actual and expected results are reported as defects. Once the reported defects are fixed, the testers will retest the defect to make sure that the defects are fixed It is preferable to execute User Interface test cases using manual testing. Manual testing is slower than automation. Running tests manually can be very time consuming. What is Automated Testi...