ValueLabs (Hyderabad) Manual Testing – Written test Questions and Answers
ValueLabs (Hyderabad) Manual Testing – Written test Questions and Answers
Time: 90 Minutes ( 25 Questions)
Value Labs Manual Testing – Written test Questions and Answers- Prepared By_Rakesh Hansalia
1) What is Composite Primary Key.
- A primary key can consist of one or more columns of a table. When two or more columns are used as a primary key, they are called a composite key. Each single column’s data can be duplicated but the combination values of these columns cannot be duplicated.
- For example, if you have a Student table and a Course table, and one student can select many courses and one course can be selected by many students, so this is a many-to-many relationship. So you need to create the third table to define the relationship, say it’s called StudentCourse. It is important to note that you only need the StudentID and CourseID in this table as a composite key. You do not need an extra identity ID column in this table to uniquely identifies each row because only having an ID column to uniquely identifies each row is not sufficient. It cannot prevent the same student selecting the same course from being inserted into this table.
2) Difference between Table and View
Views are essentially logical table-like structures populated on the fly by a given query. The results of a view query are not stored anywhere on disk and the view is recreated every time the query is executed. Materialized views are actual structures stored within the database and written to disk. They are updated based on the parameters defined when they are created.
view uses a query to pull data from the underlying tables.
A materialized view is a table on disk that contains the result set of a query.
3) Difference between ECP and BVA
If I say in one line then ECP doesn’t include the boundary values in class partitions e.g. If we have three classes of 1-20, 21-40 and 41-60 then ECP we are not including the values 1,20,21,40,41 and 60 whereas in BVA we include them also.
4) Difference between Testing Scenario and Test Case
Test case is a condition which is executed for expected output with predefined set of steps with known inputs. Generally a test case have
1) Precondition
2) Steps to execute
3) Input data
4) Expected output
5) Status (Pass/Fail)
Test Scenario is set of test cases. What it means, If you have to withdraw money from an ATM machine, then it is a scenario. But to withdraw money, you need to execute many test cases, needs to provide many inputs and you get many outputs and finally your money with receipt of transaction.
Test Scenario is ‘What to be tested’ and Test Case is ‘How to be tested’.
5) Explain V -model
6) High Priority test cases for ATM application
1. Machine is accepting ATM card
2. Machine is rejecting expired card
3. successful entry of PIN number
4. unsuccessful operation due to enter wrong PIN number 3 times
5. successful selection of language
6. successful selection of account type
7. unsuccessful operation due to invalid account type
8. successful selection of amount to be withdraw
9. successful withdrawal.
10. Expected message due to amount is greater than day limit
11. unsuccessful withdraw operation due to lack of money in ATM
12. Expected message due to amount to withdraw is greater than possible balance.
13. unsuccessful withdraw operation due to click cancel after insert card
14. Check ATM machine is able to print receipts
15. Withdraw amount should be in the multiples of 100
7) Different DDL and DML commands
Data Definition Language (also known as DDL) is a computer language used to define data structures [ALTER COMMENT DROP CREATE]
The most popular form of DML is the Structured Query Language (or SQL). This is a language used for databases, and is designed specifically for managing data in relational database management systems (or RDBMS) [UPDATE DELETE LOCK INSERT SELECT]
9) Is functional Testing and System testing Same?
I would say ..No it’s not same.
-System testing is nothing but testing of the application as whole,where as Functional testing is nothing but testing of the application functionality.
-System testing is one of the phases of testing in SDLC .
For Eg in typical V model in develeopement phase unit testing is performed, followed by integration test and when the software is ready it is deployed to QA environment to perform “system testing “.
System testing is end to end application testing.
Functional testing is the Type of testing. It means testing the various functionalities of the application (individual or integrated) Other type being Non functional.
In system testing phase both Functional and non functional testing is performed.
– Most people think Functional testing and System testing is same. But they differ slightly in that functional testing verifies a software by checking it against designed specification documents while system testing validates a software by checking it against the user requirements.
10) Bug live cycle states
- Open
- Fixed
- Closed
- Reopen
- Obsolete
http://www.software-pointers.com/en-configuration-tools.html
11) Tell me 3 different Software Configuration Management Tools
http://www.software-pointers.com/en-configuration-tools.html
I’ve used VSS( Visual SourceSafe from Miscrosoft) & Tortoise when I was in iGATE patni, Gandhingar.
12) difference between Bug,error,defect
Bug : It is found in the development environment before the product is shipped to the respective customer.
Error : It is the Deviation from actual and the expected value.
Defect : It is found in the product itself after it is shipped to the respective customer.
13) What are the test deliverable in SDLC, when to deliver what doc?
Test cases Documents
Test Plan
Testing Strategy
Test Scripts
Test Data
Test Trace-ability Matrix
Test Results/reports
Test summary report
Install/config guides
Defect Report
Release notes
14) Tell me the concepts present in Test plan.
Refer this link : https://rakeshhansalia.wordpress.com/2012/05/14/test-plan-preparation-for-manual-testing/
15) What are the main issues found in Browser Comparability testing.
Alignment issues, JS errors, Image display problems, Ajax issue
16) bug life cycle
New Bug found > QA log a bug (Open State) > DEV Fix a big (Fixed State) > QA test it (Closed if ok or Reopen it if fails)
17)which is test case optimization method
1)BVA 2) functional testing 3) incremental testing 4) big band
Ans: BVA ( Boundary value Analysis)
18) difference between the delete and truncate command
ü Delete and Truncate both are logged operation. But DELETE is a logged operation on a per row basis and TRUNCATE logs the de allocation of the data pages in which the data exists. You can’t rollback data in TRUNCATE but in DELETE you can rollback data. TRUNCATE removes(delete) the record permanently.
ü You cannot TRUNCATE a table that has any foreign key
constraints. You will have to remove the constraints, TRUNCATE the
table, and reapply the constraints.
19) integration testing would done after system testing
a) true b) false
Ans: False
20) what is static method
There are two types of methods.
- Instance methods are associated with an object and use the instance variables of that object. This is the default.
- Static methods use no instance variables of any object of the class they are defined in. If you define a method to be static, you will be given a rude message by the compiler if you try to access any instance variables. You can access static variables, but except for constants, this is unusual. Static methods typically take all they data from parameters and compute something from those parameters, with no reference to variables. This is typical of methods which do some kind of generic calculation. A good example of this are the many utility methods in the predefined Math class.
All the Best Yaarooooooo J