What are the basic elements of Base configuration of an
oracle Database ?
Answer Posted / 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 |
Post New Answer View All Answers
Define sub-query.
Mention a query to calculate the even and odd records from a table
What is a key in database?
Which database is best for large data?
Explain the terms database and dbms. Also, mention the different types of dbms.
What's the difference between file and database? Can files qualify as a database?
What are different types of transaction isolation levels?
How do I convert a spreadsheet to a database?
Is it possible to break netlibs encryption?
What are the types of model?
What do you mean by extension and intension?
How can you get the alternate records from the table in the sql?
How many records can a database hold?
What is procedure in dbms?
State at least four kinds of indexing?