Consider the following set of relations:
EMP(eno, ename, dno)
DEPT(dno,dname)
Primary key columns are in bold and dno in EMP is a foreign key referring primary key of DEPT table.
Now consider the following queries:
QUERY : 1
SELECT * FROM emp e, dept d WHERE e.dno = d.dno;
QUERY : 2
SELECT * FROM emp NATURAL JOIN dept ;
Then which of the following statements are TRUE regarding the above queries?
- Both Query:1 and Query:2 returns same no of rows.
- Both Query:1 and Query:2 returns same no of columns.
- Both Query:1 and Query:2 returns different no of rows.
- Both Query:1 and Query:2 returns different no of columns.
- I, II only
- I, IV only
- II, III only
- III, IV only