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

Roll No…………

Total No. of questions : 13]

J-3805 [UP-7059]                            [2037]

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

                                      RDBMS (IT -104 /203)

Time : 03 Hours                                                                     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 difference between facts based knowledge and heuristic                          knowledge ?

          b)      Describe the importance of information to build a database ? Also           explain the resources of information .

          c)       List some  limitations of file processing approach .

          d)      Define the term data indepence & its type.

          e)       Explain the basic components of data base systems ?

          f)       How does relational database  differ  from network and                                      hierarchical databases ?

          g)       What is data dictionary ? What type of information is stored in it?

          h)      Difference between binary verses ternary relationship.

          i)       List the level of abstraction in a DBMS using diagram .

          j)       What is difference between primary key and candidate key ?

          k)      What are tools that allow the DBA to monitor  the performance                        of  database ?

          l)       What are the templates ? And how can we set any template as                           default template ?

          m)     How can you create relationship in tables in Access ?

          n)      How we do Data manipulation in SQL.

          o)      Who SQL can be used in Access .

                  

                                                          Section -B

Q2)    Explain following using example : DDL, DML and DCL ?

Q3)    How external , internal and conceptual schemas to be concept of logical   and physical data independence ?

Q4)    Explain the types of user in DMBS also explain their software       capabilities accordingly .

Q5)    List the advantages of using Data Base Management System .

Q6)    What do you mean by relationship ? IIlustrate the types of relationship   also  .

Q7)    What is referential integrity ? How it can be maintained in database ?

Q8)    What are integrity constraints ? Explain about the domain constraints .

Q9)    Explain the functions of database manager in DBMS .

Q10)  Describe the four element of the Access security mode and how do we     create a workgroup ?

Q11) What are the  basic requirement required to run Access -2000.What are   the new features added in latest versions modifications.

Q12)  Write in detail main security issues of SQL & Role of administrator .

Q13)  Write about Following Queries : Select in QBE ;Delete & Update QBE   Queries .