M.Sc. DEGREE EXAMINATION, APRIL 2018.
Second Semester
Computer Science and Information Technology
DATABASE TECHNOLOGY
(CBCS 2017 onwards)
Time 3 Hours Maximum 75 Marks
Part A (10 x 2 20)
Answer all questions.
1. What is a DBMS?
2. Define
Primary Key
Candidate Key
3. Write the general form of the create table command in
SQL.
4. What is meant by cost-based query optimization?
5. What is a serial schedule? What is a serializable
schedule?
6. Why Concurrency Control Is Needed?
7. Differentiate between distributed database and
Multiprocessor systems.
8. What are the different types of spatial data?
Sub. Code
7MCI2C1
AFS-0665
2
Sp 4
9. What is the goal of security of the database? .
10. List out any four applications of data mining.
Part B x 5 25)
Answer all questions, choosing either or
11. What is a first normal form? Give an example.
Or
Compare tuple relational calculus and domain
relational calculus.
12. What are the different SQL data types? Explain
with examples.
Or
Describe the DML commands in SQL.
13. What are the properties of the transactions?
Explain.
Or
Describe the different types of locks.
14. What do you mean by transparency? Explain the
types of transparencies.
Or
Explain the advantages of distributed databases.
15. Describe the steps of building a warehouse.
Or
Write a short note on statistical database security.
AFS-0665
3
Sp 4
Part C x 10 30)
Answer any three questions.
16. What are the classifications of data models? Describe.
17. Discuss the cost components for a cost function that is
used to estimate query execution cost. Which cost
components are used most often as the basis for cost
functions?
18. Explain the two principal methods for dealing with the
deadlock problem.
19. Write a brief note on mobile and web databases.
20. What are the types of data marts? Explain.
————————