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

Oracle

Question

MCQ▾

Can we attach the same LOV to different fields at Design time?

Choices

Choice (4)

a.

No

b.

Yes

c.

Question does not provide sufficient data or is vague

d.

All of the above

Answer

b.

Explanation

  • Yes, we can attach the same LOV to different fields at DESIGN time.
  • In object navigator, double-click the object to display the property.
  • Set the LOV properties by entering the name of LOV.
  • Set display coordinate by the list X position and list Y position properties

Advantages of Separate LOV files:

  • Added to any page within an application.
  • All definitions are stored in one location, making it easy to locate and update.

Question 66

Oracle

Question

MCQ▾

How do you pass values from one form to another form?

Choices

Choice (4)

a.

Local variables

b.

Parameters

c.

LOV

d.

All of the above

Answer

b.

Explanation

  • We pass values from one form to another using parameter.
  • Calling from creates parameters- the parameter node.
  • There is flexible way to pass values between forms.
  • When passing one or more parameters to a called form, the calling from performs the bellow steps in a trigger
    • Create a parameter list by executing the add parameter built-in procedure to add one or more parameters list.
    • Execute the call_form, New_form or run_product built_in procedure and include the name or id of the parameter list to be passed to the called form.
  • Add parameter with add_parameter
  • We can create own parameter list programmatically and pass it as an argument in a CALL_FORM or OPEN_FORM.

Developed by: