Relational Database Management System RDBMS May 2015 CSE/IT Diploma Paper

Download Previous Year Diploma Solved Question Paper of Relational Database Management System RDBMS May 2015 CSE/IT Diploma Paper

Relational Database Management System RDBMS May 2015 CSE/IT Diploma Paper

                                      SECTION-A

Expand the following                 7.5

(a) DDL

(b) SOL

(c) DBMS

(d) DBA

(e) MVD

Fill in the blanks 7.5

(a) A Tuple is equivalent to a ________________ 
(b) The trigger can be called once. (True / False ) 
(c) BCNF is used in data security. (True / False ) 
(d) The logical structure of database is sometimes called a _________________. 
(e) ____________ Command is used to take back the privileges given to a user.

                                      SECTION-B

Q2. Attempt any five questions.                                                                    5×6=30

(a) Difference between SOL and PL/SOL?
(b) Explain the various types of DBMS users?
(c) Explain the various database languages?
(d) What are keys? Explain different types of keys with examples.
(e) Explain the relational constraints?
(f) Explain PL/SOL block structure?
(g) Explain the DBMS architecture?

                                     SECTION-C

Note: Attempt any two questions 15×2
Q3 Explain the various advantages and disadvantages of DBMS ?
Q4 What is normalization? Explain 1NF, 2NF, 3NF with examples.
Q5 What are data models? Explain different types of data models.

Relational Database Management System RDBMS May 2015 CSE/IT Diploma Solved Paper

                                      SECTION-A

Expand the following                 7.5

(a) DDL-

DDL-Data Description Language

(b) SOL

 SOL-Standard Operation Procedure

(c) DBMS

DBMS-Database Management Systems

(d) DBA

DBA-Database Administrator

(e) MVD

Fill in the blanks 7.5

(a) A Tuple is equivalent to a Row
(b) The trigger can be called once. (True / False )

FALSE
(c) BCNF is used in data security. (True / False )

TRUE
(d) The logical structure of database is sometimes called a Entity-Relationship (ER) models

(e) REVOKE Command is used to take back the privileges given to a user.

DDLData Description Language

 

SOL-Standard Operation Procedure

 

DBMS-Database Management Systems

 

DBA-Database Administrator

 

A Tuple is equivalent to a Row

 The logical structure of database is sometimes called a Entity-Relationship (ER) models

 

REVOKE Command is used to take back the privileges given to a us.

RDBMS May 2015 CSE/IT Diploma Solved Paper Click Here

Comparison between SOL and PL/SOL.

Various types of DBMS users.

Various database languages.

Relational constraints.

PL/SOL block structure.

RDBMS 3rd Semester CSE MAY 2015 Diploma Solved Paper Click Here

RDBMS 3rd Semester CSE MAY 2015 Diploma Solved Paper

Various advantages and disadvantages of DBMS.

Data models and different types of data models.

Normalization and Explain 2NF and 3NF with example.

DBMS interfaces

RDBMS 3RD Sem CSE May 2015 Diploma Solved Paper Contact Us
MY YOUTUBE CHANNEL
JK Smart Classes Upload Lecture for Degree classes like B.TECH,M.TECH in any stream like ECE,EE,ME and Civil Engineering
JK SMART CLASSES
JK SMART CLASSES
ER.JASWINDER KUMAR
JK SMART CLASSES
JK SMART LECTURE
ER.JASWINDER KUMAR
Engineering Classes Upload Lecture for Polytechnic Diploma classes in any stream like ECE,EE,ME and Civil Engineering
JK SMART CLASSES
ENGINEERING CLASSES
ER.JASWINDER KUMAR
JK SMART CLASSES
er.jaswinder kumar
Senior Lecturer

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top