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;..

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

discuss about myisam index statistics collection. : Sql dba

0 Answers  


What is the difference between sql and t sql?

0 Answers  


What is data type in sql?

0 Answers  


What is the location of pre_defined_functions.

0 Answers  


four procedures is are there should i write their in a package

2 Answers  






Explain sql data types?

0 Answers  


Explain the components of sql?

0 Answers  


What is difference between cursor and trigger?

0 Answers  


How can u find column name from a table which have max value in a row.( not max value)

5 Answers  


What is the use of index in hive?

0 Answers  


What are the different operators available in sql?

0 Answers  


what is mean by forward declaration and where we'll use it.

4 Answers   TCS,


Categories