shashikant


{ City } pune
< Country > india
* Profession * team leader
User No # 8812
Total Questions Posted # 1
Total Answers Posted # 2

Total Answers Posted for My Questions # 1
Total Views for My Questions # 11313

Users Marked my Answers as Correct # 46
Users Marked my Answers as Wrong # 5
Questions / { shashikant }
Questions Answers Category Views Company eMail

structural difference between bitmap and btree index ?

Infosys,

1 Oracle General 11313



Answers / { shashikant }

Question { 4255 }

Explain the difference between a hot backup and a cold
backup and the benefits associated with each


Answer

Hot Backup
taking backup, When the database is up & Running
making database in archivelog mode ,
using the command like alter database begin backup

Cold Backup
taking backup when is database is off.



Is This Answer Correct ?    2 Yes 0 No

Question { 32910 }

what is difference between where clause and having clause?


Answer

in 'where' clause every records filtered based on where
in 'having' is with aggregate records (group by functions )

Is This Answer Correct ?    44 Yes 5 No