Interested to Buy Any Domain ? << Click Here >> for more details...
Hi,
I am new to testing.where we will use SQL in manual testing.
To what extent i need to learn SQl.there are diff types of SQL
like TSql,Mysql etc.i little bit confused,help me.
Thank you .
- 4 Answers
- 24773 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / shanti
testers will use SQL to test the database.
give some input customer id,customer name,address and phone
number. useing sql queries we can check the data is stored
in the database or not.
testers no need more knowledge on sql learn some select
statment,
testers never get access to edit or insert in the database.
that is different team (database team)
knowing select statement is good
| Is This Answer Correct ? | 38 Yes | 2 No |
Answer / amol
Sometimes results of some user actions can not be verified
on UI, we can use SQL to check this.
E.g. Consider a user delete schenario. On UI someone can
select a user to delete and on UI it can be verified if the
same user is not displayed on UI anymore.
But if there is some business logic NOT to delete the user
completly from system, but just mark it as unactive so that
it is not displayed in UI. This logic can not be verified in
UI. For such schenarios we can do a SELECT quesry on
database and check if the user is there with some flag like
deleted=true or active=false.
| Is This Answer Correct ? | 5 Yes | 5 No |
Answer / amol
Database : is a concept to organized collection of data
(today typically in digital form).
Database system (DBMS): is software which are created to
implement the above. Today most of DBMS store data using
some relation between the data hence it is called Relational
DBMS (RDBMS)
There are lot of companies who has created this DBMS like
Oracle, IBM DB2, Microsoft SQL Server, Microsoft Access,
PostgreSQL, MySQL, and SQLite
SQL Structured Query Language) : Is programming language for
querying, altering and defining relational databases(RDBMS);
using declarative statements.
Though it is ANSI standard (meaning every DBMS should
support it and support in same way)
some of the syntax or features in SQL are not supported OR
supported in different way by each vendor/company.
Also some companies provide more features on top of SQL.
E.g. Transact-SQL (T-SQL) is Microsoft's and Sybase's
proprietary extension to SQL.
| Is This Answer Correct ? | 2 Yes | 3 No |
What is an IDE?
What impact ratings have you used in your projects?
Tell exact difference b/w Smoke and Sanity testing with example?
Please tell me difference btn Version & Reversion . Is there any difference btn them or both have same meaning.
1.What is Traceability matrix and how it is done ? 2.What are the different levels of testing used during testing the application? 3.What is Traceability matrix and how it is done ? 4. How can you differentiate Severity and Priority based on technical and business point of view. plz do reply..............
Hi Please tell me about ERP Project how do describe in interview Please tell me details about this project my id is chiku_69@yahoo.in
What is a show-stopper Bug?
hi, this is an interview question."what are the testing skills that u have ?". how can i answer to this one ? reply me correct answer plzzzzzzz
On one of my form there are three text boxes for 1.To Enter Survey no.-Special characters / and - allowed in input and 2.Village Name 3.Project Name all having Input Range 2 to 50 char.and One SUBMIT button on form then How many Test cases can I write for Funtion Testing of Above fields and button
How do u write integration test cases?do u have any special format?
what is meant by deffered status
Usually on which server test engineer works?
Automation Testing 
