Download Model question papers & previous years question papers

Posted Date: 09 Jan 2017      Posted By:: himanshuchouhan    Member Level: Gold  Points: 3 (Rs. 3)

2016 Mohanlal Sukhadia University Computer B.C.A. B.C.A II Year Examination,2016 mohanlal sukhadiya university Question paper



Course: B.C.A.   University/board: Mohanlal Sukhadia University

Are you looking for the old question papers of mohanlal sukhadiya university B.C.A ? Here is the question paper from mohanlal sukhadiya university. This is the original question paper from the BCA II Year exam conducted by mlsu university in year 2016. Feel free to download the question paper from here and use it to prepare for upcoming exams.



B.C.A II Year Examination, 2016
Paper- II
(Database Management System)

Time: Three Hours
Maximum Marks : 100

PART - A [ Marks: 20 ]
Answer all questions(50 words each).
All questions carry equal marks.

PART-B [ Marks: 50 ]
Answer five questions(250 words each).
selecting one from each unit.All questions carry equal marks.

PART - C [ Marks: 30 ]
Answer any two questions(300 words each).
All questions carry equal marks.

PART-A

UNIT - I

1. (i) Define DBMS.

(ii) What is Entity ?

UNIT- II

(iii) Define domain.

(iv) What do u mean by Data Ditionary ?

UNIT - III

(v) What do u mean by embedded SQL.

(vi) Define view.

UNIT - IV

(vii) Define DBTG.

(VIII) What is virtual record ?

UNIT - V

(ix) What is file organization ?

(x) What is B tree

PART -B

UNIT - I

2. Explain the goals and objective of database management system.

3. What is Entity relationship model ? Explain ER model with the help of suitable example.

UNIT - II

4. Write a short note on following :
(i) Relation
(ii) Tuple
(iii) Attribute
(iv) Degree
(v) cardinality

5 . Explain relational data integrity.

UNIT - III

6. Write SQL command for (i) to (v) on the basis of given table
SPORTS (STUDENT_NO, CLASS,NAME,GAME1,GRADE1,GAME2,GRADE2)
(i) To create the above mentioned table.

(ii) To insert the record.

(iii) Display the name of students who have grade 'C' in either GAME1 or GAME2 or both.

(iv) Add a new column named 'Marks'.

(v) Display the games taken by the students where NAME starts with 'A'.

7. Differentiate between Group by and Order by clause in SQL with the help of example.

UNIT- IV

8. Explain DBTG data retrieval, update and set processing facilities.

9.Explain various facilities of hierarchical model.

UNIT- V

10. Explain Logical and Physical file organization.

11. Explain Indexing and Hashing.

PART - C

UNIT -I

12. Explain various level of data abstraction in a database system
.
UNIT - II

13. Explain different types of keys with help of suiatable example.

UNIT - III

14. Explain DDL and DML with the help of example.

UNIT - IV

15. Write about network model and hierarchical model.

UNIT- V

16. Explain sequential, random and hierarchical file organization.



Attachments:





Return to question paper search

Next Question Paper: M.A (English) Semester-1 Literary History-1 by GNDU OF DEC.2016

Previous Question Paper: B.C.A II year Examination , 2016 mohan lal sukhadiya university

Related Question Papers:


  • B.C.A II Year examination 2016 mohanlal sukhadiya university


  • B.C.A 2nd year examination, 2016 mohanlal sukhadiya university


  • Categories


    Submit Previous Years University Question Papers and make money from adsense revenue sharing program

    Are you preparing for a university examination? Download model question papers and practise before you write the exam.


    Awards & Gifts
    Top Contributors
    TodayLast 7 Daysmore...

    Online Members

    More...
     
    ISC Technologies, Kochi - India. © All Rights Reserved.