EXE MBA Information Technology 1st year Sample Paper for Data Base Management Systems
Executive MBA (INFORMATION TECHNOLOGY), SEMESTER-II, YEAR -1,
DATA BASE MANAGEMENT SYSTEMS
Time: 3 Hours Total Marks: 60
- 1. Attempt any FIVE questions.
- 2. Each question carries equal marks
Q1. What is Database? What are different types of database models? Explain them all.
Q2. What is Normalization? What are the advantages of Normalization? What are locks? What are different types of locks?
Q3. Write SQL Query for following Table
|Student RollNo.||Student Name||Class ID||Student Class|
|Prof. Arun Nair||DBMS|
|Prof.S P Singh||Java|
(i) Find No. of students in MCA I
(ii) Who is teacher of Ramesh?
(iii) Find No. of students for OS Course
(iv) What is class of Prof.Arun Nair
(v) List the names of students those who are attending Java Classes
Q4. Explain Entity Relationship diagrams. What are the rules for making ERDs? Explain how you will represent weak and strong entity set in ERD?
Q5. What is meant by the concurrent execution of database transaction in a multi-user system? Discuss why concurrency control is needed, discuss with some examples.
Q6. What are deadlocks, How can deadlocks be detected .How can deadlocks be avoided when using two phase locking protocol.
Q7. What are the advantages of using an index and what are its disadvantages. List some different data structures that are possible for storing data on disk.
Q8. Explain following by giving suitable example –
(i) Domain Constraints
(ii) Entity Integrity
(iii) Referential Integrity
(iv) Operational Constraints.
Q9. List down advantages of RDBMS over traditional file system. What do you mean by Relational Algebra .Explain the Database specific Relational Algebraic Expression?
Note: Above sample paper of EXE MBA Information Technology 1st year has been prepared after reviewing few universities sample papers. We are not sure whether same or similar question papers pattern does your university has or not. We are just trying to help you by providing the possibilities. We always suggest you to go thoroughly with textbooks, teacher’s notes and the syllabus for better preparation of your coming examination.
All the Best!!!