PSBTE PAPER

PSBTEPAPER.COM

Question Papers & Solutions

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

Download Previous Year Diploma Solved Question Paper of Relational Database Management System RDBMS Dec 2015 CSE/IT Diploma Paper

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

                                      SECTION-A

NOTE: Attempt all questions 1.5×10=15
1). The Purpose of DBMS is to provide a mechanism for Organizing, Structuring and Storing data.(T/F)
2). The database Administrator is, in effect, the coordinator between the Database and Users.(T/F)
3). Data Security threats includes _______________
4). Write Full form of:
(i) DBA (II)DML
5). A relational database developers refers to a record as _.
6) language is to Grant and Revoke authorization for database.
7). A _______ Key is a set of one or more attributes that can uniquely tuples with in the relation.
8). The ________ Clause is used along with the statement to specify the conditions based on which rows will be extracted from the table.
9). The Symbols < and > are considered ___________ Operators.
10). SELECT Command creates new Table.(T/F)

                                      SECTION-B

NOTE: Attempt any FIVE questions. 6×5=30
Q1: What are DBMS Interfaces? Explain in brief?
Q2: Explain the Role of DBA and different database End Users? Discuss the main activities of each?
Q3: What is Data Independence? Explain two levels of Data Independence in Brief?
Q4: What do you mean by Data Models? Explain types of Data Models?
Q5: Explain with example:- (i)Primary Key. (ii)Candidate Key. (iii)Super Key. (iv)Secondary Key.
Q6: What is Normalization? Explain types of Normal Forms?
Q7: Explain ACID properties? Which are two states of Transaction?
Q8: What is the difference between SQL and PL/SQL?

                                     SECTION-C

NOTE: Attempt any THREE questions. 10×3=30
Q1: What do you mean by relationship? What is the different Degrees of a relationship? Explain with examples?
Q2: What are various Locking Methods used in Data Security? Also, briefly describe GRANT and REVOKE statement?
Q3: What do you mean by Data Models? What are various Data Models? Explain?
Q4: Explain ER Diagram and their Components? What are its uses? Give suitable example?
Q5: Explain the types of various Integrity Constraints

Relational Database Management System RDBMS Dec 2018 CSE/IT Diploma Solved PSBTE Paper

                                      SECTION-A

Q1. Fill in the blanks.                                                      15×1=15

a. DDL stands for Data Definition Language .
b. DBMS stands for Database Management Systems.
c. PL/SQL is Procedural language. 
d. Database is the collection of interrelated data. 
e. The Alter command is used to modify the information stored in a table. 
f.A hierarchical database  Model consists of a collection of records connected to one another through links. 
g. The overall design of the database is called Database Schema .
h. DBA stands for Database Administrator .
i. A  Domain is the set of allowable values for one or more attributes. 
j. BCNF stands for Boyce–Codd Normal Form .
k. A data dictionary is a file that contains Meta data i.e. data about data.
l. The number of tuples in a relation is known as Degree .
m. Oracle is an object oriented database. (T/F) TRUE
n. The Declare section ends a PL/SQL block. (T/F) TRUE
o. All fields in a record must be of the same type. (T/F) TRUE

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 Dec 2015 CSE/IT Diploma Paper

The Purpose of DBMS is to provide a mechanism for Organizing, Structuring and Storing data.(T/F)
The database Administrator is, in effect, the coordinator between the Database and Users.(T/F)
Data Security threats includes _______________

Data Security threats includes _______________

Write Full form of: (i) DBA (II)DML

(i) DBA

(II)DML

A relational database developers refers to a record as _.

A relational database developers refers to a record as _.

language is to Grant and Revoke authorization for database.

language is to Grant and Revoke authorization for database.

 A _______ Key is a set of one or more attributes that can uniquely tuples with in the relation.

 A _______ Key is a set of one or more attributes that can uniquely tuples with in the relation.

The ________ Clause is used along with the statement to specify the conditions based on which rows will be extracted from the table.

The ________ Clause is used along with the statement to specify the conditions based on which rows will be extracted from the table.

The Symbols < and > are considered ___________ Operators.

The Symbols < and > are considered ___________ Operators.

SELECT Command creates new Table.(T/F)

RDBMS Dec 2015 CSE/IT Diploma Solved Paper Click Here

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

What is DBMS? Explain main advantages of DBMS in brief.

DBMS Interfaces.

Explain the Role of DBA and different database End Users? Discuss the main activities of each?

Role of DBA and different database End Users.

What is Data Independence? Explain two levels of Data Independence in Brief?

Data Independence.

Explain two levels of Data Independence.

What do you mean by Data Models? Explain types of Data Models?

Data Models and types of Data Models.

Explain with example:- (i)Primary Key. (ii)Candidate Key. (iii)Super Key. (iv)Secondary Key.

(i)Primary Key.

(ii)Candidate Key.

(iii)Super Key.

(iv)Secondary Key.

What is Normalization? Explain types of Normal Forms?

Normalization and types of Normal Forms.

Explain ACID properties? Which are two states of Transaction?

ACID properties

What is the difference between SQL and PL/SQL?

Difference between SQL and PL/SQL.

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

RDBMS 3rd Semester CSE Dec 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 DEC 2015 Diploma Solved Paper

What do you mean by relationship? What is the different Degrees of a relationship? Explain with examples?

Relationship and different Degrees of a relationship.

What are various Locking Methods used in Data Security? Also, briefly describe GRANT and REVOKE statement?

Locking Methods used in Data Security

Describe GRANT and REVOKE statement.

What do you mean by Data Models? What are various Data Models? Explain?

Data Models and various Data Models.

Explain ER Diagram and their Components? What are its uses? Give suitable example?

ER Diagram and their Components and its uses.

Explain the types of various Integrity Constraints

Types of various Integrity Constraints.

RDBMS 3RD Sem CSE DEC 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
JK SMART CLASSES
ER.JASWINDER KUMAR
\"JK
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
ENGINEERING CLASSES
ER.JASWINDER KUMAR
\"JK
er.jaswinder kumar
Senior Lecturer

Leave a Comment

Your email address will not be published.