Subject Code: 5CS04ADB1 Subject Name: Advanced Database Management System Course Name: M.C.A. Date: 19/5/2015 Semester: IV Marks: 70 Time: 02:30 TO 05:30 __________________________________________________________________________________ Instructions:
1) 2) 3) 4) 5)
Attempt all Questions in same answer book/Supplementary. Use of Programmable calculator & any other electronic instrument prohibited. Instructions written on main answer book are strictly to be obeyed. Draw neat diagrams & figures (if necessary) at right places. Assume suitable & perfect data if needed.
SECTION-I Answer the following questions in short: 1. Define: Database and Database Management System. 2. What is secondary index? Which are the three options for implementing the secondary index? 3. List out the threats to the database security. 4. What is concurrency?
[02] [02] [02] [01]
Answer the following questions: 1. Give distinction between spanned and un-spanned file organization by giving suitable examples. [05] 2. Discuss about clustering index. [05] 3. Who is DBA? Which are the activities performed by DBA? [04] OR Answer the following questions: 1. Explain primary index as a part of single level ordered index. [05] 2. What is MAC? Explain MAC security scheme. [05] 3. Write a short note on database system utilities. [04] Answer the following questions: [14] 1. Discuss in details about various types of users exist in database environment. 2. Explain Multilevel Index with suitable example. OR Answer the following questions: [14] 1. Discuss in detail about Public Key Infrastructure (PKI). 2. Consider the following case: Record size R=500 bytes, block size B=1024 bytes, r=80000 records. Assume the field size V=8 bytes, assume the record pointer size P=6 bytes for index file. Based on above case calculate how many block access is required to perform: (a) Sequential Search on Original Data File. (b) Binary Search on Original Data File. Page 1 of 2 19-5
(c) Binary Search on Primary Index. (d) Binary Search on Dense Secondary Index.
Q. 4
Q. 5
Q. 5
Q. 6
Q. 6
SECTION-II Answer the following questions in short: 1. Draw the neat and clean state transition diagram of a transaction. 2. What is ‘Check Point’? 3. What is ‘Deadlock’? Give one example of deadlocked transactions. 4. What is ‘Sabotage’?
[02] [02] [02] [01]
Answer the following questions: 1. What are the different properties of a transaction? 2. Explain various locking techniques. 3. Discuss deferred update log based recovery technique with appropriate example. OR Answer the following questions: 1. Explain with suitable example immediate update recovery scheme. 2. Discuss in detail with example the concept of view serializability. 3. Write a short note on transaction execution with SQL. Answer the following questions: 1. Explain shadow paging recovery scheme. 2. Which are the problems related to concurrency control? Discuss in detail. OR Answer the following questions: 1. Discuss the concept of deadlock prevention, detection and avoidance. 2. Explain Two Phase Locking Protocol (2PL) for providing consistency.
Give distinction between spanned and un-spanned file organization by giving. suitable examples. 2. Discuss about clustering index. 3. Who is DBA? Which are ...
5.9 Distributed Serializability. 5.10 Classification of Concurrency Control Techniques ... 7.5 Global Query Optimization Algorithms. 7.6 Distributed Database Security. 7.7 View Management ... Laboratory Work with oracle latest version: Page 3 of 6. I
Give distinction between spanned and un-spanned file organization with suitable. example. 05. b. Which are the different database system utilities? 05. c.
(c) What is XML ? How is it different from. HTML ? What are the advantages of XML ? Create an XML schema for list of students and. their marks 70. MCS-043 ...
issue no. and name. Any member can only. read the journal/magazine in library itself. i.e Journal/Magazine cannot be issued. CS-06 1 P.T.O.. Page 1 of 4 ...
1. What are the responsibilities of the DBA ? 3. 2. Explain program â data Independence. 3. 3. What do you mean by domain of an attribute ? Give one example.
2. a) Give an ER diagram for student database, with all essential ER concepts. 12. b) Write the ... b) Explain the ORACLE languages and interfaces briefly. 10. 8.
We might choose to identify a dependent by name alone in this situation, since it is ..... Each song is performed by one or more musicians, and a musician may ...
c) Discuss the classification of DBMS. 5. 2. a) What are the different types of attributes ? Explain with examples. 10. b) Explain the ER-to-relational mapping ...
There was a problem previewing this document. Retrying... Download. Connect more apps... Try one of the apps below to open or edit this item. Main menu.