Database [3i Infotech Placement]: Sample Questions 90 - 92 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 90

Database

Question

MCQ▾

How can you CALL Reports from Forms 4.0?

Choices

Choice (4)

a.

Run_Product built_in

b.

Run_Report built_in

c.

Call_Report built_in

d.

Call_Product built_in

Answer

b.

Explanation

  • Calling Oracle Reports using RUN_REPORT is best handled by a generic PL/SQL procedure in forms.
  • It populates all the parameters to execute the report.
  • Call the RUN_REPORT built-in to send a request to oracle reports.

Question 91

Database
Edit

Statement

True-False▾

Explicitly we can assign transaction to a rollback segment

Answer

TRUE

Explanation

  • Yes, we can assign transaction to a rollback segment.
  • Rollback segment is a database object containing before-images of data written to the database.

Rollback Segment

  • Used to undo changes when a transaction is rolled back.
  • Transaction does not see uncommitted changes made to the database.
  • Recover the database to a consistent state in failures.

Two types of rollback segments:

  • Private rollback segments
  • Public rollback segments
Two Types of Rollback Segments

Question 92

Database

Question

MCQ▾

What built-in subprogram is used to manipulate images in image items?

Choices

Choice (4)

a.

Zoom_image

b.

Image_zoom

c.

Zoom_out

d.

Zoom_in ′

Answer

b.

Explanation

Image_zoom is built-in subprogram used to manipulate image in image items.

Developed by: