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 .
Information
Weak entity set.
Different joins
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 .
Schema.
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
Independence and its types.
Various Types of users.
Describe the operators used in SQL.
Types of attributes in ER model.
Purpose of Where, Order by and Group by clause.
DBMS interfaces.
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
Advantages and disadvantages of DBMS.
Normalization
Explain 1NF, 2NF and 3NFÂ
Models and various record based data models.
Locking methods used for Data Security.
PL/SQL Block structure with example.