Relational Interview Questions

Relational Interview Questions

  1. What is 2NF?
  2. What is 3NF?
  3. What is 4NF?
  4. What is 5NF?
  5. What is Relationship?
  6. What is File Manager?
  7. What is Buffer Manager?
  8. What is DDL Interpreter?
  9. What is Record-at-a-time?
  10. What is relational database?
  11. What is Relational Algebra?
  12. In mapping of ERD to DFD?
  13. What is Data Independence?
  14. What is degree of a Relation?
  15. Tables derived from the ERD?
  16. What is 1 NF (Normal Form)?
  17. What is Lossless join property?
  18. A dominant entity is the entity?
  19. What is Functional Dependency?
  20. What is multivalued dependency?
  21. What is Query evaluation engine?
  22. What are stand-alone procedures?
  23. What is Set-at-a-time or Set-oriented?
  24. What is Fully Functional dependency?
  25. What is DDL (Data Definition Language)?
  26. What is VDL (View Definition Language)?
  27. What is a Relation Schema and a Relation?
  28. What is BCNF (Boyce-Codd Normal Form)?
  29. What is SDL (Storage Definition Language)?
  30. What is DML (Data Manipulation Language)?
  31. What is Authorization and Integrity manager?
  32. What are cursors give different types of cursors?
  33. What are the different types of JOIN operations?
  34. When is a functional dependency F said to be minimal?
  35. What do you understand by dependency preservation?
  36. What is cold backup and hot backup (in case of Oracle)?
  37. How can you find the minimal key of relational schema?
  38. What is meant by Proactive, Retroactive and Simultaneous Update?
  39. What are Armstrong rules? How do we say that they are complete and/or sound?
  40. How does Tuple-oriented relational calculus differ from domain-oriented relational calculus?