Download Question Paper of "RDBMS-I 2 BSC(IT)" , Question Paper of BSC(IT) 2nd Semester, Subject Code : BS-106, Paper ID B0407, Paper 1

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

Total  No.  of  Questions  :  07

B.Sc.(IT)  (Sem.–2)

RDBMS-I

Subject  Code  :  BS-106

Paper  ID  :  [B0407]

Time  :  3  Hrs.

INSTRUCTION  TO  CANDIDATES  :

1. SECTION-A  is  COMPULSORY  consisting  of  TEN  questions  carrying TWO  marks  each.

2. SECTION-B  contains  SIX  questions carrying  TEN marks  each  and  students has  to  attempt  any  FOUR  questions.

SECTION-A

1.     Write briefly :

a.      What is the need of database systems ?

b.     Define a relation and a tuple.

c.      What is quality of information?

d.     Which component of access 2000 is used to manage databases?

e.      List different types of queries in access 2000.

f.       What is relational data integrity?

g.     What is QBE?

h.     How do you filter records in SQL?

i.       What is Access – DBMS or RDBMS ? Justify

j.       Write any 3 features new to Office 2000

Section –B

2.     List the types   of DBMS . explain RDBMS in detail.

3.     Write the strops to design a form and connect it to a table .

4.     Comment on the advantages of a query language. Write the characteristics of SQL.

5.     Describe the different types of reports in Access 2000, write the steps to create a report.

6.     Write a note on:

a.     The application’s workplace

b.     Document Navigation.

7.     Write the different forms in which SELECT statement of SQL can be used.