Download SQL, PL/SQL Question Paper 2012

Download Image 1

Download Image 2

Download Image 3

BCA Sem-3 PL\SQL, DFS, MFCS & OOP Syllabus

Download PDF File

How to write Procedure Block Name in PL/SQL simple example

----------------------------------------
Syntax:
----------------------------------------
CREATE [OR REPLACE] PROCEDURE [PROCEDURE_NAME](ARGUMENTS {IN / OUT / INOUT} DATA-TYPE)
IS/AS
    CURSOR DECLARATION;
    VARIABLE DECLARATION;
BEGIN
    SQL & PL/SQL STATEMENTS;
EXCEPTION
    ERROR HANDLING;
END;
/

Download SQL Theory Assignment 2 with Answer

Here is one zip file download and extract it. You will get number of image which contain all questions' answers. Lets complete it.

Download zip File

DOWNLOAD SQL REFERENCE BOOK

SQL REFERENCE BOOK

SQL(LAB) Assignment 4 Queries's Answer

1. Create table Student with below given table structure and constraints. Datatype Constraints Remarks Roll_no Number(3) Primary Key  Unique identification number of student Name Varchar2(15) Unique Name of student Birth_Date Date Gender Varchar2(10) Not Null  Male or Female.

1. CREATE TABLE STUDENT

(ROLL_NO NUMBER(3) CONSTRAINT PK_RNO PRIMARY KEY,

NAME VARCHAR2(15) CONSTRAINT UN_NAME UNIQUE,

Get SQL Assignment 2 Query 's Answer

 Download SQL Assignment 2 Lab all Answer 


 password : smitguide


Download ans file



1)CREATE TABLE BOOK_DETAILS
(BCODE NUMBER(2) CONSTRAINT PK_BCODE PRIMARY KEY,
BNAME VARCHAR2(25) CONSTRAINT UN_BNAME UNIQUE,
AUTHER VARCHAR2(20),

Download SQL Theory Assignment 1

1.       What is RDBMS? List example of RDBMS packages.

2.       State the full form of SQK. What is role of SQL with respect of RDBMS package? List out the major features of SQL

3.       Explain in brief the different between SQL and SQL* Plus

4.       State the difference between CHAR and VARCHAR2 datatype

Download SQL LAB Assignment 1 with Answers

Download Listed Image Files

First Image

Second Image

Third Image

Fourth Image