Database-Oracle [3i Infotech Placement]: Sample Questions 38 - 39 of 132

Glide to success with Doorsteptutor material for competitive exams : get questions, notes, tests, video lectures and more- for all subjects of your exam.

Question 38

Oracle

Question

MCQ▾

What type of file is used for porting Forms 4.5 applications to various platforms?

Choices

Choice (4)

a.

. EXE file

b.

. FMB file

c.

. FMT file

d.

. FMX file

Answer

c.

Explanation

The Text and Documentation Files

In Forms 4.5 the PL/SQL code is in text form in the FMT file- allowing search for code, or export to FMB files.

Question 39

Oracle

Question

MCQ▾

LGWR process writes information into … .

Choices

Choice (4)

a.

Redo log files

b.

Database

c.

Control files

d.

None of the above

Answer

a.

Explanation

Structure Understanding of LGWR
  • LGWR process writes information into redo log files.
  • Redo log files are created upon database creation and addition one time added by the DBA.
  • When we start a database instance, LGWR is an oracle background process created.
  • Writes the redo log buffers to the on-line redo log files.
  • Redo log data is always written first to a buffer in memory, and then written to disk by the LGWR process.

The LGWR process is also responsible for:

  • When a transaction is committed, writing commit records to the log file
  • Multiple commits that is written in a single operation when database activity is high.
  • Recording a system change number to each committed transaction, for use in recovery operations when running Parallel Server.

Developed by: