ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
Do you have a collection of Interview Questions and interested to share with us!!
Please send that collection to along with your userid / name. ThanQ
Google
 
Categories  >>  Software  >>  Databases  >>  Oracle  >>  Oracle General
 
 


 

 
 Oracle General interview questions  Oracle General Interview Questions
 OCI interview questions  OCI Interview Questions
 Architecture interview questions  Architecture Interview Questions
 Oracle Security interview questions  Oracle Security Interview Questions
 Database Management interview questions  Database Management Interview Questions
 Forms Reports interview questions  Forms Reports Interview Questions
 Oracle AllOther interview questions  Oracle AllOther Interview Questions
Question 
what is a cartition product?
 Question Submitted By :: Zikku
I also faced this Question!!     Rank Answer Posted By  
 
  Re: what is a cartition product?
Answer
# 1		 
a query with no where clause in it, it will return no of
rows of first table multiplied by no of rows of second table
 
Is This Answer Correct ?    0 Yes 0 No
Patilshashi
[Ancent]
 
  Re: what is a cartition product?
Answer
# 2		 
Cartesian product includes rows from all the tables where
there is no specific criteria to join on.

it does not necessarily mean that there is no where clause
it can have a where clause where you filter data set from
table a, table b, c... and then join these tables to give
you the product of the join.
 
Is This Answer Correct ?    0 Yes 0 No
Ron
 
 
 

 
 
 
Other Oracle General Interview Questions
 
  Question Asked @ Answers
 
what is the difference between UNION AND UNIONALL  2
What is the diff between Oracle and SQL Server  1
Hi Every One , What is the table Space in Oracle Database ? waiting for answere and thankyou  6
Please HELP me its urgent? If i want to EXPORT data from SQL server to ORACLE 11g then how can I replicate data from SQL to ORACLE?  2
what are the differen between key flexifild and discriptive fiexifild.  1
Can we create more than one constraint to column ?  2
What is dictionary cache ?  2
Can objects of the same Schema reside in different tablespaces.?  1
Can we create index on views?  5
difference between imlicit cursor and explicit cursor ? Cap-Gemini1
What is SYSTEM tablespace and When is it Created?  1
How are Indexes Update ?  1
what is analyze command ? what kind of statistics does it generate?  2
can a view be updated?  1
can you call insert/update/delete in select statements. If yes how? If no what is the other way?  1
how do get database name at sql prompt?  1
What is self-referential integrity constraint ?  1
What is the function of Redo Log ?  1
Query to get max and second max in oracle in one query ? Keane-India-Ltd8
What is SGA ? How it is different from Ver 6.0 and Ver 7.0 ?  1
 
For more Oracle General Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us |   interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com