Advance Data Base Management Systems — Winter 2017

Do as Directed 1. Define Dense index 2. What do you mean by Dirty bit? 3. Differentiate interleaved concurrency v/s parallel concurrency. 4. List out various database utilities that help the DBA manage database system. 5. What is the use of BLOB? 6. DES stand for ------------ 7. The description of database is called the -------------------

1. Explain Three- schema architecture with diagram 2. Write a note on Double Buffering

List out and Explain advantages of DBMS approach

What is tuning? What are the goals of it? Discuss types of problems encountered during it. Also discuss the different types of statistics required for it.

What do you mean by key field ?Explain in brief the concepts of primary index, clustering index and secondary index

Write a note on PKI with its six ingredients and Digital signature

Why deferred update technique is called NO UNDO/REDO method? Discuss deferred update technique in a single user environment with example.

Write a note on WAL, Steal/No-steal approach and Force/no-Force approach

List out four main control measures that are used to provide security of data. Explain Access control and action performed by DBA for security in brief.

Explain Fixed length records, variable length records, spanned records and un- spanned records with example.

Give functions of Temporal database. List out various temporal data types. Explain the concepts of valid time and transaction time dimension with example.

Explain in brief distributed concurrency control based on distinguished copy of a data item in DDBMS.

List the object relational features included in SQL-99.Give an example of each

What is GIS? List out and explain various characteristics of data in GIS.

Explain bulk insert using SQL* loader.

Write a note on Mobile computing architecture.

Explain oracle Net configuration in detail.