Interested to Buy Any Domain ? << Click Here >> for more details...
explain the ROLLUP, CUBE, RANK AND DENSE_RANK FUNCTIONS OF
ORACLE 8I
- 3 Answers
- 16285 Views
- IBM, Ness Technologies, I also Faced
- E-Mail Answers
Answer Posted / friend
ROLL UP IS USED TO FIND THE SUB TOTALS ,IT IS USED AFTER
GROUP BY FUNCTION,AND"CUBE"IS ALSO HAVING THE SAME
MEANING,AND RANK FUNC IS USED TO FIND THE RANKS AND IT
GIVES THE SAME RANK IF DATA HAVING SAME DATA,AND DENSE
_RANK ALSO SAME AS RANK BUT IT WILL GIVE DISTINCT RANKS IF
AT ALL IF THE DATA HAVING SAME DATA.
| Is This Answer Correct ? | 8 Yes | 7 No |
Post New Answer View All Answers
What are Non-additive facts?
Theare is a Database In analysis services,How we will specify the fact table.(i.e whether we will create the measure objects for the fact tbl.) or it will reside insde the database.
Explain difference between view and materialized view?
Explain a linked cube?
Explain grouped cross tab?
What are session timeout and application timeout? Where we have to do this process?
Do you view contain data?
What are the types of SCD?
Describe the differences between a data warehouse and data mart.
How are models actually derived?
What is the very basic difference between data warehouse and operational databases?
What are the different types of schemas used in data warehousing?
Explain ddl (data definition language)?
What do you mean by static and local variable?
What is factless fact tables?
