Interested to Buy Any Domain ? << Click Here >> for more details...
What are the basic elements of Base configuration of an
oracle Database ?
- 1 Answers
- 5848 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 |
Who introduced dbms?
Explain the Difference Between OLTP and OLAP Databases.
Mention the different types of cursor?
Can an Alert message be changed at runtime ?
What are the 3 types of relationships in a database?
Give the cobol definition of a varchar field 177 when can an insert of a new primary key value threaten referential integrity?
What is rdbms architecture?
What is dba in dbms?
Which is the best free database software?
Explain the types of database normalization?
What are the applications of rdbms?
What is the use of FILE option in EXP command ?
-
Oracle (3253) - 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)
