81

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.

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

Get Started

Section aRelational Database Management System RDBMS MAY 2015 CSE/IT Diploma Paper

(a) DDL

DDL–Data Description Language

 

SOL stands for _________________

SOL-Standard Operation Procedure

 

DBMS Means

DBMS-Database Management Systems

 

DBA Expand For ________________

DBA-Database Administrator

 

MVD Stands for ________________

 MVD

 

A Tuple is equivalent to a __________

A Tuple is equivalent to a Row

The trigger can be called once. (True / False )

FALSE

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

TRUE

 The logical structure of database is sometimes called a __________________

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

 

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

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

RDBMS May 2015 CSE/IT Diploma Solved Paper Click Here

Section B :Relational Database Management System RDBMS may 2015 CSE/IT Diploma Paper

Difference between SOL and PL/SOL?

Comparison between SOL and PL/SOL.

Explain the various types of DBMS users?

Various types of DBMS users.

Explain the various database languages?

Various database languages.

What are keys? Explain different types of keys with examples.

Keys and types of keys with examples.

Explain the relational constraints?

Relational constraints.

Explain PL/SOL block structure?

PL/SOL block structure.

Explain the DBMS architecture?

DBMS architecture.

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

RDBMS 3rd Semester CSE MAY 2015 Diploma Solved Paper

Get Started https://www.youtube.com/watch?v=UHX6f8TIvX8https://www.youtube.com/watch?v=M_RR6LVICp0https://www.youtube.com/watch?v=mV41CMWonN4https://www.youtube.com/watch?v=s0LVPE0Q3LE&list=PLA9Q9SDZ781WXNAWit379A4CRLMvjGiUw&index=14&t=0s

Section c :-RDBMS 3RD Sem CSE may 2015 Diploma Solved Paper

Explain the various advantages and disadvantages of DBMS ?

Various advantages and disadvantages of DBMS.

What is normalization? Explain 1NF, 2NF, 3NF with examples.

Normalization

Explain 1NF, 2NF, 3NF 

What are data models? Explain different types of data models.

Data models and different types of data models.

What is Normalization? Explain 2NF and 3NF with example.

Normalization and Explain 2NF and 3NF with example.

Write a short note on the following.i. Integrity Constraints

Integrity Constraints

ii. DBMS interfaces

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