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

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

SELECT * FROM EMP,DEPT;

Question Posted / shailesh

Answer Posted / shailesh

Is This Answer Correct ?

26 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is %type in pl sql?

952

Enlist the characteristics of pl/sql?

1778

How delete all data from table in sql?

1003

What does bitemporal mean?

1046

what is an index? : Sql dba

977

Define overloaded procedure?

1056

Write an sql query to select all records from the table?

1000

What is the difference between a database and a relational database?

1081

How to read xml file in oracle pl sql?

897

Can we perform dml in function?

1048

Can we rollback after truncate?

1012

what is an alias command? : Sql dba

1073

what is a control file ? : Sql dba

1017

What is a recursive join sql?

1050

What are character functions?

1072