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

Oracle

Question

MCQ▾

Which of the following is TRUE for a ERASE packaged procedure …

1. ERASE removes an indicated Global variable & releases the memory associated with it

2. ERASE is used to remove a field from a page

Choices

Choice (4)

a.

Only 1 is TRUE

b.

Only 2 is TRUE

c.

1 & 2 are FALSE

d.

1 & 2 are TRUE

Answer

a.

Explanation

  • ERASE removes an indicated Global variable & releases the memory associated with it.
  • When erase is called on variable the procedure and scripts that depend on the object fail- object and scripts have to be updated to reflect the delete of procedure.
  • Requires ALTER permission on the schema and procedure control permission on the procedure.

Question 98

Oracle

Question

MCQ▾

For a field in a repeating frame, can the source come from a column which does not exist in the data group which forms the base of the frame?

Choices

Choice (4)

a.

Yes

b.

No

c.

Question does not provide sufficient data or is vague

d.

None of the above

Answer

a.

Explanation

  • Yes, for a field in a repeating frame, the source can come from a column not existing in the data group forming the base of the frame.

Repeating Frames

  • Used to print records for a group.
  • Surround fields created for a group՚s columns.
  • Print ones for each of the records of the group.
  • Used to display the objects multiple times like database columns, sub-totals, and page-totals.
  • Contains other object and prints once for each record of the “Associated Group” .

Developed by: