please explain database architecture..
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's the difference between a primary key and a unique key? : Sql dba
I need to write a simple query,which one is better select statement or stored procedure?and why?
Write a pl/sql script to display the following series of numbers: 99,96,93……9,6,3?
How can we Get the Updated Rows? ie, There is 100s of Rows i updated the Rows who have salary 5000. then i want to select the Updated Rows. How can we achieve it?
Why self join is used in sql?
What is the difference between local variables and global variables?
Can there be 2 primary keys in a table?
We have a CURSOR then we need BULK COLLECT?
Can I join the same table twice?
What is the purpose of using pl/sql?
Should I use mbr or gpt?
Is sql developer case sensitive?