Database-Oracle [3i Infotech Placement]: Sample Questions 79 - 80 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 79

Oracle
Edit

Statement

True-False▾

The User can set Archive file name formats

Answer

TRUE

Explanation

Define Archive Log Files
  • Yes, the user can set archive file name formats.
  • LOG_ARCHIVE_FORMAT is applicable only to redo log in ARCHIVE mode.
  • Text string and variables can specify the default filename format when archiving redo log files.
  • String generate from format is appended to string specified from LOG_ARCHIVE_DEST parameter.

    What is Archiving?

  • Groups of redo log files are saved to offline destination, collectively the archived redo log, or archive log.
  • The process of turning redo log files into archived redo log files is archiving.
  • Only possible when database running in ARCHIVELOG mode.
  • Archived redo log contains a copy of every group enabled for archiving.

    Archived Redo Logs Can

  • Recover a database
  • Update a standby database
  • Get information about the history of a database using the log miner utility.

Question 80

Oracle

Question

MCQ▾

When a form is invoked with CALL_FORM does Oracle forms issues SAVEPOINT?

Choices

Choice (4)

a.

Yes

b.

No

c.

None of the above

d.

Question does not provide sufficient data or is vague

Answer

a.

Explanation

Controling Opened and Called Forms

SAVEPOINT

  • A SAVEPOINT statement names and marks the current point in processing of the transaction.
  • A transaction can partially rolled back to any one the SAVEPOINT.
  • Multiple SAVEPOINT location set transection are denoted by their name, which is unique.
  • Name specification is optional for a single SAVEPOINT in the transaction.

CALL_FORM

  • When Oracle form is run- call form with the same run form is chosen as the parent form.
  • Exited oracle form processing resumes in the calling form at the point from call to CALL_FORM.
  • When call a form, oracle forms issues a save point for the call form.

Syntax of SAVEPOINT:

  • SAVEPOINT [NAME]
  • If we create a second savepoint, then the earlier savepoint is erased.

Developed by: