Save as PDF
Opens your browser print dialog — select "Save as PDF" to download.
Total No. of Questions : 8]
[Total No. of Printed Pages : 2
Roll No.
[2]
MTCF-102
M.E./M.Tech., I Semester
Examination, November 2022
Database Security and Privacy
Time : Three Hours
Maximum Marks : 70
Note: i) Attempt any five questions.
ii) All questions carry equal marks.
1. a)
Define distributed database system? Discuss the advantages and disadvantages of distributed database systems.
b)
What do you understand by data abstraction? Relate the three layer of it using data modeling.
2. a)
Why is BCNF a more desirable normal form than other normal forms? Explain. Construct the relational schema that is in 3rd normal form but not in BCNF? Also, explain with a suitable example why it is not practically feasible always.
b)
Recall the problems arising out of concurrent data access? What are the various methods of handling concurrency?
3. a)
What is read and write locks? How security is applied on write-only model?
b)
Discuss the process of saving database against crashes.
4. a)
Explain the security management system architecture. What is E-mail security?
b)
What is physical and environmental security? Explain different goal of database security.
5. a)
Name the different recovery plans used when the database has been crashed.
b)
Inspect the relationship between a security policy and security model.
6. a)
Justify your answer for implementing non-interference model.
b)
Discuss the Graham-Denning model and Harrison-Ruzzo-Ullman model.
7. a)
Classify the structure of access control.
b)
Write the steps involved for providing better security.
8.
Write short notes on any three of the following
a)
Assurance concepts
b)
Linear hashing
c)
Access matrix model
d)
Optimistic Concurrency Control.
******