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

Oracle

Question

MCQ▾

The system variable that records the select statement that SQL ⚹ FORMS most recently used to populate a block is …

Choices

Choice (4)

a.

SYSTEM. LAST_RECORD

b.

SYSTEM. CURSOR_FIELD

c.

SYSTEM. CURSOR_RECORD

d.

SYSTEM. LAST_QUERY

Answer

d.

Explanation

  • The system variable that records the select statement that SQL ⚹ FORMS most recently used to populate a block is SYSTEM. LAST_QUERY.
  • SQL ⚹ Forms is used for entering modifying or deleting data contained in an oracle database.
  • A typical SQL ⚹ Forms screen displays explanatory text, graphic, elements and fields that accept data values.
  • SYSTEM. LAST_QUERY will return the last query executed.

Question 106

Oracle

Question

MCQ▾

Can we pass RECORD GROUP between FORMS?

Choices

Choice (4)

a.

Yes

b.

No

c.

All of the above

d.

Question does not provide sufficient data or is vague

Answer

a.

Explanation

Define Types of Record Groups
  • Yes, RECORD GROUP can be passed between FROMS.
  • A record group is oracle form data structure with column-row framework similar to database table.
  • Used for functionally offered by two-dimensional array of multiple data types.
  • Based on a query or on a set of static value.
  • Separate objects in record belong to the form module in which they are defined.
  • The SELECT statements used to create a query record group can be created dynamically at runtime.

Three Types of Record Groups

  • Query record group
    • A record group that has an associated SELECT statement.
    • Query record created and modified at design time or at runtime.
  • Non-query record group
    • A group that does not have an associated query.
    • Created and modified only at runtime.
  • Static record group
    • Not associated with a query.
    • Created and modified only at design time.
Three Types of Record Groups

Developed by: