Friday, 16 June 2017

What is Database testing?

Data base Testing is segmented into below four different categories.

  1. Data validity testing
  2. Data integrity testing
  3. Performance related to data base
  4. Testing of Procedure,triggers and functions

What are different types of errors? Explain each.


  • Syntax errors
  • Execution errors
  • Logic Errors


  • Syntax errors: The syntax errors are those that appear as you type the code. Visual Basic checks your code when you type it in the Code Editor window and warns you if you make a mistake, such as mistyping a word or using a language element incorrectly. Syntactic errors are the most frequent errors. They can be easily corrected in the coding environment as soon as they occur.
  • Execution errors: The errors at run-time are those that appear only after compiling and running the code. Errors of this type can be given, for example, in seemingly correct code fragments, for they do not present syntactic errors, but they do not execute correctly. For example, you could correctly type a line of code that opens a file. But, if the file is corrupted, the application will not be able to execute the Open function and will stop its execution. Most of the errors of this type can be corrected by modifying the code that presents errors, then compile it and re-execute it.
  • Logic errors: The logical errors are those that appear when the application is running. They are often unwanted or unexpected in response to user actions. For example, a badly written key or other external influence could cause the application to stop working even if the parameters are correct, or that it simply does not work. Usually, logical errors are the most difficult to correct, since it is not always clear where they originate.


Explain what is Alpha and Beta testing?

When custom software is built for a customer, a series of acceptance tests is performed to allow the customer to validate all requirements. Most software product developers carry out a process called alpha and beta testing to discover bugs that appear to only the end user can discover.

  • Beta test: They are carried out by the end users of the software in the customer workplaces. Unlike the alpha test, the developer is not normally present. Thus, the beta test is a live application of the software in an environment that can not be controlled by the developer. The client logs all problems encountered during the beta test and reports to the developer at regular intervals.
  • Alpha test: They are carried out, by a client, at the development site. The software is used in a natural way with the developer as a user observer and logging errors and usage problems. Alpha tests are performed in a controlled environment.


What do you understand by Integration testing?

Integration testing (sometimes called I & t integration and testing) is the software testing phase in which individual software modules are combined and tested as a group. They are the tests after the unit tests and precede the system test.

What is the exact difference between debugging and testing?

When a test is performed and a defect has been identified, it is the duty of the developers to first locate the defect in the code and then fix it. This process is known as debugging. In other words, debugging is the process of finding, analyzing, and eliminating the causes of software failures.
On the other hand, the test consists of both static and dynamic life-cycle testing activities. It helps determine that the software fulfills the specified requirements and is suitable for the purpose assigned to it.

What do you understand by Unit testing?

In programming, a unit test is a way to test the correct functioning of a code module. This is to ensure that each of the modules functions properly separately. Then, with the Integration Tests, it will be possible to ensure the correct operation of the system or subsystem in question. The idea is to write test cases for each nontrivial function or method in the module so that each case is independent of the rest.

For a unit test to be good , the following requirements must be met:

  • Automated : Manual intervention should not be required. This is especially useful for continuous integration.
  • Complete : Must cover the largest amount of code.
  • Repeatable or Reusable : Do not create tests that can only be executed once. It is also useful for continuous integration .
  • Independent : The execution of one test should not affect the execution of another.
  • Professionals : The tests should be considered the same as the code, with the same professionalism, documentation, etc.


Explain Software Testing?

Software testing is the process of verifying and revealing the quality of a software product. They are used to identify possible implementation failures, quality, or usability of a computer program or video game. Basically it is a phase in software development consisting of testing built applications.

What is the difference between validation and verification? Testing

Verify: It consists of verifying the implementation of the requirements. This involves providing objective evidence that an element meets the specified requirements. You would have to ask yourself the following: " Are we building the product correctly? ".

Validate: It involves checking that the implemented requirements are functional for what was initially built the product. That is, verify that the specified requirements are suitable for an intended use.

What do you understand by dirty read in terms of database?

Dirty reads occur when a transaction is allowed to read a row that was modified by another transaction that has not yet committed. Non-commit readings work the same as non-repeatable readings; However, the second transaction does not need to commit for the first query to return different data. The only thing that can be prevented in the isolation level "Readings without commit" is that the updates appear out of order.