MCA-302 RDBMS (ORACLE) - JNU University BBA Solved Assignments Latest

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

 

 

 

 

 

 

 

 

 

 

 

 

 

 


No comments:

Post a Comment

Note: only a member of this blog may post a comment.