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

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.

2) Attempt any Four questions from Section–B.

Section - A

1.       

a.     Differentiate MDI and SDI

b.     What is a database and a DBMS?

c.      Define data integrity in a RDBMS. Give an example of a data integrity constraint.

d.     Name the different views data in Access 2000 database.

e.      Give an example of a query.

f.       What is Cartesian product of relations?

g.     What is design view of Access 2000?

h.     Write any 4 characteristics of  SQL.

i.       Define the term information processing.

j.       What is QBE.

Section-B

2.     Describe the features of office 2000.

3.     Discuss the structure of a relational database.

4.     What are the different types of report. How do you create a report in Access 2000?

5.     List different data types in access 2000 Briefly describe different properties . you can set for a text field.

6.     Describe data manipulation commands of SQL.

7.     Give example of any two SELET queries in QBE.