WBUT Question Papers EC Database Management System B Tech Sem 7th 2008

WBUT Question Papers EC

Database Management System B Tech Sem 7th 2008

 

{ Full Marks : 70

GROUP – A ( Multiple Choice Type Questions)

Choose correct answer from the given alternatives for any ten of the following :

i)   key cannot be null.

a) Primary                b) Foreign

c) Candidate              d) Unique.

ii)         The DML provides which of the following function(s) to database ?

a) Retrieve records       b) Insert records

‘ i c) Delete records d) All of these.

ill) The project operation used in Relational Algebra is

a) unary operation        b) binary operation

c) ternary operation      d) none of these.

iv)         The collection of data stored in a database at a particular moment is called the a) relation b) schema

c) instance               d) none of these.         j

v)          All candidate keys other than the primary keys are called

a)  secondary keys     b) alternate keys

c) eligible keys        d) none of these.

 

CS/B,TECH(ECE-NEW)/SEM-7/EC-704C/08/(09)

4

  US

vi) If a relation is in……………………. .. ,

it is also in 3NF.  
a) 2 NF

b)

BCNF  
c) both (a) and (b)

d)

none of these.

1          !

 

vii)       Which one of these is an aggregate function in SQL ?

a) Ag                     b) Select

c) Order by               d) None of these.

viii)      ‘If a table is dropped, views associated to the table are also dropped automatically’. The statement is

a)          true

b)    false.

tx) When all the attributes in a relation describe and depend upon the primary key, the relation is said to be

a)             INF                  b) 2 NF

c)          3 NF                  d) 4 NF.

x)          Which of the following is not a DDL statement ?

a)          ALTER                     b) DROP

c) CREATE                 d) SELECT.                   [ ~

xi)        A table can be logically connected to another table by defining a

       a)    hyperlink     b) common field

4

c) foreign key            d) primary key.            .

xii)       Which of the following is not a recovery technique ?

a)   Shadow-paging b) Deffered updating

c) Write-Ahead logging    d) Immediate updating.

GROUP -B ( Short Answer Type Questions )

Answer any three of the following.    3×5=15

  1. State the advantage(s) of using database system over file-based information system,
  2. Explain the concept of specialization and generalization in ER modelling through appropriate example;
  3. What are the problems that may occur due to concurrent execution of transactions ?
  4. Distinguish between serial schedule and serializable schedule through example(s).
  5. Write a short note on ‘secondary index’.

GROUP -C

( Long Answer Type Questions )                              .

Answer any three questions.        3 x 15 = 45

  1. a) Define ACID property of database.                    5

b)          Define BCNF. Why is it considered stronger than 3 NF ? Justify your answer.’                                          2 + 4

c)          Explain the term ‘weak and strong entity’ in context of E-R data model.                                                      4

  1. a) Consider the following relation schema

customer { cust_name, street, city ) account (account_no, branch_name, balance ) branch ( branch_name, city, assets ) borrow (loan_no, branch_name, amount).

i)          Find the names of all customers who live in the same street and city as RAM. (Write Relational Algebra expression )

ii)         Find all customers who have an account at all branches located in Sah Lake. (Write Relational Algebra expression )

iii)        Find all customers who have an account at all branches located in Gariahat. (Write SQL Queiy ).

iv)        Find all loan members for loans with an amount greater than Rs. 10,000/- ( Write SQL Queiy )                       10

b)        When is it preferable to use Sparse index than Dense index ? Justify your ‘                                               answer,  5

77872 (12/12) [

  1. a) State the steps involved in query processing. Why is the query optimization needed ?                                            3 + 3
  2. b   Write a brief note on ( Lossless decomposition ).       4
  3. c)    Explain the term ‘update anomalies’, with suitable example(s). 5
  1. a) What are the difference(s) between Natural Join and Outer Join ? Explain. 5
  2. b)          Describe the deadlock-preventlon techniques.            5

c)          State the advantage of locking mechanism and also explain the utility of defining shared lock and exclusive lock. 5

  1. Write short notes on any three of the following :     3×5=15

i)           Trigger

ii)          View

ill)  Data independence

iv)         View serializability

v)          Role of Functional Dependency in normalization.

Leave a Comment