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

Oracle

Question

MCQ▾

When is a . FMB file extension is created in Forms 4.5?

Choices

Choice (4)

a.

Run form

b.

Executing form

c.

Save form

d.

Generating form

Answer

c.

Explanation

Define Text Files and Documentation
  • FMB file contains binary source code used by oracle forms.
  • Oracle form is a software product for creating screens that interact with an oracle database
  • Saving a form creates a . FMB file extension- associated with oracle forms.
  • FMB is a module, specifically, a forms module binary file, created by forms builder.
  • Forms use oracle as backend database.

How to open a FMB files.

  • To open an FMB file simply double-click it- associated application will open the file.
  • If correct application is not associated with the extension FMB file then this will not open FMB file.
  • FMB file can be opened using Notepad text-editor.

Question 129

Oracle

Question

MCQ▾

How many columns can a RECORD GROUP have?

Choices

Choice (4)

a.

10

b.

20

c.

50

d.

None of the above

Answer

d.

Explanation

  • Record group is an internal oracle forms data structure that similar to column or row in database table.
  • A record group can have unlimited number of column of type CHAR, LONG, NUMBER or DATE
  • The total size of returned data in one row should not exceed 64k.
  • Record groups are separate objects belonging to the form module.

    Three Types of Record Group

  • Query record group
    • A record group with associated SELECT statement.
    • Created and modified at design time or run time.
  • Non-query record group
    • Does not have associated query.
    • Non-query record groups 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 Group

Developed by: