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

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. Answer briefly :

 (a) Write in brief about repairing windows.

 (b) What do you mean by document navigation?

 (c) What  do you mean by RDBMS?

 (d) Define Relational Data Structure.

 (e) What  do you mean by Answer Wizard?

 (f) What do  you mean by Information Processing?

 (g) What  do  you  mean by report in  MS-Access?

 (h) What do you mean by NULL in SQL?

 (i) Explain APPEND Query in SQL using example.

 (j) What do you  mean  by  QBE?

SECTION-B

2.       What  do  you  mean  by  SQL?  Explain  various  types  of  SQL  Tables.

Explain the syntax with example for creating, deleting and updating table.

3.       Explain  various steps for creating the forms, entering  and  updating  data using forms in Access 2000.

4.       Explain various steps in creating and using queries in Access 2000.

5.       Explain the following terms related to RDBMS :

a. relation

b. tuple

c. attribute

d. degree

e. cardinality

6.        How  a  document  can  be printed  through  Microsoft  Office  2000?  What are  the  various  properties  that  can be  set  during  printing?  What  do  you mean by Print Preview?

7.       Explain the following terms :

a. Information

b. Information processing

c. Database

d. Characteristics of  data in  a database

e. Quality of information