(Pages 3402
P.T.O.
MAR IVANIOS COLLEGE (AUTONOMOUS)
THIRUVANANTHAPURAM
Reg. No. :.………………… Name :.…………………
Sixth Semester B.Voc. Degree Examination, April 2018
First Degree Programme under CSS Skill Course XXV (for Software Development)
AUSD672 Database Administration
(Common for Regular 2015 and Reappearance 2014 Admn.)
Time: 3 Hours Max. Marks: 80
SECTION A
Answer ALL questions in one or two sentences.
1. What is an instance? What is a schema?
2. Define primary key and foreign key.
3. Differentiate between tables and views.
4. What are the DML commands?
5. How do you create an index in SQL?
6. What is a database? What is a DBMS?
7. Give an example for a decision support system.
8. Who is a DBA?
9. What do you mean by referential integrity?
10. What is a data model?
(10 1 10 Marks)
SECTION B
Answer any EIGHT questions, not exceeding a paragraph of 50 words.
11. What are the advantages of DBMS over file management systems?
12. Distinguish between weak entity set and strong entity set.
13. What are ACID properties?
14. Describe GRANT and REVOKE commands.
15. Discuss aggregate functions in SQL.
16. What is normalization?
17. What is an RDBMS?
18. What is an outer join?
19. Explain two phase locking protocol.
20. Explain ER modeling.
3402
2
21. What are distributed databases?
22. How deadlocks are handled in transactions?
2 16 Marks)
SECTION C
Answer any SIX questions, in a page of 100 words.
23. Explain time stamp based protocol for concurrency control in DBMS.
24. What is functional dependency?
25. What are object oriented databases?
26. Draw an ER diagram for Hospital Management System.
27. Explain key constraints and integrity constraints.
28. Explain the architecture of DBMS.
29. Explain the concept of data independence.
30. Discuss the states of a transaction.
31. Create a table salesman(salesman_id, name,c ity, commission)
Write a SQL statement to display names and city of salesman, who belongs to the city of Paris.
ii) Write a SQL statement to display specific columns like name and commission for all the salesmen.
4 24 Marks)
SECTION D
Answer any TWO questions, not exceeding four pages.
32. Why concurrency control is needed? Explain the problems that would arise when concurrency control is not provided by the database system.
33. What are object oriented databases. List out the advantages and disadvantages.
34. Write notes on the following
DSS 5 Marks
Data dictionary 5 Marks
DCL 5 Marks
35. Consider the relation PLAYER with relational schema PLAYER (Player-no, Player-name, Team, Team-color, Coach-no, Coach-name, Player-position, Team-captain) and set of functional dependencies as follows
F {Player-no → Player-name, Player-no → Player-position, Player-no → Team, Coach-no → Coach-name, Team → Team-color, Team → Coach-no, Team → Team-captain}
Answer the questions given below;
Is PLAYER in 2NF? If not, convert into 2NF.
Is PLAYER in 3NF? If not, convert into 3NF.
15 30 Marks)