Database [3i Infotech Placement]: Sample Questions 160 - 161 of 294

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

Question 160

Database

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.

Question 161

Database
Edit

Statement

True-False▾

Multiple Tablespaces can share a single datafile

Answer

FALSE

Explanation

Understanding of Data Storage with Table Space
  • Tablespaces can however be split across multiple files- improve concurrency of multiple sort operation- reduce and avoid oracle database space management operation.
  • Tablespace can be assigned to users with the create user or alter user statement and shared by multiple users.

When a database has multiple tablespaces:

  • Separate user data from data dictionary data to reduce I/O contention.
  • Store the datafiles of different tablespaces on different disk drives to reduce I/O contention.
  • Take individual tablespaces offline while others remain online, providing better availability.
  • Back up individual tablespaces.

Advantages of multiple tablespace for a single application:

  • Deciding the space allocation of each tablespace
  • Managing what is created in which tablespace
  • Multiple tablespaces of similar size, promote parallelization.

Developed by: