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
- 24963 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 |
who prepares the use cases?
What is the good qualities of test enginner
what is build? what is build coniguration?
I have 2 yrs 10 months experience in manual testing. there is a gap of 3 yrs in between. just 3 months before i rejoined the same company. I am looking for new & better job.What I have to enhance my career to up level, should I have to do Automation course or any other. Guide me properly.
howmany buids u hav in u r project , for how many days u get build
Do the test cases differ for Functional,Integration,System and User Acceptance Testing???
How to prepare traceability matrix?
Hi all, can anyone tell me what is the selection procedure in Birlasoft for Manual Tester?It will be a great help.
Can any one tell me the contents in Traceability Matrix
user A done some changes for a portion of test case doc. And user B also done some changes to same portion. If user-A checks in his file first then user-B. Then what is the state of that file?
What is stub?
Principles of testing?
Automation Testing 
