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

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.

DDL stands for Data Definition Language 

DML stands for Data Manipulation Language .

Syntax of create command.

Sol. DBMS -Database Management System. 

 SQL-Structured Query Language

 

Sol.Threee level of DBMS-Physical level, Conceptual level and External level .

Number of columns and rows in a relation is called Degree  and Tuple respectively.

GRANT and REVOKE commands are DCL commands.

The number of tuples in a relation is known as Degree .

RDBMS May 2016 CSE/IT Diploma Solved Paper Click Here

Various Types of users.

Describe the operators used in SQL.

Purpose of Where, Order by and Group by clause.

Multi valued dependency and join dependency in normalization.

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

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