Answer Posted / vikneswaran

no,union all and natural join is not same. for example tave
two tame emp and dept

emp table

empid ename salary
1 a 1000
2 b 2000

dept table
deptid deptno
1 10
2 20
if i join this two tables
(empid = deptid)

empid ename salary deptno
1 a 1000 10
2 b 2000 20

if i union a11 this two tables

empid ename salary deptno
1 a 1000 null
2 b 2000 null
1 null null 10
2 null null 20
so join and unionall is not same

How do you optimize a stored procedure in sql?

1018

---

What are tuples in sql?

1199

---

what are local and global variables and their differences? : Sql dba

1136

---

what is a composite primary key ? : Sql dba

1095

---

What is the maximum number of rows in sql table?

1079

---

Write a sql query to find the names of employees that begin with ‘a’?

1057

---

Can we use two order by clause in query?

1016

---

What is mdb stand for?

1060

---

Is natural join and inner join same?

992

---

How to add, remove, modify users using sql?

1089

---

What are the benefits of stored procedures?

1126

---

What is optimistic concurrency control? : Transact sql

1030

---

What is the difference between local and global temporary table?

1088

---

What does the base_object_type column shows in the user.triggers data dictionary view?

1097

---

what is a constraint? Tell me about its various levels. : Sql dba

1049

---