Exam Details
| Subject | procedure programming in sql | |
| Paper | ||
| Exam / Course | mca | |
| Department | ||
| Organization | Gujarat Technological University | |
| Position | ||
| Exam Date | January, 2019 | |
| City, State | gujarat, ahmedabad |
Question Paper
1
Seat No.: Enrolment
GUJARAT TECHNOLOGICAL UNIVERSITY
MCA SEMESTER- III EXAMINATION WINTER 2018
Subject Code: 3630009 Date: 11-01-2019
Subject Name: Procedure Programming in SQL
Time: 10.30 am to 1.00 pm Total Marks: 70
Instructions:
1. Attempt all questions.
2. Make suitable assumptions wherever necessary.
3. Figures to the right indicate full marks.
Q.1
Answer the following question.
i. What is Index?
ii. How can we use %rowtype?
iii. How can we use comment in PL/SQL?
iv. method is used to displayed message to the user on the VDU screen.
v. What is the use of GOTO statement?
vi. The data stored in a Cursor is called
vii. Packages allow overloading of Procedure and Function. (True/False)
07
Discuss Sequence with its keywords and parameters with example.
07
Q.2
What do you mean by PL/SQL? Describe the Generic PL/SQL Block in detail.
07
Write a short note on: Running sum Decode.
07
OR
Explain Iterative Control Structure used in PL/SQL in detail with example.
07
Q.3
What is Cursor? Explain various types of Cursor with example.
07
Explain Cursor for loops and Parameterized Cursors.
07
OR
Q.3
What is Lock? Explain different level of Lock in detail with example.
07
How Exception Handling can work with Oracle Engine? Discuss Oracle's Predefined Exception Handlers.
07
Q.4
WORKER(workerid, name, wage_per_hour, specialized_in, manager_id)
Write a procedure to display top five highest paid workers who are specialized in "PAINTING".
07
Differentiate Procedure and Function. Also discuss the advantages of using Procedure or Function.
07
OR
Q.4
What do you mean by Package? Describe various components of a Package in detail with example.
07
Discuss Overloading Procedure and Function with benefits of Overloading.
07
Q.5
What do you mean by Trigger? Explain various types of Trigger used in PL/SQL with example.
07
Write a database trigger to check that joining_date field is not empty and also check that the joining_date should be greater than birthdate field in the employee table.
07
OR
Q.5
What is the use of Varray in PL/SQL? How can we declare Varray in PL/SQL? Explain it in detail.
07
Write a short note on: Save Point, Commit and Rollback.
07
Seat No.: Enrolment
GUJARAT TECHNOLOGICAL UNIVERSITY
MCA SEMESTER- III EXAMINATION WINTER 2018
Subject Code: 3630009 Date: 11-01-2019
Subject Name: Procedure Programming in SQL
Time: 10.30 am to 1.00 pm Total Marks: 70
Instructions:
1. Attempt all questions.
2. Make suitable assumptions wherever necessary.
3. Figures to the right indicate full marks.
Q.1
Answer the following question.
i. What is Index?
ii. How can we use %rowtype?
iii. How can we use comment in PL/SQL?
iv. method is used to displayed message to the user on the VDU screen.
v. What is the use of GOTO statement?
vi. The data stored in a Cursor is called
vii. Packages allow overloading of Procedure and Function. (True/False)
07
Discuss Sequence with its keywords and parameters with example.
07
Q.2
What do you mean by PL/SQL? Describe the Generic PL/SQL Block in detail.
07
Write a short note on: Running sum Decode.
07
OR
Explain Iterative Control Structure used in PL/SQL in detail with example.
07
Q.3
What is Cursor? Explain various types of Cursor with example.
07
Explain Cursor for loops and Parameterized Cursors.
07
OR
Q.3
What is Lock? Explain different level of Lock in detail with example.
07
How Exception Handling can work with Oracle Engine? Discuss Oracle's Predefined Exception Handlers.
07
Q.4
WORKER(workerid, name, wage_per_hour, specialized_in, manager_id)
Write a procedure to display top five highest paid workers who are specialized in "PAINTING".
07
Differentiate Procedure and Function. Also discuss the advantages of using Procedure or Function.
07
OR
Q.4
What do you mean by Package? Describe various components of a Package in detail with example.
07
Discuss Overloading Procedure and Function with benefits of Overloading.
07
Q.5
What do you mean by Trigger? Explain various types of Trigger used in PL/SQL with example.
07
Write a database trigger to check that joining_date field is not empty and also check that the joining_date should be greater than birthdate field in the employee table.
07
OR
Q.5
What is the use of Varray in PL/SQL? How can we declare Varray in PL/SQL? Explain it in detail.
07
Write a short note on: Save Point, Commit and Rollback.
07
Other Question Papers
Subjects
- advance database management system
- advanced biopharmaceutics & pharmacokinetics
- advanced medicinal chemistry
- advanced networking (an)
- advanced organic chemistry -i
- advanced pharmaceutical analysis
- advanced pharmacognosy-1
- advanced python
- android programming
- artificial intelligence (ai)
- basic computer science-1(applications of data structures and applications of sql)
- basic computer science-2(applications of operating systems and applications of systems software)
- basic computer science-3(computer networking)
- basic computer science-4(software engineering)
- basic mathematics
- basic statistics
- big data analytics (bda)
- big data tools (bdt)
- chemistry of natural products
- cloud computing (cc)
- communications skills (cs)
- computer aided drug delivery system
- computer graphics (cg)
- computer-oriented numerical methods (conm)
- cyber security & forensics (csf)
- data analytics with r
- data mining
- data structures (ds)
- data visualization (dv)
- data warehousing
- data warehousing & data mining
- database administration
- database management system (dbms)
- design & analysis of algorithms(daa)
- digital technology trends ( dtt)
- discrete mathematics for computer science (dmcs)
- distributed computing (dc1)
- drug delivery system
- dynamic html
- enterprise resource planning (erp)
- food analysis
- function programming with java
- fundamentals of computer organization (fco)
- fundamentals of java programming
- fundamentals of networking
- fundamentals of programming (fop)
- geographical information system
- image processing
- industrial pharmacognostical technology
- information retrieving (ir)
- information security
- java web technologies (jwt)
- language processing (lp)
- machine learning (ml)
- management information systems (mis)
- mobile computing
- molecular pharmaceutics(nano tech and targeted dds)
- network security
- object-oriented programming concepts & programmingoocp)
- object-oriented unified modelling
- operating systems
- operation research
- operations research (or)
- pharmaceutical validation
- phytochemistry
- procedure programming in sql
- programming skills-i (ps-i-fop)
- programming skills-ii (ps-oocp)
- programming with c++
- programming with java
- programming with linux, apache,mysql, and php (lamp)
- programming with python
- search engine techniques (set)
- soft computing
- software development for embedded systems
- software engineering
- software lab (dbms: sql & pl/sql)
- software project in c (sp-c)
- software project in c++ (sp-cpp)
- software quality and assurance (sqa)
- statistical methods
- structured & object oriented analysis& design methodology
- system software
- virtualization and application of cloud
- web commerce (wc)
- web data management (wdm)
- web searching technology and search engine optimization
- web technology & application development
- wireless communication & mobile computing (wcmc)
- wireless sensor network (wsn)