C.U.SHAH UNIVERSITY Winter Examination-2015 Subject Name : Advanced Database Management System Subject Code : 5CS04ADB1
Branch : MCA
Semester : 4
Time :2.30 To 5.30
Date : 20/11/2015
Marks : 70
Instructions: (1) Use of Programmable calculator and any other electronic instrument is prohibited. (2) Instructions written on main answer book are strictly to be obeyed. (3) Draw neat diagrams and figures (if necessary) at right places. (4) Assume suitable data if needed.
SECTION – I Q-1
Attempt the Following questions a. b. c. d. e. f. g.
Q-2 a. b. c. Q-2 a. b. c. Q-3 a. b.
Q-3
a. b.
List out the major components of database. Give the name of any one secondary storage device. What is blocking factor (bfr)? Define: Index. What is the main goal of providing security to data and database? What is Transaction? What do mean by a block anchor in primary index? Attempt all questions Differentiate between fixed length and variable length records with suitable example. Explain Primary Index as a single level ordered index. What is DAC? Discuss the DAC as one of the secure access control technique. OR Attempt all questions Give distinction between spanned and un-spanned file organization with suitable example. Which are the different database system utilities? Discuss in detail about secondary index. Attempt all questions Who is “End-User”? Discuss in details about various types of users exist in database environment. Explain MAC as a security scheme. OR Attempt all questions Explain the process of double buffering. (Buffering of Blocks) Write a detailed note on Public Key Infrastructure (PKI). Page 1 || 2
(07)
(14) 05 05 04 (14) 05 05 04 (14) 07 07 (14) 07 07
SECTION – II Q-4 a. b. c. d. e. f. g. Q-5 a. b. c. Q-5 a. b. c. Q-6 a. b. Q-6 a. b.
Attempt the Following questions Draw state transition diagram for a transaction. Give the other name for transaction log. What is Schedule? What is cascading rollbacks? Define: „Database Backup‟ What is Snapshot? Define: Concurrency. Attempt all questions Discuss in detail about the problems related to concurrency control. Explain the growing and shrinking phase of Two Phase Locking Protocol (2PL). Explain deferred update technique as log based recovery method. OR Attempt all questions Write a short note on properties of a transaction. Discuss in detail with example the concept of view serializability. Discuss shadow paging as recovery scheme. Attempt all questions Differentiate between serial and non-serial schedule. Discuss deadlock Prevention, Detection and Avoidance schemes. OR Attempt all Questions What is transaction? Give various state of the transaction. Write a detailed note on types of database failure.
Give distinction between spanned and un-spanned file organization with suitable. example. 05. b. Which are the different database system utilities? 05. c.
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 by giving. suitable examples. 2. Discuss about clustering index. 3. Who is DBA? Which are ...
(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.