Pixwords 3 lettres Pixwords 6 lettres Pixwords 9 lettres Pixwords 13 lettres Pixwords 18 lettres pixwordssolution.com
EXE MBA Information Technology 1st year Sample Paper for Data Base Management SystemsItsMyAcademy.com

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

 Note:

  1. 1.       Attempt any FIVE questions.
  2. 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
001 Virender 1 MCA I
029 Rajesh 1 MCA I
120 Rohit 2 MCA III
234 Ankur 3 Mtech I

Class ID

Teacher Name Subject

1

Prof. Arun Nair DBMS

1

Prof.S P Singh Java

3

Prof.M Sen OS

2

Prof Wattson Networking

(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!!!

Comments