DBMS VIVA QUESTIONS
1. What are file oriented systems. How are they stored?
2. Difference between information and data.
3. Difference between random accessing and file oriented systems.
4. Various data models. Explain.
5. What is a pointer?
6. What is a data dictionary? What is stored in it?
7. What is Meta data?
8. What is view?
9. What is an application program?
10. Three different types of data sharing. Explain.
11. What automated systems are used at three different levels users in data sharing?
12. Differences between centralized data base and distributed data base.
13. Who is DBA? What are his duties?
14. What is database planning?
15. What the three levels in a database.
16. DDLC. Outline each step.
17. SDLC.
18. Give a comparison between model and reality.
19. What is mapping.
20. What is object oriented model.
21. Differences between object, Object set, object instance.
22. How do you indicate them in diagram?
23. Different types of keys. Give the differentiation between them.
24. Specialization and generalization representing diagrams. Give an example showing it.
25. What is meant by relationship? How can you represent them in a diagram and explain.
26. What is minimum and maximum cardinality?
27. How many types of relationships can be there between objects? How do you indicate then through diagram?
28. What are attributes? How can you show them as relationships?
29. What is aggregation? Explain higher level relationship, binary relation ship and ternary relationship
30. Differentiate between physical and conceptual objects? give example
31. What is a Relational Data Model?
32. How can you say that a relationship is recursive?
33. Explain the terms tuple, degree of relation, attribute domain, null values and different types of keys?
34. What is meant by “to functionally determine”?
35. What is a constraint? What is entity integrity and referential integrity?
36. What is a schema?
37. Types of anomalies?
38. Normalization process definition?
39. What is data redundancy?
40. State each normal form and explain?
41. What is atomic value?
42. What are functional dependencies? Explain by showing an example?
43. What is a determinant?
44. When does a transitive dependency occur
45. State BOYCEE CODD Normal form.
46. What are multivalued dependencies?
47. Give an example how conceptual models are transformed into relational models.
48. Differentiate between relational algebra and relational calculus.
49. Explain Union, Intersection, product, Divide, Difference, Select, Project.
50. What are joins? Explain different types of joins
51. Explain terms Target list, Qualifying statement in relational calculus.
52. Define existential and universal quantifiers.
53. How do you create schemas? Write the syntax of creating them.
54. What are default values? When are they used?
55. Queries may be asked to write a SELECT statement, CREATE statement, insertion of records, Sub queries, Exists and non-exists operators.
56. How many built in functions are there. Write the query showing those functions.
57. When do you use a “HAVING” clause?
58. What is the use of ‘group by’ clause? Write syntax of group by
59. Queries showing UNION, INTERSECT and EXCEPT operators.
60. Write a query which joins 2 tables and displays the columns of selected columns from both the tables.
61. What is Cartesian product? What is alias?
62. What is a cursor? How are the embedded SQL statements written?
63. Write the query to update any column value in a table, and how to delete any row from a table.
64. Write a query to create a VIEW. What are DDL, DCL, DML commands?
65. How can the SQL queries be executed using QBE?
66. Define target table and QBE.
67. What is an example element in QBE?
68. What is paradox for windows? What is it useful for?
69. What is a client server platform?
70. What are the user defined data types?
71. How do you define a primary key? Write a query.
72. How do you set a foreign key for a column? Write a query.
73. Why are Check constraints useful?
74. What is a stored procedure?
75. Queries using if..else statements, break and continue, while statements.
76. What are triggers useful for?
77. All the terminology used in power builder approach.
78. Differentiate between primary memory (main memory) and secondary memory.
79. What is buffer manager, file manager?
80. What are disk drives?
81. What is cylinder, tracks, blocks, surfaces?
82. What is balanced tree?
83. How are pointers used in mapping relations?
84. What is linked list?
85. What is head list?
86. What are secondary keys?
87. Who is DBA, and what are his primary goals in the organization.
88. How can you avoid concurrency control?
89. What are deadlocks, when are they occurred?
90. What is 2 phased locking?
91. What is transaction?
92. What are an aborted transaction and a committed transaction?
93. What is a log?
94. Encryption
95. What is DDBMS?
96. What are different DDBMS?
97. And all the important terminologies in 5th unit.
No comments:
Post a Comment