Answer Posted / lova raju allumalla

when performing joins on two or more tables, we normally
write a query making use relational operators such as =
etc. which means each and every row of every table is
compared with each other,which is a unwanted situation when
looked in the perspective performance issue. where as
making use of corelated query one can minimise the tedoius
checks as described above. consider the example below with
a normal join
select * from emp e,dept d where e.deptno=d.deptno;

now the above same can be performed by using the co related
query
select * from emp where deptno in (select deptno from dept);

u can now make up the difference, in the first approach in
emp table, each row deptno value compared for each row
deptno value of dept table.where as in second approach the
(select deptno from dept) is executed only once for all
checks of the outer query select * from emp where deptno

What is database white box testing and black box testing?

1045

---

Why use truncate instead of delete?

959

---

What is not equal in sql?

1002

---

what is 'mysqldump'? : Sql dba

1046

---

Table A Table B 1 1 2 1 3 1. Union & union all --> A Union B , A Union all B 2. Minus , Intersect --> A minus B , B Minus A , A Intersect B 3. Joins A join B , A Left Join B A Right Join B , A full Join B 4. %Type - Uses & Benifit 5. Truncate & Delete 6. Pragma Autonomus Transaction 7. how to Perform DDL from function or procedure 8. Can we have DML inside Function 9. Rank & Dense Rank diffrence 10. Water Mark in Oracle 11. Index , Can we have index in all column of table if no then why ?

954

---

what are enums used for in mysql? : Sql dba

1106

---

Define union, minus, union all, intersect ?

949

---

Explain the difference between sql and mysql.

1000

---

Explain aggregate functions are available there in sql?

938

---

How much does sql cost?

928

---

How do I know if I have sql express or standard?

975

---

Is sql dba a good career? : SQL DBA

938

---

Differentiate between syntax and runtime errors.

1119

---

How do I create a sql script?

1049

---

What is the difference between execution of triggers and stored procedures?

1048

---