Interested to Buy Any Domain ? << Click Here >> for more details...
please explain database architecture..
- 1 Answers
- 12704 Views
- Infosys, I also Faced
- E-Mail Answers
Answer / rahul khanke
hi,
basic oracle architecture is devided in 3 stages
1. storage structure
1. physical storage
a. data file
b. control file etc..
2.logical storage
a. tablespace
b. extents etc..
2. memory structure
a. SGA
b. PGA
2. process structure
1. mandatory process
a. SMON
b. PMON etc
2. optional process
and much more
| Is This Answer Correct ? | 8 Yes | 0 No |
What is the use of function in sql?
Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?
What is the plv (pl/vision) package offers?
Can we write create command in the plsql block?if possible how?
define sql update statement ? : Sql dba
What is database migration?
how to get a list of all tables in a database? : Sql dba
What is the maximum size of sqlite database?
Which are sql * plus commands?
what are the differences between procedure-oriented languages and object-oriented languages? : Sql dba
how do u call in & out parameters for stored procedures?
10 Answers A1 Technology, TCS, Techicon,
what are date and time data types? : Sql dba
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
