Tuesday, December 8, 2015
- Tuesday, December 08, 2015
- PunjabtechnicalUniversity ajay gour
- 1st Semester Bsc. IT (D), Database Management with Microsoft Access Bsc IT 1
- No comments
Total No. of Questions:13
Paper ID [A0304]
B.Sc.(IT/DCA) (104/102/203) (Old/New) (S05) (Sem.-1st)
Time: 3 Hrs. Max. Marks: 75
Instruction to Candidates:
1. Section-A is Compulsory.
2. Attempt any Nine questions from Section-B.
(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?
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.
punjabtechnicaluniversity.blogspot.in Roll No......................... ... Total No. of Questions : 07] ...
Roll No……….. Total No. of Questions: 07 B.Com. (Sem.-1 st ) FINANCIAL ACCOUNTING Subject Code: BCOP-101 Paper ID: [B1101] ...
punjabtechnicaluniversity.blogspot.in Click Here for Syllabus of B-Tech 1st Year . http://ptu.ac.in/userfiles/file/engg_syllab/1st_and_...
Business Organisation and Management, Question Paper of B.Com 1st Semester,Download Previous Years Question Paper 2Roll No…….. Total No. of Questions: 07 B.Com (Sem.-1 st ) BUSINESS ORGANIATION AND MANAGEMENT Subject Code: BCOP-102 (2011 &a...
Roll No……. Total No. of Questions:07 B.COM (Sem.-1 st ) BUSINESS MATHEMATICS SUBJECT CODE: BCOP-104 (2011 Batch) PAPER ID: ...
punjabtechnicaluniversity.blogspot.in Roll No. ...................... Total No. of Questions : 13] ...
punjabtechnicaluniversity.blogspot.in Master Of Technology (M-Tech) Syllabus SYLLABUS FOR MASTER OF TECHNOLOGY (M-Tech) Br...
punjabtechnicaluniversity.blogspot.in Click Downlink for Dowload of Scheme and Syllabus of B.Com. Professional Batch 2011onwards ht...
B.Sc. IT (402) (S05) / 102 (New) (Sem. - 4th) BASIC MATHEMATICS – I, Punjab Technical University, PTU, Question paperpunjabtechnicaluniversity.blogspot.in Roll No. ................. Total No. of Questions : 13] ...
punjabtechnicaluniversity.blogspot.in Roll No . ............ Total No. of Questions : 07) ...