Database-MySQL [3i Infotech Placement]: Sample Questions 71 - 72 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 71

Edit

Write in Short

Short Answer▾

What is Fully Functional dependency?

Explanation

Example of Full Functional Dependency
  • It is based on concept of full functional dependency.
  • A functional dependency X Y is full functional dependency if removal of any attribute A from X means that the dependency does not hold any more.
  • X functionally determines Y.

If for each pair of tuples and for all relations in :

If then we must also have

Question 72

Edit

Write in Short

Short Answer▾

What are stored-procedures? And what are the advantages of using them.

Explanation

  • Database objects that perform a user-defined operation- like data-validation.
  • Extensive or complex processing requiring execution of several SQL statement is saved into store procedures, with all applications calling the procedures.

Advantages of stored-procedures:

  • Easier to maintain and solution of problem as they are modular.
  • Better tuning and performance
  • Easier from a GUI end than using complex queries.
  • Can be part of a separate layer, which allows separating the concerns.
  • Improved security
  • Support automatic execution.
  • Reduced development cost and increased reliability.

Developed by: