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                      
info       Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff   HERE
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 the use of rank function?
 Question Submitted By :: Zikku
I also faced this Question!!     Rank Answer Posted By  
 
  Re: what is the use of rank function?
Answer
# 1		 
RANK calculates the rank of a value in a group of values. 
Rows with equal values for the ranking criteria receive the 
same rank. Oracle then adds the number of tied rows to the 
tied rank to calculate the next rank. Therefore, the ranks 
may not be consecutive numbers.

eg: SELECT RANK(15500, .05) WITHIN GROUP
   (ORDER BY salary, commission_pct) "Rank"
   FROM employees;
 
Is This Answer Correct ?    0 Yes 0 No
Soujanya
 

 
 
 
Other Oracle General Interview Questions
 
  Question Asked @ Answers
 
How many different types of indexes we have in oracle?  2
how to insert data into partitioned table partition done by Range partition  1
structural difference between bitmap and btree index ? Infosys1
What are the different approaches used by Optimizer in choosing an execution plan ?  1
When does a Transaction end ?  1
what is index?  3
what is RAID technology?which is better RAID 0+1 OR RAID 5?  1
What is a Redo Log ?  2
When can Hash Cluster used ?  1
what is the syntax of DROP command?  5
How do you rate yourself in oracle and sql server ? Keane-India-Ltd1
9)When information has to be stored w.r.t employees and their respective departments, which of the following is the Correct formulation of entries? A)Employee and department would together be represented as an entity. B)This is too less information to decide on entities. C)An employee would be one entity and a department would be another. D)Such a scenario cannot be modelled in RDBMS Mind-Tree2
What is RULE-based approach to optimization ?  1
How are Indexes Update ?  1
How you find out version of installed workflow?  1
What is Normalization ? Keane-India-Ltd8
what is exact difference between drop and truncate table.  2
why pl sql doesn't support retrieving multiple records Mphasis1
select statement does not retrieve any records. what exception is raised?  1
Explain the relationship among Database, Tablespace and Data file?  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