Download Previous Year Diploma Solved Question Paper of Relational Database Management System RDBMS May 2016 CSE/IT Diploma Paper
Relational Database Management System RDBMS May 2016 CSE/IT Diploma Paper
SECTION-A
Q1. Fill in the blanks. 10×1.5=15
a. DDL stands for ____________ and DML stands for ____________ .
b. Define Information.
c. What do you mean by a weak entity set?
d. Name the different Joins.
e. Write the syntax of create command.
f. Expand DBMS and SQL?
g. Name the three levels in architecture of DBMS.
h. Define Schema.
i. Number of columns and rows in a relation is called ______ and ______ respectively.
j. _____________ and __________ commands are DCL commands.
SECTION-B
Q2. Attempt any five questions. 5×6=30
a. What do you mean by data independence? Explain its types.
b. Discuss the various types of users.
c. Briefly describe the operators used in SQL.
d. Explain the various types of attributes in ER model.
e. What is the purpose of Where, Order by and Group by clause.
f. Discuss the various DBMS interfaces.
g. Define multi valued dependency and join dependency in normalization.
h. What are various data types in PL/SQL?
SECTION-C
Q3. Attempt any three questions. 3×10=30
a. What are various advantages and disadvantages of DBMS? Explain.
b. What is normalization? Explain 1NF, 2NF and 3NF with examples.
c. What do you mean by data models? Explain various record based data models with examples.
d. Explain the various locking methods used for Data Security.
e. Explain PL/SQL Block structure with example.
Relational Database Management System RDBMS May 2016 CSE/IT Solved PSBTE Diploma Paper
SECTION-A
Q1. Fill in the blanks. 10×1.5=15
a. DDL stands for Data Definition Language and DML stands for Data Manipulation Language .
b. Define Information.
c. What do you mean by a weak entity set?
d. Name the different Joins.
e. Write the syntax of create command.
f. Expand DBMS and SQL?
Sol. DBMS -Database Management System.
SQL-Structured Query Language
g. Name the three levels in architecture of DBMS.
Sol.Threee level of DBMS-Physical level, Conceptual level and External level
h. Define Schema.
i. Number of columns and rows in a relation is called Degree and Tuple respectively.
j.GRANT and REVOKE commands are DCL commands.
Relational Database Management System RDBMS Dec 2018 CSE/IT Diploma Paper
Get Started
https://www.youtube.com/watch?v=y_wJffQkeWo&list=PLA9Q9SDZ781WXNAWit379A4CRLMvjGiUw&index=6&t=0shttps://www.youtube.com/watch?v=mV41CMWonN4&list=PLA9Q9SDZ781WXNAWit379A4CRLMvjGiUw&index=7&t=0shttps://www.youtube.com/watch?v=M_RR6LVICp0&list=PLA9Q9SDZ781WXNAWit379A4CRLMvjGiUw&index=20&t=0shttps://www.youtube.com/watch?v=3BNQLUnbNpYhttps://www.youtube.com/watch?v=ZDkyNOzoG8A&list=PLA9Q9SDZ781WXNAWit379A4CRLMvjGiUw&index=8&t=0shttps://www.youtube.com/watch?v=s0LVPE0Q3LE&list=PLA9Q9SDZ781WXNAWit379A4CRLMvjGiUw&index=14&t=0s
Section aRelational Database Management System RDBMS May 2016 CSE/IT Diploma Paper
DDL stands for Data Definition Language
DML stands for _______________
DML stands for Data Manipulation Language .
Information
What do you mean by a weak entity set?
Weak entity set.
Different joins
Write the syntax of create command.
Syntax of create command.
Sol. DBMS -Database Management System.
SQL-Structured Query Language
Name the three levels in architecture of DBMS.
Sol.Threee level of DBMS-Physical level, Conceptual level and External level .
Schema.
Number of columns and rows in a relation is called ___________ and __________ respectively.
Number of columns and rows in a relation is called Degree and Tuple respectively.
___________ and ____________ commands are DCL commands.
GRANT and REVOKE commands are DCL commands.
The number of tuples in a relation is known as ______________
The number of tuples in a relation is known as Degree .
Oracle is an object oriented database. (T/F)
TRUE
The Declare section ends a PL/SQL block. (T/F)
TRUE
All fields in a record must be of the same type. (T/F)
TRUE
RDBMS May 2016 CSE/IT Diploma Solved Paper Click Here
Section B :Relational Database Management System RDBMS may 2016 CSE/IT Diploma Paper
What do you mean by data independence? Explain its types.
Independence and its types.
Discuss the various types of users.
Various Types of users.
Briefly describe the operators used in SQL.
Describe the operators used in SQL.
Explain the various types of attributes in ER model.
Types of attributes in ER model.
What is the purpose of Where, Order by and Group by clause.
Purpose of Where, Order by and Group by clause.
Discuss the various DBMS interfaces.
DBMS interfaces.
Define multi valued dependency and join dependency in normalization.
Multi valued dependency and join dependency in normalization.
What are various data types in PL/SQL?
Various data types in PL/SQL.
RDBMS 3rd Semester CSE May 2016 Diploma Solved Paper Click Here
RDBMS 3rd Semester CSE may 2016 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 2016 Diploma Solved Paper
What are various advantages and disadvantages of DBMS? Explain.
Advantages and disadvantages of DBMS.
What is normalization? Explain 1NF, 2NF and 3NF with examples.
Normalization
Explain 1NF, 2NF and 3NF
What do you mean by data models? Explain various record based data models with examples.
Models and various record based data models.
Explain the various locking methods used for Data Security.
Locking methods used for Data Security.
Explain PL/SQL Block structure with example.
PL/SQL Block structure with example.
RDBMS 3RD Sem CSE MAY 2016 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](\"https://www.psbtepaper.com/wp-content/uploads/2020/03/JK-SMART-CLASSES-removebg-preview-1.jpg\")
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