Scribd
Upload
140 views1 page

DBMS Exam Guide for B.Sc Students

This document outlines the questions for a Database Management Systems exam for a B.Sc degree. It includes 5 short answer questions worth 5 marks each from various DBMS topics like the drawbacks of file processing systems, the entity-relationship model, mapping cardinalities and Codd's rules. It also includes 5 long answer questions worth 10 marks each, covering additional topics such as the advantages of DBMS, ER modeling concepts like specialization and generalization, relational algebra vs tuple relational calculus, SQL commands and PL/SQL blocks. Students must answer any 5 short questions and all 5 long questions for a total of 75 marks.

Uploaded by

gdayanandam
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
140 views1 page

DBMS Exam Guide for B.Sc Students

This document outlines the questions for a Database Management Systems exam for a B.Sc degree. It includes 5 short answer questions worth 5 marks each from various DBMS topics like the drawbacks of file processing systems, the entity-relationship model, mapping cardinalities and Codd's rules. It also includes 5 long answer questions worth 10 marks each, covering additional topics such as the advantages of DBMS, ER modeling concepts like specialization and generalization, relational algebra vs tuple relational calculus, SQL commands and PL/SQL blocks. Students must answer any 5 short questions and all 5 long questions for a total of 75 marks.

Uploaded by

gdayanandam
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 1

Govt.

College for Men(A):: Kadapa


B.Sc DEGREE EXAMINATION
Database Management System
( B.A, B.Com & B.Sc)
Time: 3 Hrs Max.marks:75

I. Answer any FIVE questions 5x5=25

1. Explain the drawbacks of File processing systems?

2. Explain the advantages of DBMS?

3. Explain about Entity – Relation model?

4. Explain mapping Cardinalities with Examples?

5. Write and explain CODD’S rules?

6. Relational Alzebra & Tuple relational Calculus: differentiate

7. Write about SQL commands briefly?

8. Explain about triggeres with example?

II. Answer ALL questions 5x10=50

11. Advantages of DBMS?


[Or]
12. Functions of DBA?

13.Write about ER model?


[Or]
14.Explain a) Specialisation b) Generalisation c) Aggregation.

15.Explain a) Tuple relational Calculus b) Domain Relational Calculus


[Or]
16.Explain QBE with examples?

17.Explain any Five SQL commands with example?


[Or]
18.Explain any 5 of a)Relational set operators b) Aggregate functions?

19. Explain the structure of PLSQL block structure with syntax?


[Or]
20.Types of cursors?

You might also like