Sixth Chapter: Comprehension Based Questions & Answers.

  1. Field and record are not same-explain./Field is not dependent on the record-explain.
  2. Is there needed data validation in DBMS? Explain.
  3. Explain the role of database administrator.
  4. What do you understand by data type? Explain.
  5. Why currency field is used?
  6. Why memo data type is used?
  7. Explain the necessity of database query.
  8. Why SQL is called the arms of database?
  9. Why SQL is called very high level language?
  10. Why SQL is called non-procedural or functional language?
  11. SQL is a collection of statements-explain.
  12. Why composite primary key field is used?
  13. Why data type of primary key and foreign key in database relation should be same?
  14. Primary key and foreign key are not same-explain.
  15. What is meant by uniqueness of a primary key?
  16. Write the role of primary key in database relation.
  17. Sorting and indexing are not same-explain.
  18. “It is not possible to do sorting based on OLE object”-explain.
  19. “On which data types sorting cannot be done”-explain.
  20. If data entries in indexed table, indexed file is updated automatically-explain.
  21. Indexing makes the database system faster-explain.
  22. Indexing doesn’t change the main file-explain.
  23. Write the conditions for creating the relation between two tables.
  24. Explain the type of database having NID related information.
  25. Explain the database of a large financial company.
  26. Explain the process of data security.
  27. Why data encryption is done? Explain./ Why encryption is important for database security?
  28. Plain text and cipher text are not same-explain.
  29. How data security is ensured in personal life.

Leave a Reply

Your email address will not be published. Required fields are marked *