What is the difference between database server and data dictionary

Questions by padma radhika

Showing Answers 1 - 16 of 16 Answers

Bhargav

  • Oct 31st, 2006
 

Database Server have many schemas, and users, it has only one instance for the organisation, or lets say its an instance of the data with all schema infowhereas the data dictionary contains raw data, of the entire data of the database alongwith compiled code of all packages, procedures, funtions and the all tables.infact the database server stores everything in raw format in the datadictionary they are not diff but areone and the same

  Was this answer useful?  Yes

Raghavendra Jha

  • Nov 11th, 2006
 

Database server is  base on which everything resides,It Contains all the schemas,triggers,views etc..

Data Dictionary contains meta data information about each and every schemas object like tables procedures..etc.

Arun

  • Dec 12th, 2006
 

HiDatabase server is a server on which the instance of oracle as server runs..whereas datadictionary is the collection of information about all those objects like tables indexes views triggers etc in a database..

  Was this answer useful?  Yes

g_sidhu

  • Feb 4th, 2008
 

Database Server: A computer in a LAN dedicated to database storage and retrieval. The database server is a key component in a client/server environment. It holds the database management system (DBMS) and the databases. Upon requests from the client machines, it searches the database for selected records and passes them back over the network.

Data Dictionary: Is a collection of tables created and maintained by

the Oracle Server and Contain database information

Hi,

Database Server:
It's contains the collection of objects (Table,procedure,trigger,sequence,index,etc)
it's also contains the Schema and user details
we can view the details which are in the Database server

DB dictionary:
It's contains the meta data  format of all schema ,user information and  object information also
Its contains the data is in non readable format.

Regards,
MPS
Bangalore

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions