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

Oracle

Question

MCQ▾

What is a RADIO GROUP?

Choices

Choice (4)

a.

Mutually exclusive

b.

Select more than 1 column

c.

All of the above

d.

Question does not provide sufficient data or is vague

Answer

a.

Explanation

Define Radio Group
  • A group of radio buttons provides user with a choice of operations or data to use in a query- called radio group.
  • Radio group is mutually exclusive.
  • Perfect way to represent an enumeration.
  • The control returns a numeric value to indicate its state.
  • We can change the value for radio button control with the value property.
  • The data block consists of 3 particular radio groups.

    Different Types of RADIO GROUP

  • Radiogroup
    • The statement type of radio group
    • Displays the text and provides a return value.
  • Radiogroup with Redirect
    • Does not submit the page for processing, but it will redirect the page back.
    • Used to set session state for the item, but not submit.
    • Used when something else on the page may depend on the value for the radio group a condition.
  • Radiogroup with submit
    • Submits the page when an item in the radio group is selected.
Different Types of Radio Group

Question 88

Oracle

Question

MCQ▾

What is a trigger

Choices

Choice (4)

a.

Executed at the arrival of a SQL ⚹ FORMS event

b.

A piece of logic written in PL/SQL

c.

Both a. and b. are correct

d.

Question does not provide sufficient data or is vague

Answer

c.

Explanation

Structure of Trigger
  • When event occurs a trigger is a like stored procedure that oracle database invokes automatically.
  • Like a stored procedure, we can enable and disable a trigger, but unlike stored procedure we cannot invoke it.
  • It includes a name, and one or more PL/SQL statements- SQL and PL/SQL statements execute as a unit and can invoke stored procedures.
  • Triggered automatically when an associated DML statement is executed.

Benefits of triggers:

  • Generate derived column value automatically.
  • Event storing information on table access
  • Synchronous replication of table.
  • Good security authentication
  • Prevent invalid transaction

Developed by: