what are the components of database architecture?

Answer Posted / john

instance-bg process(ckpt,dbwr,lgwr,dnnn,pmon,smon),memory(sga,pga)
storage-tablespace(segment,extent,block),physical files(parameter file,data file, etc)

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain about the implementation of business logic in stored procedures?

423


What is join dependency and inclusion dependency?

470


State about the security aspects of stored procedures?

561


Where the procedures are stored in database?

489


What are pages and extents? : sql server architect

480






What is database architecture? : sql server architect

479


What are the the Advantages of DBMS?

499


What is the difference between stored procedures and stored functions in oracle?

471


What is DML Compiler?

584


Do you know what the restrictions applicable while creating views are? : sql server architect

462


What is VDL (View Definition Language)?

644


What does n tier mean?

416


What is an Entity?

501


What is the difference between "is" and "as" while creating procedure?

446


Explain about the process which takes place to execute a stored routine?

440