Sunday, September 30, 2012
Roll No. ......................
Total No. of Questions : 13] [Total No. of Pages : 02
Paper ID [A0514]
(Please fill this Paper ID in OMR Sheet)
MCA 304 (Old/S05) (Sem. - 3rd)
Time : 03 Hours Maximum Marks : 75
Instruction to Candidates:
1) Section -A is Compulsory.
2) Attempt any Nine questions from Section - B.
Section - A<
(15 × 2 = 30)
a) What is DBA?
b) What do you mean by DBMS utility? Give any two.
c) What is ISA relationship in E-R model?
d) How distributed database is different from distributed processing?
e) Which data model give the concept of data independence? Explain.
f) What is tuple?
g) What do you mean by cardinality of a relation?
h) Can Foreign key itself be NULL? Justify.
i) What is entity integrity?
j) Give an example of relation which is in 3NF but not in BCNF.
k) Which is fastest way to retrieve data from two different tables - Join or
simple subquery? Explain.
l) Explain compute command of Oracle.
m) Which algorithm is used for concurrency control in Oracle?
n) Give any two sql * plus commands of Oracle.
o) How commit is different from rollback?
Section - B
(9 × 5 = 45)
Q2) Explain the concept of data independency with example.
Q3) Compare network model with relational model.
Q4) Explain the characteristics & structure of distributed database.
Q5) Student study many subjects. Teacher teaches only one subject. Student
obtains grade while studying a subject. Draw an E-R model for the above statements.
Q6) Explain the concept of referential integrity.
Q7) Explain multivalued dependency by giving suitable example.
Q8) What is achieved by normalization? Does normalized table is optimized table in terms of efficiently retrieving the data from database? Comment.
Q9) State & explain 2NF and 3NF.
Q10) Explain group by and order by clause of SQL.
Q11) What are security issues in database? Discuss.
Q12) Explain any one concurrency control algorithm.Q13) Give five important technical features of Oracle.
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) ...