3i Infotech Placement: Sample Questions 356 - 358 of 1245

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

Question 356

Edit

Write in Short

Short Answer▾

When will a constructor executed

Explanation

  • Inbuilt or default constructor, no parameter constructor are executes when objects are created.
  • Parameterized constructor execute whenever it is called.

Question 357

Question

MCQ▾

Which of the following is NOT VALID in PL/SQL?

Choices

Choice (4)

a.

Select … into

b.

Delete

c.

Update

d.

Create

Answer

d.

Explanation

  • Create is NOT VALID in PL/SQL.
  • We use INSERT, UPDATE, and DELETE, SELECT and LOCK TABLE commands.
  • INSET: adds new rows of data to database table.
  • UPDATE: modifies rows.
  • DELETE: removes unwanted rows
  • SELECT: Retrieves rows that search criteria
  • LOCK TABLE: temporarily limits access to a table.

Question 358

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

Developed by: