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

How does sql*loader handles newline characters in a record? : aql loader

0 Answers  

What is sql comments?

0 Answers  

what are the join types in tsql? : Transact sql

0 Answers  

how can we find the number of rows in a table using mysql? : Sql dba

0 Answers  

what is an extent ? : Sql dba

0 Answers  




Is the primary key an index?

0 Answers  

what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba

0 Answers  

What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql

0 Answers  

How does a self join work?

0 Answers  

can i use global variables in stored procedure or function

1 Answers   L&T,

How many databases can sql express handle?

0 Answers  

In testing where do we use sql language and how it helps in testing?

2 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories