Database-MySQL [3i Infotech Placement]: Sample Questions 115 - 117 of 162

Glide to success with Doorsteptutor material for competitive exams : get questions, notes, tests, video lectures and more- for all subjects of your exam.

Question 115

Question

MCQ▾

What is SQL ⚹ FORMS

Choices

Choice (4)

a.

SQL ⚹ FORMS is a 4GL tool for developing & executing Oracle based interactive applications.

b.

SQL ⚹ FORMS is a reporting tool

c.

SQL ⚹ FORMS is a 3GL tool for connecting to the Database.

d.

All of the above

Answer

a.

Explanation

Define What is SQL
  • It is a 4GL tool for developing & executing Oracle based interactive applications.
  • Oracle form is the part of oracle՚s developer package
  • Its easer version is called SQL ⚹ FORM
  • A Forms Builder is used to create applications to enter, access, change, or delete data from Oracle databases.
  • The forms runtime environment is needed to execute and compile forms modules.

Question 116

Edit

Write in Short

Short Answer▾

What is Query evaluation engine?

Explanation

  • It executes low-level instruction generated by compiler.
  • Alternative ways of evaluating a query
    • Equivalent expressions
    • Different algorithms for each operation
Alternative Way of Evaluating a Given Query

Question 117

Edit

Describe in Detail

Essay▾

What is degree of Relationship type?

Explanation

  • Degree of relationship is the number of entity sets that are participated in that relationship.
  • The number of entity sets that are connected through the relationship in question is called the degree of relationship.
  • Based on the degree, the relationship may be identified as:
  1. Unary
  2. Binary
  3. Ternary.

Unary relationship

Diagram of Unary Relationship
  • The relationship ‘Represents’ is an one-to-many unary relationship.
  • It connects with only one table

Binary relationship:

Diagram of Binary Relationship
  • The relationship ‘Registers’ is a many-to-many Binary relationship.
  • It connects two entity sets.

Ternary relationship:

Diagram of Ternary Relationship
  • The relationship ‘STC’ is a many-to-many Ternary relationship.
  • It link the entity sets student, courses and teacher.

Developed by: