M.Sc. DEGREE EXAMINATION, NOVEMBER 2017
Second Semester
Computer Science and Information Technology
DATA BASE TECHNOLOGY
(CBCS 2014 onwards)
Time 3 Hours Maximum 75 Marks
Section A (10 X 2 20)
Answer all questions.
1. Mention the characteristics of Database.
2. What do you meant by denormalization?
3. Define database objects.
4. List out the commands available in DDL.
5. Mention the properties of transaction.
6. What do you mean by transactions?
7. List out any two advantages of parallel databases.
8. Define spatial databases.
9. Define data cube.
10. What are the security specifications available in SQL?
Sub. Code
4MCI2C1
AFF-4990
2
sp 6
Section B X 5 25)
Answer all questions.
11. How to create E-R Model?
Or
Write short note on various types of data models.
12. Discuss about the views in SQL with an example.
Or
What are the commands available in DML? Write
its syntax and example.
13. Write a short note on Two phase commit protocol.
Or
Explain deadlock in databases with an examples.
14. Write a short note on distributed databases.
Or
Discuss about the multidimensional databases.
15. Define Data Mining. Describe the various
advantages of data mining.
Or
Write short note on security threats in database.
AFF-4990
3
sp 6
Section C X 10 30)
Answer any three questions.
16. Explain the domain key normal form with an example.
17. Describe about the query processing and optimization.
18. Give a brief account on concurrency control mechanisms.
19. Discuss about mechanisms in mobile and web databases.
20. Explain in detail the statistical database security.
————————