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
- 25064 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 the difference between Test Management tools and Defect Management tools? What are the most widely used Test Management tools?
what is mean security testing ? define with example
can anybody explain traceability matrix clearly
what are the documents that will be created in testing cycle?
What do you mean by offshore and onshore testing?pls tell the models of this testing?
one module contains 3 screens like entry , exit & trasaction. u can perform operations by using these screens and u save that changes but those screens are not displaying on the desktop then how u can assign the seviority?
write the test cases on prime number with result?
can anybody tell me .. in realtime how cookies testing is actually done by the tester? And Test case is needed for cookies testingor not required?
What is penetration matrix and how it is used in software testing?
what is agile model and spiral maodel?pls explain with an example?
What type of testing you do in your project?
3 Answers Geometric Software, TCS,
Can any body tell me in real time how cookies testing is done. And please tell me the steps.And for cookies testing test cases is needed.
Automation Testing 
