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

Roll No……….

Total No. of Questions: 13

D-33

[2037]

B.Sc. (IT) (Sem.-1^st & 2^nd)

RDBMS-I (B.SC. (IT) – 104/203/102)

DATABASE MANAGEMENT WITH MICROSOFT ACCESS

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 is the task of DBMS in database?

(b) What is the difference between database and DBMS?

(c) Define primary key and how does it differ from foreign key.

(d) List the characteristics of data in a database.

(e) Differentiate between attribute and domain.

(f) List the database objects available in MS Access?

(g) How can one arrange buttons in toolbar in MS Access?

(h) How is the structure of a table viewed in MS Access?

(i) What is the significance of macros in MS Access?

(j) How can one retrieve all the rows in a table in MS Access?

(k) What are different DML commands?

(l) What are the characteristics of SQL?

(m) Write a query to create a new t able from an existing table? Assume suitable table.

(n) How can one delete all the rows in a table? Give suitable example.

(o) What is the significance of having clause in SQL? Give example.

SECTION-B

Q2)   Explain  the three level architecture of database system .

Q3)   Compare file management system with DBMS.

Q4)   What is the role of data model and explain different categories of data           models .

Q5)   What are the integrity rules ? Explain with examples .

Q6)   Explain  in detail how can a from be created and how can data fields be         updated with  suitable example in MS Access .

Q7)   write a short note on sorting and filtering records in MS Access .

Q8)   How can relationships between tablets created in MS Access ? Give     suitable  example .

Q9)   Discuss in detail about an overview  of Access Security .

Q10) What are different data types of SQL in Access .

Q11) Explain the incorporation  of SQL in  Access .

Q12) How you can establish relationship between the different tables in SQL         ? Give suitable example .

Q13) Compare SQL with SQL* Plus.