Interested to Buy Any Domain ? << Click Here >> for more details...
self join query in sql.
15 objective questions.
What is equi join and outer join
- 2 Answers
- 9584 Views
- Bally Technologies, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / swaroopa
What is Equi Join and Outer Join ?
Equi Joins are also called Simple Joins or Inner Joins.
An equi-join is a join based on equality or matching
between the column values for two different tables.
This equality is indicated with an equal sign (=) as the
comparison operator in the WHERE clause
Ex:SELECT * FROM manufact, stock
WHERE manufact.manu_code = stock.manu_code
manufact and stock are the tables on the manu_code column.
It retrieves only those rows for which the values of the
two columns are equal.
Outer Join:
OUTER JOIN is used to join two tables even if there is not
a match. The joined table retains each record—even if no
other matching record exists. Outer joins subdivide further
into left outer joins, right outer joins, and full outer
joins, depending on which table(s) one retains the rows
from (left, right, or both).
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / latha
self join:one physical table is divided into two logical tables and perform join operation on that tables.
query:
select a.eno,a.ename,b.ename as manager name from emp a,emp b where a.manager num=b.eno
equi join:perform join operations on matching columns on both the tables
| Is This Answer Correct ? | 1 Yes | 1 No |
How do you decide when you have 'tested enough?'
write test case for gmail sign up page ?
They showed me a Web page containing 3 text boxes labeled as Name, D.O.B & Blood Group.It also have 3 Buttons as OK, CANCEL,Reset. They told me that 1) when you click on OK it'll route you to the next page and save the data in the database. 2) When you click on CANCEL it'll route you to the previous page. 3) When you click on Reset it'll clears all the entries made by you. Now they asked me to write Test cases to test the functionality of that web page & asked me to write 1 critical test case after which they will give final go ahead to test the rest of the application... I wasn't able to write the critical test case. Plz answer.
How a test engineer will convince a test lead when he didn't approve the bug as a report ???
What do you plan to become after say 2-5yrs (Ex: QA Manager, Why?)
who will collect requirements from client
what statements did Philip Crosby use to capture the essence of the Quality Assurance discipline?
What is difference between system and functional testing?
what is link testing?
What ishigh severity, low priority bug?
Hi I just wanted to know the name of the document given by the test lead to the tester regarding their module for testing.
What is QTP? What is Regression and retest? What is end to end testing? What is Latest QTP version and TD version? TD is test mgmt tool or resource mgmt tool? Why QTP and WR is called mercury interactive tool? Difference between end to end and system testing? Types of Testing performed in your project? What is testing component? What is test script?
Automation Testing 
