Janardan Rai Nagar Rajasthan Vidyapeeth 2005 M.Tech Computer Science MSDB 03 Database -Design Development and Deployment - Question Paper

MASTER OF TECHNOLOGY

(SEMESTER - IV) (COMPUTER)

(SPL-1-OBJECT ORIENTED SOFTWARE DEVELOPMENT & DATABASE SYSTEM)


MSDB 03 – DATABASE : DESIGN DEVELOPMENT AND DEPLOYMENT

GENERAL INSTRUCTIONS:
1. Question paper is divided into 3 groups
2. Each group is of 25 marks every
3. Figure to the right in bracket shows mark
4. Assume suitable data if necessary

GROUP A: ans any 3 ques.. ques. No. one is compulsory.
Q.1. What are the main rules for normalization? (05)
Q.2. What is a database management system? elaborate the components of Database management system? (10)
Q.3. Explain the subsequent terms (10)
a)Candidate key b)Composite Primary key c)Foreign key d)Secondary key
Q.4. Explain all the components of the dynamic HTML environment (10)
Q.5 What is a macro? discuss how to create macros with in the macro group. provide example of java code for every case. (10)

GROUP B: ans any 3 ques.. ques. No. six is compulsory.
Q.6 What is the purpose of having separate categories of index authorization and resource authorization and also write 2 advantages of encrypting data stored in the database? (05)
Q.7. Distinguish between (10)
(i)Embedded and linked objects (ii)Data Input and Output formatting
Q.8. What is a Transaction? discuss the defective–product transaction.(10)
Q.9. What is a report? explain the steps involved in creating a report using templates and wizards. (10)
Q.10. Explain the subsequent terms: (10)
a) Referential Integrity b)Metadata c) Data warehouse d) Dependency




GROUP C: All ques. are Compulsory.
Q.11 Fill in the blanks (each ques. carries two marks)
(i) Serializability of a schedules generated by concurrently executing transactions can be ensure through 1 of a variety of mechanism called________________ schemes.
(ii) A row in a relational database table is called ________.
(iii) A ___________ is an instruction that triggers 1 or more actions.
(iv) Two approaches to the designs of conceptual schema are_________ and __________.
(v) The key idea behind the shadow –paging technique is to maintain 2 page tables during the life of a transaction : the _______________ and the _____________.
Q.12 Multiple option ques.. (Each ques. carries two marks)
(i) A___________ set as a named collection of related data.
(a)entity (b)attribute
(c)information (d)none of the above
(ii) The __________ transaction structure is quite similar to that of the invoicing transaction, and the macros are edited copies of the invoice macros.
(a)Back-Order (b)Defective-Product
(c)Selective-Product (d)None of the above
(iii) ____________ is used for Query insertion, deletion & updating of data/information stored in the database.
(a)DDL (b)DML
(c)DCL (d)None of the above
(iv) An entity set that does have a primary key is called a ________ entity set.
(a)Weak (b)Strong
(c)Medium (d)None of the above
(v) __________ Join is a join operation that connects relations when values
from specified columns have specified relationships.
(a)Theta (b)Outer
(c)Equi (d)None of the above




Q.13 True or false (each ques. carries one mark).
(i) A rollback transaction that has performed updates transforms the database into a new consistent state, which must persist even if there is a system failure
(ii) physical telephone directories that satisfy lookups in the forward direction are called white page and in the reverse direction is called yellow pages.
(iii) The least implement able normal form is tagged 2NF,for 2nd normal form.
(iv) The purpose of degree to consistency is to avoid cascading, abort without necessarily insuring serializablity .
(v) A Microsoft Access database administrator retains full permissions on a secure database Used by a workgroup.

Earning:   Approval pending.