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
Statement True-False▾
The User can set Archive file name formats
Choices
Choice (4) | |
---|---|
a. | False |
b. | True |
c. | All of the above |
d. | None of the above |
Answer
b.Explanation
- 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
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
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.