Database Questions
EXAM QUESTIONS
1. Give 2-3 examples of the database applications.
2. What is the role of the database in the IS generic architecture?
3. What is file-based system? Give 2 examples of FBS.
4. What are main limitations of FBS?
5. What is database?
6. What does it mean that database is self-describing collection of interrelated records?
7. What does it mean that data is integrated?
8. What does it mean that database is collection of logically related data?
9. What is DBMS?
10. What are the main categories of database languages?
11. What is view?
12. What is it created for?
13. What are the main benefits of views?
14. List the main generic components of DBMS.
15. What is system catalog? What is the main role of system catalog?
16. What are procedures of DBMS?
17. What kind of people roles do you know? What are they responsibilities?
18. What is the role of ANSI SPARC architecture?
19. What are the objectives of ANSI SPARC Architecture?
20. What is the structure of ANSI SPARC Architecture?
21. Describe the levels of ANSI SPARC Architecture?
22. What is data independence?
23. What kinds of data independence do you know?
24. What is schema mapping and what types of schema do you know?
25. What is difference between procedural and non-procedural DML?
26. What is data model?
27. What is the purpose of data model?
28. What are the main parts of every data model?
29. What kinds of data models do you know?
30. Characterize the hierarchical data model.
31. What is the main constraint related to hierarchical data model?
32. List main functions of DBMS.
33. What kinds of multi-user DBMS architectures do you know?
34. What are the disadvantages of DBMS?
35. What is the main purpose of Codd’s rules?
36. Define the basic relational model terminology.
37. Give an example of attribute domain.
38. What is relation degree?
39. What is cardinality?
40. What is mathematical basis of relational model?
41. What are the properties of relations?
1. Give 2-3 examples of the database applications.
2. What is the role of the database in the IS generic architecture?
3. What is file-based system? Give 2 examples of FBS.
4. What are main limitations of FBS?
5. What is database?
6. What does it mean that database is self-describing collection of interrelated records?
7. What does it mean that data is integrated?
8. What does it mean that database is collection of logically related data?
9. What is DBMS?
10. What are the main categories of database languages?
11. What is view?
12. What is it created for?
13. What are the main benefits of views?
14. List the main generic components of DBMS.
15. What is system catalog? What is the main role of system catalog?
16. What are procedures of DBMS?
17. What kind of people roles do you know? What are they responsibilities?
18. What is the role of ANSI SPARC architecture?
19. What are the objectives of ANSI SPARC Architecture?
20. What is the structure of ANSI SPARC Architecture?
21. Describe the levels of ANSI SPARC Architecture?
22. What is data independence?
23. What kinds of data independence do you know?
24. What is schema mapping and what types of schema do you know?
25. What is difference between procedural and non-procedural DML?
26. What is data model?
27. What is the purpose of data model?
28. What are the main parts of every data model?
29. What kinds of data models do you know?
30. Characterize the hierarchical data model.
31. What is the main constraint related to hierarchical data model?
32. List main functions of DBMS.
33. What kinds of multi-user DBMS architectures do you know?
34. What are the disadvantages of DBMS?
35. What is the main purpose of Codd’s rules?
36. Define the basic relational model terminology.
37. Give an example of attribute domain.
38. What is relation degree?
39. What is cardinality?
40. What is mathematical basis of relational model?
41. What are the properties of relations?