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

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

Q. 1.

 (a) Explain menus and toolbars in office 2000.

 (b) What is information processing?

 (c) How can you arranging buttons on the toolbar in Access 2000.

 (d) What is the need for DBMS?

 (e) What is relational data structure?

 (f) Explain update operation in SQL.

 (g) What do you mean by Relational data integrity?

 (h) Explain editing Data in a form.

 (i) Explain the different features of Access 2000.

 (j) Explain QBE.

SECTION-B

Q. 2.  Define the following:

(a) Using Answer wizard in Access 2000.

(b) Using the index tab to get help.

Q. 3.  What is DBMS? Explain the different type of DBMS.

Q. 4.  Define the following:

(a) Sorting and filtering records.

(b) Creating and printing reports.

Q. 5.   (a) Explain SELECT Queries in QBE with example.

(b) What are the advantages of QBE?

Q. 6.  Define the following:

(a) Advantages of SQL.

(b) Creating Tables with SQL.

Q. 7.   (a) Explain the Application’s workspace in Office 2000.

(b) How can you work with several document windows in Office 2000?