Tag: databases

Questions Related to databases

Which process creates archive log files?
technology databases

  1. LGWR

  2. ARCH

  3. ZIP

  4. CKPT

Show answer
Correct Option: B

Which is the smallest logical unit in Oracle database?
technology databases

  1. Extent

  2. Block

  3. Segment

  4. Table

Show answer
Correct Option: B

Which file contains database name, location of data files and important information used to start the Oracle database?
technology databases

  1. Redo log file

  2. Data file

  3. Archive log file

  4. Control file

Show answer
Correct Option: D

Give names of different segments.
technology databases

  1. Data Segment

  2. Index Segment

  3. Table Segment

  4. Rollback Segment

  5. Temporary Segment

Show answer
Correct Option: A,B,D,E

Which file contains all different Oracle configuration parameters?
technology databases

  1. Data file

  2. Control file

  3. Parameter file

  4. Redo log file

Show answer
Correct Option: C

Which Oracle background process performs instance recovery?
technology databases

  1. PMON

  2. SMON

  3. INSTMON

  4. IMON

Show answer
Correct Option: B

Which Oracle background process performs server process recovery?
technology databases

  1. PMON

  2. SMON

  3. PROMON

  4. IMON

Show answer
Correct Option: A

Archive log is generated only when database is working in ARCHIVELOG mode.
technology databases

  1. True

  2. False

Show answer
Correct Option: B

which are ETL tools
technology databases

  1. Informatica

  2. Datastage

  3. Abnitio

  4. All the above

Show answer
Correct Option: D

who is the father of datawarehouse
technology databases

  1. Bill Inmon

  2. Dennis Ritchie

  3. shiva

  4. Tal mukha talma

Show answer
Correct Option: A