Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  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 the difference between drop and truncate commands?

0 Answers  

What is sql clause?

0 Answers  

What is schema in sql example?

0 Answers  

Does sql require a server?

0 Answers  

How do I find duplicates in two columns?

0 Answers  

What is a primary key sql?

0 Answers  

What is the difference between a primary key and a clustered index?

0 Answers  

Write a query to get 2nd maximum salary in an employee table ?

69 Answers   Accenture, BirlaSoft, Letse, Logica CMG, Qwest, Rheal Software, Saagam, Semantic Space, Tailor Solution, TCS, TinyERP,

i want to display 1 to 10 numbers using one select statement.

18 Answers   HCL, Nyros, Oracle,

What is cursor and why it is required?

0 Answers  

Which one of the following pairs of aggregate functions do you use with character fields? 1. COUNT(field) and MAX(field) 2. AVG(field) and COUNT(field) 3. MIN(field) and SUM(field) 4. AVG(field) and MAX(field) 5. COUNT(field) and SUM(field)

6 Answers   HCL,

How many types of database triggers can be specified on a table ? What are they ?

2 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories