Sharepoint Databases

Hi,
yes you are right .. everything comes up from content database of sharepoint site
and about web part .. that depends what you are displaying in web part .. you can also display data from file system in a webpart
but precisely you can say that web part data and web part gets stored in Content Database
(there is kind of encryption technique that sharepoint follows to store contents of sharepoint site into Content Database)
 

Thanks bhushan
So is it that all the content that we see on a sharepoint ste goes in the content database..I mean..say if i have a web part on my site...the contents of the web part a Serialized and added to the content database ??

Hi,
SharePoint has a concept of Configuration Database and Content Database. If this can be explained briefly like this, Configuration database is the one which store all configuration Information of your SharePoint farm or in other words , that stores set of setting which you do by using your central administration GUI tool , and about Content Database - they are the databases created at the time of creating SharePoint Web Applicataions for storing web application specific data
one thing to be note is that , there is only one configuration database per farm and there can be multiple content databases in your farm (according to web applications)
so naturally documents in the document library of sharepoint are stored stored in Content Database of respective web application
(there is a table named AllDocs in Content Database in which documents in site gets stored )