Home BCA/BTech JEE RAS RSCIT Blogs
Switch Language हिन्दी
BCA / B.Tech 3 min read

BCA | RDBMS(Relational Database Management System) 2018 Paper | MDSU Exam Paper

BCA | RDBMS(Relational Database Management System) 2018 Paper | MDSU Exam Paper


Part-A

Q.1 What is query?
Q.2 What is Primary Key?
Q.3 Explain the term SQL?
Q.4 Explain the term DML?
Q.5 What is trigger?
Q.6 What is Recovery?
Q.7 What is Referential Integrity?
Q.8 What is Association Rules?
Q.9 List out all the constraints in SQL?
Q.10 What is Serializability?

Part-B

Q.11 What is Operator? Explain types of Operations in SQL.
Q.12 Explain Recursive function in PL/SQL.
Q.13 Explain needs of Recovery.
Q.14 Explain Data Communication Concept.
Q.15 Write a Program in PL/SQL, to Check given no. is prime or not.

Part-C

Q.16 What is DDBMS? Explain architecture of DDBMS.

OR

Write Short notes on :

(a) Concurrency Control
(b) Data Placement

Q.17 What is Query Optimization? Explain all steps of query processing.

OR

What is deadlock situation? Explain deadlock avoidance and deadlock prevention.

Q.18 What is Database triggers? Explain all types with suitable example.

OR

What is DDL? How many types of command in DDL with suitable example.

In this Chapter

BCA | RDBMS(Relational Database Management System) 2018 Paper | MDSU Exam Paper
What is (RDBMS) Relational Database Management System
Coding Rules for RDBMS
Components of RDBMS
Types of RDBMS
Object-Oriented Model
Different Types of Attributes
Generalization & Inheritance
Aggregation & Encapsulation
Distributed Data Design
RDBMS Important Questions and Answers in English
Architecture of Distributed Processing Systems
RDBMS Model Paper with answers (MDSU)
Data Communication
Data Placement
DDBMS
Other Components of Data Placement
Concurrency Control
Recovery & Transaction Management
The Need for Recovery
BCA | RDBMS(Relational Database Management System) 2025 Paper | MDSU Exam Paper
Serializability & Two-Phase Locking (2PL)
Query Optimization and Processing
Join & Its Types
Object and Set Operations
Temporal Database
Multimedia Databases & Data Mining
XML Tree Structure
Characteristics of RDBMS
RDBMS Architecture
Association Rules
Classification and Application of RDBMS
Data Warehouse
Difference Between Data Warehouse & View
Security Specifications in SQL
Public Key Infrastructure (PKI)
Cryptography & Its Types
BCA | RDBMS 2023 Paper | MDSU Exam Paper