RDBMS –I, MCA Question Paper

punjabtechnicaluniversity.blogspot.in

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)

RDBMS –I

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)

Q1)

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.