Database Management with Microsoft Access, Question Paper of BSC IT (D) 1st Semester,Download Previous Years Question Paper 4

Roll No……

Total No. of Questions:13

Paper ID [A0304]

B.Sc.(IT/DCA) (104/102/203) (Old/New) (S05) (Sem.-1^st)

RDBMS-I

Time: 3 Hrs.                                                                           Max. Marks: 75

Instruction to Candidates:

1. Section-A is Compulsory.

2. Attempt any Nine questions from Section-B.

SECTION-A

Q1.

          (a) What should be objectives of database organization?

          (b) What are advantages of DBMS?

          (c) What is the responsibility of database administrator?

          (d) What is entity Integrity?

          (e) What do you Primary Key?

          (f) What is quality of information?

          (g) What are Logical and Physical Databases?

          (h) Write syntax for APPEND Query?

          (i) Differentiate between DDL and DML.

          (j) What is criterion for analyzing information?

          (k) How cursors work?

          (l) Define correlated sub query and view?

          (m) What are features of Access 2000?

          (n) Explain with an example how integrity of the data is lost.

          (o) Write syntax for DELETE Query?

SECTION-B

Q2.    Explain the various Data Models. Discuss

          (a) Which is easy to use?

          (b) Which is close to real life?

          (c) Which is simplest to use?

Q3.    Explain how table is created, updated and its values modified using SQL.

Q4.    How are concurrency and security maintained in databases?

Q5.    Consider the following relation database.  Give an expression in SQL for          each of the following queries:

          EMPLOYEE (employee- name, street, city)

          WORKS (employee- name, company- name, salary)

          COMPANY (company- name, city)

          (a) Find the names and cities of the residence of all employees who work for     “ABC Ltd.”?

          (b) Give an SQL DDL definition of above databases?

Q6.    What are characteristics of SQL in Access?

Q7.    What are steps required when building reports?

Q8.    Explain Database design process?

Q9.    Illustrate use of filters in sorting of records.

Q10. What are major requirements to create query?

Q11. Explain with examples Report and Screen forms?

Q12. How will you find, edit and delete data in a form?

Q13. What are different types of SQL Tables? Explain with example.