HOME WORK -1: WEEK-5: SQL-New

1. What is the most complex SQL quary you have written?
2. Write a SQL statement to retrieve all the data from a table called ‘class’.
3. Write a SQL statement to retrieve all the data from a table called 'qaclass06'.
4. Display class name and class location from the table 'class'.
5. Display Last Name, First Name, ID and Phone No from 'qaclass06'.
6. Insert 4 Rows and data in 'class'.
7. Insert one row of data in 'qaclass 06'.
8. Write the syntax for the following: drop, delete, and truncate.
9. Join three tables using alias.

HOME WORK -2: WEEK-5: SQL-New

1. What is Inner Join? Please explain with examples.
2. What is Outer Join? Please explain with examples.
3. Please write complete SQL query using the following:

where, insert, update, delete, order by, in, between, inner join, left join, right join, union, drop, alter, group by.

HOMEWORK -2: WEEK: 3

Question 7. Have you attended Walkthrough meeting? What is done in Walkthrough meetings?
Question 8. What are different STATUS in a defect? Explain.

HOMEWORK-1: WEEK- 3

Question 3. Once you find a defect, what do you do?
Question 4. What fields are there in a Defect Log window?
Question 5. What different types of jobs have you done in TestDirector?
Question 6. What are different levels of severity of a Defect?

HOMEWORK-2: WEEK -2

Question 2. Definte the following terms:

Unit Testing, Shakeout Testing, Smoke Testing, Integration Testing, Functional Testing, Load Testing, Stress Testing, Performance Testing, Negative Testing, Positive Testing. UAT (User Acceptance Testing), Black Box Testing, White Box Testing, Backend Testing, Alpha Testing
Beta Testing.

HOMEWORK-1: WEEK -2;

Question 1. How is a build prepared?

Explain the process.