1
Seat No.: Enrolment
GUJARAT TECHNOLOGICAL UNIVERSITY
MCA- SEMESTER EXAMINATION -SUMMER-2019
Subject Code: 2650004 Date: 08-05-2019
Subject Name: Advanced Data Base Management Systems
Time:10.30 am to 1.00 pm Total Marks: 70
Instructions:
1. Attempt all questions.
2. Make Suitable assumptions wherever necessary.
3. Figures to the right indicate full marks.
Q.1

Do as Directed
State any one advantage of DBMS.
ii) List various ways to place records on disks.
iii) List anyone decision made during physical database design for indexing.
iv) What is write-ahead Logging?
Define Terms: Database State, De-normalization, Dirty Bit
01
01
01
01
03

Say TRUE or FALSE with justification.
Logical data independence is harder to achieve than physical data independence.
ii) De-normalization is good for improving database performance.
iii) Distribution transparency of distributed database refers to the logical placement of data.
iv) Discard file of SQL*Loader contains records that are rejected.
Delete and Truncate are DDL statements.
vi) Double buffering improve block access time.
vii) We have at most one primary, clustering or secondary index on a file.
07
Q.2

Draw three schema architecture of database system.
ii) Differentiate between Logical and Physical Data Independence.
03
04

Discuss how insert, update and delete operations should be implemented in transaction time databases.
07
OR

How time is represented in Temporal databases. Compare different time dimensions.
07
Q.3

List goals for database Tuning. Discuss the types of changes to SQL queries that may be worth considering for improving the performance.
07
2

What is Role Based access control? How it is superior to Discretionary Access Control and Mandatory Access Control
07
OR
Q.3

Explain in brief Public Key Encryption and Digital Signatures.
07

Compare Primary index with Secondary index.
07
Q.4

What is difference between Distributed Database and Normal Database? Discuss advantages and disadvantages of Distributed databases.
07

List various data management issues in Mobile databases.
ii) Differentiate between Steal/No-steal and Force/No-Force concepts.
03
04
OR
Q.4

Explain Horizontal and Vertical data fragmentation using suitable example.
07

How proactive, retroactive and Simultaneous update differs?
ii) List various types of multimedia data available in current systems.
03
04
Q.5

Explain the process of recovery in Distributed Database.
07

What is the difference between Delete and Truncate ii) insert and SQL*Loader.
07
OR
Q.5

List components of Oracle*Net. Explain Concept of Service Name and Listener.
07

Discuss the similarity and dissimilarity of deferred update and immediate update recovery techniques.
07