Download Question Paper of "RDBMS 2 BSC IT(D)" , Question Paper of BSC IT(D) 2nd Semester, Subject Code : 502, Paper ID 2037, Paper 1

Roll No. ...........................

Total No. of Questions : 13

J -3856[S-8037]                                                           

[2037]

B.Sc. (IT) (SEM.-2^nd) M.Sc (IT)

RDBMS

(B.Sc. (IT)-502)(M.Sc(IT)-202)

Time : 03 Hours                                                            

Instruction to Candidates:

1)             Section - A is  Compulsory.

2)             Attempt any Nine questions from Section -  B.

Section –A

1.       

a.     Give  an example of a table that is in INF.

b.     What is data dictionary?

c.      Define union operation.

d.     What do you mean by data independence?

e.      Differentiate  between WHERE and HAVING clause in SQL.

f.       What is weak entity set?

g.     Differentiate between natural join and outer join.

h.     Define one – to- one relation.

i.       Explain Update statement in SQL.

j.       What is a transaction?

k.     What is an implicit cursors ?

l.       What is difference between SQL and SQL *PLUS?

m.  How you will avoid your query from using indexes?

n.     What is Oracle call interface (OCI)?

o.     Define time series databases.

Section- B

2.     Describe main functions of a database administrator .

3.     In the context of databases, define the following

(a)   Super key (b) candidate key (c) primary key (d) foreign key

4.     Discuss with examples about various types of attributers present in the  ER model.

5.     What is normalization in RDBKS?  Explain 3NF with the help of an example.

6.     How will you define  a view in SQL.

7.     Consider the  following relations with primary keys underlined

Salesperson(SNo. Shame, designation)

Area (ANo. Aname , ManagerNO)

Product (PNo. Pname , cost)

SAP (SNo. ANo, PNo)

Represent the queries listed below as expressions in SQL

a)     Get the names of all the products that are sold.

b)    Get the names of all salespersons who are not managers.

8.     Explain the following

a.      ISA relationship

b.     Database schema.

9.     What is the difference between database trigger and schema trigger? Explain  with example.

10.    What is a cursor? Can cursor variables be stored in PL/SQL tables ? If Yes, if   

       not why ?

11.     Differentiate between DDL and DML. Give examples .

12.    Explain main features of PL/SQL.

13.   Write short notes on

a.     Oracle database structure.

b.     Database server.