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
What is join dependency and inclusion dependency?
What are the levels of architecture?
Explain about the implementation of business logic in stored procedures?
Explain what are the database objects? : sql server architect
What is Weak Entity set?
What is 5NF?
How can we call stored procedures inside store procedures?
Not only RDBMS takes care of locating data it also
What is the job of the information stored in data-dictionary?
What is internal database?
What is DDL (Data Definition Language)?
Explain the benefits of running stored procedure on a database engine?
What do you mean by Correlated subquery?
Does storing of data in stored procedures increase the access time? Explain?
What are the different phases of transaction?