DBMS Question Paper MBA

I am doing MBA from West Bengal University of Technology. I am in 3rd Semester. I need question papers of DBMS Subject for preparation for End Semester Exam. So will you give link to download question papers of DBMS Subject of MBA Program of West Bengal University of Technology?

[pawan]

As you are looking to download question papers of DBMS Subject of MBA 3rd Semester Course of West Bengal University of Technology, so here is question paper:

West Bengal University of Technology MBA DBMS Question Paper

Choose the correct alternatives for any ten of the following :
i) A query is used to
a) extract information from database
b) create entities
c) create storage space
d) none of these.

ii) Extension of a relation is
a) set of tuples appearing in a relation
b) schema of a relation
c) set of relationship of a given relation at a given point of time
d) none of these.

iii) An attribute that can be broken down into smaller parts is called a ( n ) ................ attribute.
a) Associative b) Simple
c) Composite d) Complex.

iv) In ER model, a multivalued attribute is represented using
a) Ellipse b) Double diamond
c) Double rectangle d) Double ellipse.

v) DCL is a language that allows
a) Granting of privileges b) Retrieval of data
c) Alter schema objects d) Rename schema.

vi) Normalisation is used
a) to remove insertion, updation, deletion anomalies
b) to replace data
c) to add new data
d) none of these.

vii) A rule that states that each foreign key value must match a primary key value in the other relation is called the
a) Referential integrity constraint
b) Key match rule
c) Entity key group rule
d) Foreign / primary match rule.

viii) On which structure is the hierarchical model based ?
a) Graph b) Linked list
c) Tree d) None of these.

ix) The relational calculus is used to measure
a) the formula
b) selective power of relational languages
c) the propositions
d) none of these.

x) A distributed DBMS is characterized by
a) number of fragments
b) replication of fragments
c) presence of global application
d) all of these.

xi) REVOKE command allows
a) withdrawal of privileges
b) read operation
c) granting privileges
d) none of these.

xii) The properites of transaction are
a) atomicity b) isolation
c) consistency d) all.

xiii) A .............. is any key that identifies each entity uniquely. It functionally determines all of the entities' attributes.
a) Superkey b) Primary key
c) Foreign key d) Both (a) and (b)

West Bengal University of Technology MBA DBMS Question Paper