Makhanlal Chaturvedi National University of Journalism and Communication 2011 B.C.A Computer Application / oracle Rdbms - Question Paper

4BCA
ORACLE RDBMS
UNIT I
1. (a) provide the brief introduction of Oracle. elaborate the differences ranging from DBMS and RDBMS ?
(b) What do you understand by Database Models?
2. (a) What do you understand by client/server computing ? Write the name of a few Oracle server products.
(b) discuss the Oracle system process.

UNIT II
3.(a) elaborate the Primary key and Foreign key ? provide the syntax with example for the subsequent :
(i) To add a primary key
(ii) change data kind and width existing column
(b) discuss the functions of oracle.

4. (a) provide the syntax with example for the subsequent :
(i) Add a row for opted columns
(ii) Using "select" with "where"
(iii) Sorting data in a table
(iv) Change a table name
(b) Write the use of ALTER command. provide the syntax for the subsequent :
(i) Add foreign key constraint
(ii) Drop foreign key constraint on a column.

UNIT III
5. (a) Write the advantage of PL/SQL. discuss the data kinds in PL/SQL.
(b) What is Cursor ? discuss the kinds of cursor.

6. (a) elaborate the various kinds of control structure ?
(b) Write a PL/SQL Block using loop.

UNIT IV

7. (a) elaborate the keywords using for the creating functions and procedure ?
(b) What do you understand by transaction management system ? discuss ROLLBACK and COMMIT command with example.
8.(a) What is Lock ? discuss kinds and level of Lock.
(b) Create a Procedure. Write a PL/SQL Block using call this procedure.

UNIT V

9. (a) elaborate the functions of Oracle DBA ?
(b) discuss the Triggers in detail.
10.(a) discuss the subsequent :
(i) Table space
(ii) Recovery
(b) discuss the subsequent :
(i) Revoke
(ii) Backup

Earning:   Approval pending.