2marks
1. Specify the purpose of database system
2. List out the aggregate functions available in SQL
3. Give the properties of decomposition
4. What is BCNF?
5. Give suitable example for insertion anomalies
6. What is buffer manager?
7. State the objective of serializability or mention the types of serializability.
8. What is Mutual exclusion?
9. Write the meaning of white pages and yellow pages
10. What is logical logging?
11. What is referential integrity?
12. Distinguish between homogeneous database and heterogeneous database.
13. Differentiate between schema and instance
14. What is the importance of handling null values in a relation?
15. Define the terms domain, attribute, tuple and relation
16. What is the objective of normalization?
17. Define multivalued dependency
18. Mention the storage types
19. Define term index
20. What is B tree?
21. List the properties of transaction
22. Give the reasons for allowing concurrency
23. What is parallel system?
24. Write the syntax for create table command.
25. Define DBMS? (2times)
26. What is Constraint?
27. What is the need for primary key? Or define the term primary key
28. Write any three aggregate functions
29. What is RAID? (3times)
30. What is Normalization?
31. What is Trigger?
32. Name different types of Relations
33. What is Query?
34. What is Functional dependency?
35. What is Client Server?
36. What is Distributed Database or What are distributed databases
37. Give short notes on database
38. What is Schema?
39. What is Embedded SQL?
40. What is Third Normal Form?
41. What is Functional Dependency?
42. What is File?
43. What is Hashing?
44. What is Buffer Management?
45. What is Deadlock?
46. What is Parallel System?
47. What is Heterogeneous Database?
48. What are the types of Networks?
49. Define DDL and DML Or Write any two DML commands with examples for their
usage.
50. Specify the purpose of database system
51. What is data independence?
52. Define persistence
53. What is data dictionary?
54. Why does normalization be needed?
55. Explain why 4NF is more desirable than BCNF
56. What is referential integrity?
57. What is ARIES?
58. Write the benefits of logical logging
59. Compare single user system and multiuser system
60. What is replication?
61. Give the levels of data abstraction
62. What are stored and derived attributes?
63. List the properties of decomposition
64. What is inheritance?
65. What is sparse index?
66. What are the ACID properties?
5mark
1. What is Embedded SQL? Explain Briefly explain embedded SQL(3times)
2. List out and explain the drawbacks of file processing system
3. Explain the following mapping cardinalities
a. one to one
b. one to many
c. many to one
d. many to many
4. Briefly explain about entity-relationship model Or Explain ER model and ER diagrams
State the procedure to draw ER diagram(3times)
5. Briefly discuss about Static hashing and dynamic hashing Or What is static hashing? Why we
need dynamic hashing?
6. Explain about two phase locking
7. Explain the structure of LAN and WAN (Or) List and explain network types.
8. What is a view? Explain it
9. Brief on relational database design
10. Write short notes on RAID
11. Give brief account on query optimization
12. Describe briefly about deadlocks(10mark)
13. Discuss the purpose of database systems
14. Describe the ideal behind domain relational calculus or write short notes on Domain
Relational Calculus
15. Write briefly on transaction management
16. What is functional dependency? Explain how decompositions is done?
17. Compare homogeneous and heterogeneous database or Compare Homogeneous and
Heterogeneous databases
18. Explain: Client Server Architecture with examples.
19. Give detailed notes on relational model
20. How Second normal forms is obtained? Why is it required?
21. What do you mean table inheritance? Illustrate
22. Describe the method of implementing set operations or Brief on set operations
23. Explain the following operation
(a) Select
(b) Project
24. Tabulate distinction among the following
(a) Primary key
(b) Candidate key
(c) Super key
25. Explain LRU buffer replacement policy
26. List and explain the steps used in query processing
27. Explain ACID properties
28. Write note on volatile, non-volatile, and stable storage
29. Explain the following interconnection networks
● Bus topology
● Mesh topology
● Hypercube topology.
30. Describe the disadvantages of file processing system
31. Write the features of relational design
32. Write a short note on normalization
33. Briefly explain Buffer management
10 Marks
1. Explain various types of join operation
2. Explain about multi-valued dependencies and fourth normal form
3. Explain the various RAID levels or Explain RAID and file organization
4. Briefly explain about Transaction states
5. List out and explain the parallel database architecture.
6. Discuss the various advantages and disadvantages of DBMS
7. Explain basic notations of ER diagram with examples or Explain ER model with the help of a
suitable diagram.
8. Explain in detail about hashing techniques
9. Describe concurrency control with time stamping method Give examples or Explain
concurrency control and deadlock issues
10. Describe the evolution from centralized DBMSs to Distributed DBMSs.
11. Explain the postulates of relational algebra and prove the identities
12. What is an Object based database? Explain the concepts and their preferences.
13. Write short notes on
● Oracle
● B Tree index files.
14. What is DBMS? Explain the with examples
15. Explain the integrity Constraints with examples
16. Describe the methods for query processing and optimization
17. Explain Data Base System Architecture and the role of Data Base Administrator. Or discuss
in detail on database system architecture.
18. Write short notes on
(a) SQL Server
(b) Distributed Data Base System (2 times)
19. Explain the structure of fixed length records and variable length records
20. How is concurrency performed? Explain the protocol that is used to maintain the concurrency
concept
21. Explain client server architecture.
22. Explain design goals of relational database
23. Show insertion and deletion operations on a B-Tree with relevant example
24. How deadlock is handled? Explain
25. Explain about Tuple relational calculus giving examples
26. Consider the bank database
Branch (branch name, branch city, assets)
Customer (customer name, customer street,
Customer city)
Loan (loan number, branch name, amount)
Borrower (customer name, loan number)
Account (account number, branch name, balance)
Depositor (customer name, account number)
Where the primary keys are underlined Construct the following SQL queries for this relational
database
(a) Find all customers of the bank who have an account but not a loan
(b) Find the names of all customers who live on the same street and in the same city as “Smith”
(c) Find the names of all branches with customers who have an account in the bank and who live
in “Harrison”
