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.
DDL–Data 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.
Keys and types of keys with examples.
Relational constraints.
PL/SOL block structure.
DBMS architecture.
RDBMS 3rd Semester CSE MAY 2015 Diploma Solved Paper Click Here
Various advantages and disadvantages of DBMS.
Normalization
Explain 1NF, 2NF, 3NFÂ
Data models and different types of data models.
Normalization and Explain 2NF and 3NF with example.
Integrity Constraints
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
ER.JASWINDER KUMAR
JK SMART LECTURE
ER.JASWINDER KUMAR
Engineering Classes Upload Lecture for Polytechnic Diploma classes in any stream like ECE,EE,ME and Civil Engineering
ENGINEERING CLASSES
ER.JASWINDER KUMAR
er.jaswinder kumar
Senior Lecturer