Previous year question paper for RDBMS (BSC-IT 5th)


Previous year question paper with solutions for Rbdms-2 from 2014 to 2018

Our website provides solved previous year question paper for Rbdms-2 from 2014 to 2018. Doing preparation from the previous year question paper helps you to get good marks in exams. From our RDBMS question paper bank, students can download solved previous year question paper. The solutions to these previous year question paper are very easy to understand.

An Overview of DBMS and DB Systems Architecture : Introduction to Database Management

systems; Data Models; Database System Architecture; Relational Database Management

systems; Candidate Key and Primary Key in a Relation; Foreign Keys; Relational Operators; Set

Operations on Relations; Attribute domains and their Implementation.

Interactive SQL : SQL commands ; Data Definition Language Commands; Data Manipulation

Language Commands; The Data types a cell can hold; insertion of data into the tables; Viewing of

data into the tables; Deletion operations; updating the contents of the table; modifying the

structure of the table; renaming table; destroying tables; Data Constraints; Type of Data

Constraint; Column Level Constraint; Table Level Constraint; Null value Concepts; The UNIQUE

Constraint; The PRIMARY constraint; The FOREIGN key constraint; The CHECK Constraint;

Viewing the User Constraints;

Viewing The Data : Computations on Table Data; Arithmetic Operators; Logical Operators;

Comparison Operators; Range Searching; Pattern Searching; ORACLE FUNCTIONS; Number

Functions; Group Functions; Scalar Functions; Data Conversion Functions; Manipulating Dates

in SQL ; Character Functions;

Sub queries and Joins : Joins; Equip Joins; Non Equip Joins; Self Joins; Outer Joins; Sub

Queries; Correlated Queries; Using Set Operators:- Union , Intersect; Minus ;

Views and Indexes : Definition and Advantages Views; Creating and Altering Views; Using

Views; Indexed Views; Partitioned views; Definition and Advantages of Indexes; Composite Index

and Unique Indexes; Accessing Data With and without Indexes; Creating Indexes and Statistics.

Introduction to PL/SQL : Advantage of PL/SQL; The Generic PL/SQL Block; The Declaration

Section; The Begin Section; The End Section; The Character set; Literals; PL/SQL Data types;

Variables; Constants; Logical Comparison; Conditional Control in PL/SQL; Iterative Control;

Advanced PL/SQL : Types of Cursors; Implicit Cursor; Explicit Cursor; Explicit Cursor attributes;

Cursor For Loop; Parameterized Cursor; Error Handling in PL/sql ;Internal Exceptions; User

Defined Exceptions

Database Objects : Sequences, Creating Sequences; Referencing Sequences; altering a

Sequence; Dropping a Sequence, Stored Procedures and Functions:- Advantages of using a

Procedure or Function; Procedure Versus Functions; Creating stored Procedures and Functions;

Parameters to Procedures and Functions; Deleting a Stored Procedure or a Functions;

Packages:- Components of a Package; Package Objects; Private and Public ; Package state;

Package Dependency; Triggers:- Use of Database Triggers; Database Triggers V/s Procedures;

Database Triggers V/S Integrity constraints; RAISE_APPLICATION_ERROR PROCEDURE;

Types of Triggers:- Row Triggers, statement Triggers; Before V/S After Triggers; Deleting a