IF EMP HAS 2 ROWS,DEPT HAS 4 ROWS.WHATS THE RESULT OF SELECT * FROM EMP,DEPT;

IF EMP HAS 2 ROWS,DEPT HAS 4 ROWS.WHATS THE RESULT OF

SELECT * FROM EMP,DEPT;

Question Posted / pavan

1 Answers
4939 Views
I also Faced
E-Mail Answers

IF EMP HAS 2 ROWS,DEPT HAS 4 ROWS.WHATS THE RESULT OF SELECT * FROM EMP,DEPT;..

Answer / shailesh

Cartetian product i.e. 8 rows will be returned.

Is This Answer Correct ?

26 Yes

0 No

Post New Answer

More SQL PLSQL Interview Questions

explain the advantages and disadvantages of stored procedure? : Sql dba

0 Answers

How do I run pl sql in sql developer?

0 Answers

ename empno deptno amar 1 10 akbar 2 20 anthonny 3 30 jonathan 4 40 write a procedure to dispaly the column values ina row separated by a deleimiter eg - input - select ename from emp '|' output - amar|akbar|anthony|jonathan input - select empno from emp '@' o/p - 1@2@3@4 input - select deptno from emp '/' o/p - 10/20/30/40 Pls answer this questn.

2 Answers

Does access use sql?

0 Answers

i have a word ***********hello********world******. I require a o/p **********hello world**********, Need to delete the middle stars.

3 Answers

What is the cause of mutating table error and how can we solve it?

0 Answers

How to export the table data (this table having 18 million records) to .csv file. Please tell me is there any faster way to export the data.

8 Answers

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

0 Answers

Define select, insert, create, delete, update, drop keywords