Kuvempu University 2008 B.Sc Information Technology RDBMS - Question Paper

Third Semester B.Sc. (IT) Examination, November 2008
Directorate of Distance Education Course
RDBMS
Time: three Hours Max. Marks: 100
Notes: 1) ans all ques. from Part - A and every ques.
carries 1 mark.
2) ans any 5 full ques. from Part - B and every
ques. carries 15 marks.
PART - A
ans all questions, every carries 1 mark.
1. Relational algebra is a___________query language.
20
2. The relations involved in union operations should be of the same___________
3. r x s ranging from 2 relations, r & s means___________
4. The assignment operation denoted by___________
5. To describe tuple variables, we use ___________clause.
6. SQL provides___________ operator for performing trend watching.
7. The___________connective tests for set membership.
8. The predicate___________tests for the absence of NULL value.
9. A DBMS ensures data consistency and ___________
10. Normalization is a technique for reducing___________
11. In 2NF, tables are related using___________key.
12. ___________key uniquely identify a row in the table.
13. ___________means permission.
14. PMON___________is a short form used for___________
15. ___________is a short form used for log author.
16. Dnnn is a short fonn used for___________
17. ___________used in a PL/SQL block are called Lestical units.
18. ___________section is the last part of PL/SQL block.
19. The data stored in cursor are called___________
20. ___________retrieves records into cursor.
21. The client calls a local procedure, called the___________
22. The technique to access the remote database by the user is called___________
23. ODBC came as a demand for___________development.
24. XML means___________
25. GDB stands for___________
PART - B
1. a) What is the difference ranging from UNARY & BINARY operations ? provide examples for
the identical. 8
21
b) What is the difference ranging from Cartesian product and natural join operation ?
Write sample queries for both the operations. 7
2. a) provide the salient features of SQL. 5
b) elaborate aggregate functions? discuss with an example every. Write the
different aggregate functions used in SQL. 5
c) discuss various join kinds and join conditions. 5
3. a) discuss the database design process. 5
b) What is normalization ? elaborate 3 basic steps of normalization ? 5
c) discuss 1st and 2nd normal form with an example. 5
4. a) What is a constraint? discuss the various constraints that can be placed on
tables columns. 5
b) What is Rollback Segment? discuss its role. 5
c) Differentiate ranging from Trace files and Alert files. 5
5. a) discuss how PL/SQL overcomes the drawback of SQL. 5
b) discuss the various kinds of exceptions.
c) discuss the attributes/cursor variables available to control the execution of
the cursor. 5
6. a) discuss the steps normally take place in a remote procedure call. 5
b) List and discuss transparency problems. 5
c) discuss the 3 tier database design. 5
7. a) What is XML ? elaborate the building of XML document? discuss. 7
b) What do you mean by search engine ? elaborate the components of search
engine service? discuss. 8
8 a) discuss the mobile computing architecture. 7
b) What do you mean by multimedia database? discuss in detail. 8
* * * * * * *

Earning:   Approval pending.