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

Oracle

Question

MCQ▾

Which of the following is TRUE for the ENFORCE KEY field

  1. ENFORCE KEY field characteristic indicates the source of the value that SQL ⚹ FORMS uses to populate the field
  2. A field with the ENFORCE KEY characteristic should have the INPUT ALLOWED characteristics turned off

Choices

Choice (4)

a.

Only 2 is TRUE

b.

Only 1 is TRUE

c.

1 and 2 are FALSE

d.

1 and 2 are TRUE

Answer

b.

Explanation

Define Enforcing Key Constrain

ENFORCE KEY field:

  • Is a way to enforce integrity within our oracle database.
  • It a constraint used to enforce a relationship between two tables- the values in the one table must appear in another table.
  • Can be defined in either a CREATE TABLE statement or an ALTER TABLE statement.
  • Indicates the source of the value that SQL ⚹ FORMS uses to populate the field.
  • Field in one table refers to the PRIMARY KEY in another table.
  • Relationships involve a parent table that holds the central data values and a child table with identical values pointing back to its parent.
  • The parent and child tables must use the same storage engine.
  • They must not be temporary tables.

Question 68

Oracle

Question

MCQ▾

Name the two files that are created when you generate a form using Forms 3.0

Choices

Choice (4)

a.

FMB & FMX

b.

INP & FRM

c.

FMR & FDX

d.

Question does not provide sufficient data or is vague

Answer

b.

Explanation

  • INP & FRM are the two files that are created on generating a form using Forms 3.0.
  • Text editors and scripts are used to build INP file form and generate into FRM files which is the final form.

FRM

  • FRM is a file extension for formatting used with MySQL.
  • FRM files are used to define the format of a table used with MySQL.
  • Oracle refuses to support the editing of INP files directly.
  • Other software can generate custom Oracle forms by creating an INP file.
  • FRM files are created by MySQL when the table is created.

Developed by: