Oracle DBMS Interview Question and Answers

9. What is trivial functional dependency?
  A trivial function dependency is the situation, which shows a relation between an attribute with a superset of itself such that the attribute is dependent on the superset.
 
Your Name Your Email-ID
Your Answer
10. What is the standard normal form for most Online Transaction Processing (OLTP) databases?
  3NF is the standard normal form for most OLTP databases.
 
Your Name Your Email-ID
Your Answer
11. What is full functional dependency?
  Full functional dependency is the situation when an attribute depends on a group of attributes completely but not on the subset of the attributes.
 
Your Name Your Email-ID
Your Answer
12. What is multi valued dependency?
 
  • A multi valued dependency is the situation when an attribute is dependent on another attribute.
  • However, there are multiple rows in a table representing the dependency. This situation can happen when there is at least one or more attribute which is dependent on A and it requires to have multiple rows of A and B to represent all the possible combinations.
  • A multi valued dependency is represented by A >> B.
 
Your Name Your Email-ID
Your Answer
12345 Page 3 of 5