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

Oracle

Question

MCQ▾

SHOW_ALERT function returns

Choices

Choice (4)

a.

Character

b.

Number

c.

Boolean

d.

Question does not provide sufficient data or is vague

Answer

b.

Explanation

  • SHOW_ALTER displays the given alert, and return a numeric value the operator select one of three alert buttons.

    Syntax

    SHOW_ALERT (alert_id Alert) ;

    SHOW_ALERT (altrt_name VARCHAR2) ;

  • SHOW_ALTER displays model window message in oracle forms
  • FIND_ALTER searches the list of valid alter in form builder.
  • When the given alert is located, the subprogram returns an alert ID.
  • Warning message can be shown using SHOW_ALTER for example, asking for delete confirmation- set the set_alter_button_property before showing alter using SHOW_ALTER.

    Ex

  • If we press the first button, it will return:

ALTER_BUTTON1

Question 44

Oracle

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.

Developed by: