Sign Up Login


  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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

SELECT * FROM EMP,DEPT;

Question Posted / pavan


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

what is difference between procedure and function, procedure and trigger?

8 Answers   iFlex,

wa procedure to return the month and the no'f developers joined in each month.

4 Answers   Fidelity,

what is explain plan?, given an example...

3 Answers   Polaris,

What are types of indexes in sql?

0 Answers  

Can a table have no primary key?

0 Answers  




What are the types of functions in sql?

0 Answers  

how to use myisamchk to check or repair myisam tables? : Sql dba

0 Answers  

i have a table with column sno with 30 records. i want to update this column by item by item in asp.net. i wantto enter new values into that from 1 to 30 how is it possible with backend c#

1 Answers  

How do you write an inner join query?

0 Answers  

What is dml with example?

0 Answers  

how to rename an existing column in a table? : Sql dba

0 Answers  

What is java sql connection?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories