Scribd
Upload
11 views1 page

RDBMS 1

This document outlines the structure of the Database Management System examination for D.K.M. College for Women, including sections for short answer questions, detailed explanations, and examples. It covers various topics such as entity definitions, keys in DBMS, normalization, SQL commands, and relational models. The exam consists of multiple sections with varying question formats and marks distribution.

Uploaded by

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

RDBMS 1

This document outlines the structure of the Database Management System examination for D.K.M. College for Women, including sections for short answer questions, detailed explanations, and examples. It covers various topics such as entity definitions, keys in DBMS, normalization, SQL commands, and relational models. The exam consists of multiple sections with varying question formats and marks distribution.

Uploaded by

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

Reg. No.

D.K.M. COLLEGE FOR WOMEN (AUTONOMOUS), VELLORE-1


SEMESTER EXAMINATIONS
APRIL – 2019 15CCS4A/15CCA4B
DATABASE MANAGEMENT SYSTEM
Time : 3 Hrs Max. Marks : 75

SECTION-A (10 x 2 = 20)


Answer ALL the questions.
1. Define Entity.
2. Define Keys. List out various keys in DBMS.
3. Write any one Example of Relation.
4. Define Formal Query Language.
5. Define Null values.
6. Define Embedded SQL.
7. List out pitfalls of Relational Database Design.
8. What is the condition of First Normal Form?
9. What are the Block exist in Exception Handling?
10. Write any two example Command of DCL statements.

SECTION-B (5 x 5 = 25)
Answer any FIVE of the following questions.
11. Write short notes on Purpose of Database.
12. Discuss about Mapping Constraints.
13. Explain various Aggregate Functions in SQL.
14. How do you create View? Write with an example.
15. Write short notes on Joined Relations.
16. Discuss about the concept of Normalization Using Functional Dependencies.
17. Write short notes on Data types in PL/SQL.
18. What is the concept of DML? Write with an example Query.

SECTION-C (3 x 10 = 30)
Answer ALL the questions.
19. (a) Write in detail about ER Diagram with an Example.
(Or)
(b) Explain about the Cursor Management with example.
20. (a) Explain about the concept of Relational Model with an example.
(Or)
(b) What is the concept of Relational Algebra? Explain with an example.
21. (a) Write briefly about BCNF Normal Form.
(Or)
(b) What are the various set Operations available in SQL? Explain with an example.

*******

You might also like