Which process creates archive log files?
LGWR
ARCH
ZIP
CKPT
Which is the smallest logical unit in Oracle database?
Extent
Block
Segment
Table
Which file contains database name, location of data files and important information used to start the Oracle database?
Redo log file
Data file
Archive log file
Control file
Give names of different segments.
Data Segment
Index Segment
Table Segment
Rollback Segment
Temporary Segment
Which file contains all different Oracle configuration parameters?
Parameter file
Which Oracle background process performs instance recovery?
PMON
SMON
INSTMON
IMON
Which Oracle background process performs server process recovery?
PROMON
Archive log is generated only when database is working in ARCHIVELOG mode.
True
False
which are ETL tools
Informatica
Datastage
Abnitio
All the above
who is the father of datawarehouse
Bill Inmon
Dennis Ritchie
shiva
Tal mukha talma