Dear students, get latest Solved assignments by professionals.
Mail us at: help.mbaassignments@gmail.com
Call us at: 08263069601
JAIPUR NATIONAL UNIVERSITY, JAIPUR
School of Distance Education & Learning
Internal Assignment No. 1
Masters of Computer Application (MCA)
Paper Code: MCA-302
Paper Title: RDBMS (ORACLE)
Last Date of submission: Max. Marks: 15
Section-A (Word limits 50-100)
i. What do you mean by kernel?
ii. Explain the client/server architecture.
iii. How could we filter data present in table?
iv. Explain Removing Integrity Constraints.
v. Describe the concept of Indexing.
Section-B (Word limits 500)
Q.2 Explain Cod’s law for RDBMS.
Q.3 What do you mean by joins and explain types of joins.
Q.4 Differentiate SQL and PL/SQL.
Dear students, get latest Solved assignments by professionals.
Mail us at: help.mbaassignments@gmail.com
Call us at: 08263069601
JAIPUR NATIONAL UNIVERSITY, JAIPUR
School of Distance Education & Learning
Internal Assignment No. 1
Masters of Computer Application (MCA)
Paper Code: MCA-302
Paper Title: RDBMS (ORACLE)
Last Date of submission: Max. Marks: 15
Section-A (Word limits 50-100)
1 Write difference between B-Tree and B+–Tree.
2 What are the main features of cursor?
3. What is the syntax of Exception Handling in PL/SQL?
4 How could we take Back up in DBA?
5 What do you mean by ‘SYSDATE’?
Section-B (Word limits 500)
Q.6 Explain Raise Application-error Procedure.
Q.7 Write query in SQL for updating data in table.
Q.8 Explain different looping statement in PL/SQL.
Dear students, get latest Solved assignments by professionals.
Mail us at: help.mbaassignments@gmail.com
Call us at: 08263069601