Answer Posted / elumalai d

UNOIN:- It returns all the records from both tables without duplicates.
Example:-
A={1,2,3,4}
B={2,3,4,5,6}
AUB={1,2,3,4,5,6}

CREATE TABLE question36 (empid NUMBER);
CREATE TABLE quest36 (empid NUMBER);

INSERT INTO question36 VALUES(1);
INSERT INTO question36 VALUES(2);
INSERT INTO question36 VALUES(3);
INSERT INTO question36 VALUES(4);

INSERT INTO quest36 VALUES(2);
INSERT INTO quest36 VALUES(3);
INSERT INTO quest36 VALUES(4);
INSERT INTO quest36 VALUES(5);
INSERT INTO quest36 VALUES(6);
COMMIT;

SELECT empid FROM question36
UNION
SELECT empid FROM quest36;

EMPID
---------
1
2
3
4
5
6

DELETE FROM question36;
DELETE FROM quest36;
COMMIT;

MINUS:- It returns table A values not available in table B.
Example:-
A={1,2,3,4}
B= {2,3,5}
A-B={1,4}

INSERT INTO question36 VALUES(1);
INSERT INTO question36 VALUES(2);
INSERT INTO question36 VALUES(3);
INSERT INTO question36 VALUES(4);

INSERT INTO quest36 VALUES(2);
INSERT INTO quest36 VALUES(3);
INSERT INTO quest36 VALUES(5);
COMMIT;

SELECT empid FROM question36
MINUS
SELECT empid FROM quest36;

EMPID
---------
1
4

DROP TABLE question36;
DROP TABLE quest36;

What is the advantage of index in sql?

915

---

What is a sql statement?

900

---

What is the difference between function and procedure in pl/sql?

1013

---

explain the options of myisamchk to improve the performance of a table. : Sql dba

950

---

Will truncate release space?

887

---

What's the difference between inner join and left join?

946

---

Why is a primary key important?

967

---

what is online transaction processing (oltp)? : Sql dba

935

---

What does desc stand for?

1021

---

Mention what are different methods to trace the pl/sql code?

1102

---

Why use truncate instead of delete?

959

---

Why we use joins in sql?

924

---

What is normalisation in sql?

1002

---

Which certification is best for sql?

937

---

Which column of the user triggers data dictionary view displays the database event that will fire the trigger?

969

---