Interested to Buy Any Domain ? << Click Here >> for more details...
What are the basic elements of Base configuration of an
oracle Database ?
- 1 Answers
- 5783 Views
- I also Faced
- E-Mail Answers
Answer / guest
It consists of
one or more data files.
one or more control files.
two or more redo log files.
The Database contains
multiple users/schemas
one or more rollback segments
one or more tablespaces
Data dictionary tables
User objects (table,indexes,views etc.,)
The server that access the database consists of
SGA (Database buffer, Dictionary Cache Buffers,
Redo log buffers, Shared SQL pool)
SMON (System MONito)
PMON (Process MONitor)
LGWR (LoG Write)
DBWR (Data Base Write)
ARCH (ARCHiver)
CKPT (Check Point)
RECO
Dispatcher
User Process with associated PGS
| Is This Answer Correct ? | 0 Yes | 0 No |
What is big data database?
What are the advantages and disadvantages of views in the database?
Enlist some commands of dcl?
Can the User set Archive file name formats ?
How does notification services work?
What are different cursor types in dbms?
How is view stored in database?
Describe the difference between homogeneous and heterogeneous distributed database.
What are cursors and what are the situations you will use them?
How can we tune if buffer busy wait issue comes in oracle?
What is dbms architecture?
Explain what are super servers?
-
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)
