How do we do backend testing.Whatelse do we need to know apart from basic SQL.Do we write SQL statements in the test cases, if so where do we write in TD or QC.Do we use CREATE and UPDATE statements for backend testing.I need this for my interview.
Welcome to the World of Testing - Database Specific
Well testing dB Migration would generally not be covered as part of a Tester's scope. There is a seperate team that looks into Migration projects....
But still if Insistent.....
We could write Automated Scripts which would Compare Table Structure of both the Databases once Migrationis complete. A simple workaround would be to Describe both the table structures in the DB's and take the output to Excel Sheets. We could parameterize DB.Table Name to achieve easier use.
Once the column names are in Excel, a simple Macro program to compare Range of values specified in both columns would suggest if the table was migrated successfully or not.
NOTE : But even then verifying Datatype of columns would not be possible.
Also checking Data Integrity would not be a part of the scope as well..
In QC we can do backend testing in SiteAdmin.We use SQL statements for customization.We write queries in Tables.we have different tables for different modules in QC.For egfects module will have Tables like BUG,BUG TOKENS.Each table will have number of columns like BG_BUG_ID which is an integer type.
When we want to change the defect id then we go for SiteAdmin BUG table and will write Query "update sequences set SQ_SEQ_VALUE='1' where SQ_SEQ_NAME='BUG' ".This query results in changing the existed defect id in defects module starts with one...then the next defect ID will be two....and so on.
If you have any doubts then can get back to me any time as iam working as QC Admin...hope this information is useful for you.
If you are going for Manual then you can write your queries in the qc itself b'coz there is sql add-in . so all you need to do is configure your sql in qc there you may get a screen to write your queries only if your connected with the database only
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.