Wednesday, October 5, 2016
Roll no ....................
Total No. of Questions: 07]
Paper ID [MB682]
MBA(Sem.-3rd & 4th )
TIME: 03 Hours
Instruction to Candidates :
1) Attempt any one question form each sections A,B,C,D.
2) Section –E is compulsory.
Section – A
a. Describe the three schema architecture. Why do we need mapping between schema levels? How do different schema definition languages support this architecture?
b. What are the different types of database end users? Discuss the main activities of each.
a. Discuss the characteristics of a data warehouse. Divide them into functionality of a warehouse and advantageous users derive from it.
b. What is meant by data allocation in distributed database design? What typical units of data are distributed over sites?
a. What is an entity type? What is an entity set? Explain the difference among an entity, an entity type and an entity set.
b. Explain different constraints in relational model.
a. Compare Hierarchical and Network model.
b. Explain object oriented databases.
5. What is relational calculus? Explain with examples tuple and domain relational calculus.
a. Discuss insertion, deletion and modification anomalies. Why are they considered bad? Illustrate with examples.
b. What is meant by the completeness and soundness of Armstrong’s inference rules?
Section – D
7. What is meant by the concurrent execution of database transactions in a multi-user system? Discuss why concurrency control is needed and give informal examples.
a. Describe the four levels of isolation in SQL.
b. What is security threat? Explain different security threats.
a. What is database?
b. What is primary key?
c. What is data mining?
d. What are homogeneous distributed databases?
e. What are the disadvantageous of network model?
f. Define the different type of attributes in E-R model.
g. What is difference between the random access and sequential access?
h. Define the term fully functional dependency.
i. What is database integrity?
j. What is system lock?
punjabtechnicaluniversity.blogspot.in Roll No......................... ... Total No. of Questions : 07] ...
Roll No……….. Total No. of Questions: 07 B.Com. (Sem.-1 st ) FINANCIAL ACCOUNTING Subject Code: BCOP-101 Paper ID: [B1101] ...
punjabtechnicaluniversity.blogspot.in Click Here for Syllabus of B-Tech 1st Year . http://ptu.ac.in/userfiles/file/engg_syllab/1st_and_...
Business Organisation and Management, Question Paper of B.Com 1st Semester,Download Previous Years Question Paper 2Roll No…….. Total No. of Questions: 07 B.Com (Sem.-1 st ) BUSINESS ORGANIATION AND MANAGEMENT Subject Code: BCOP-102 (2011 &a...
Roll No……. Total No. of Questions:07 B.COM (Sem.-1 st ) BUSINESS MATHEMATICS SUBJECT CODE: BCOP-104 (2011 Batch) PAPER ID: ...
punjabtechnicaluniversity.blogspot.in Roll No. ...................... Total No. of Questions : 13] ...
punjabtechnicaluniversity.blogspot.in Master Of Technology (M-Tech) Syllabus SYLLABUS FOR MASTER OF TECHNOLOGY (M-Tech) Br...
punjabtechnicaluniversity.blogspot.in Click Downlink for Dowload of Scheme and Syllabus of B.Com. Professional Batch 2011onwards ht...
B.Sc. IT (402) (S05) / 102 (New) (Sem. - 4th) BASIC MATHEMATICS – I, Punjab Technical University, PTU, Question paperpunjabtechnicaluniversity.blogspot.in Roll No. ................. Total No. of Questions : 13] ...
punjabtechnicaluniversity.blogspot.in Roll No . ............ Total No. of Questions : 07) ...