Saturday, July 4, 2009

DBMS 3rd july paper

Kindly do make vuhelps your default page and keep viewing it to get up to date information about current fresh exams. Also follow the blog. Send your papers to make them here uptodate at or feel free to call at 03455242488
Q1 What is Index Classification?

Write SQL queries for the following relations

CUSTOMER (custId, name, address, city, province, postalCode, phone)
ORDER (orderNo, custId, invNo, datePlaced, datePromised, terms, status)
ORDER_LINE (orderLineNo, orderNo, pCode, qty)
INVOICE (invNo, custId, orderNo, date, status)
INVOICE_LINE (invLineNo, invNo, pCode, qtyShip)
PRODUCT (pCode, pName, pDescription)

a) Delete a customer’s record whose name is zafar and city is Karachi.
b) List all the product names in descending order whose quantity shipped is less than 5000.
c) List all the invoice numbers whose product code is 12.
d) List all the order numbers whose quantity is more than 2500.
e) Create a view containing the following attributes from the CUSTOMER and ORDER relations.

CUSTOMER (custId, name, address)
ORDER (orderNo, datePlaced, status)

Question No: 2 ( Marks: 6 )

Differentiate between the followings.

Horizontal and Vertical partitioning.

Question No: 3 ( Marks: 25 )

Differentiate between the followings?

a) Differentiate committed and rollback transaction
b) What are the major differences in clustered and non clustered indexes?
c) What is the difference between detection and prevention schemas of dead lock prevention?
d) What is the difference b/w Equi-join and Natural join?

Question No: 4 ( Marks: 20 )

Normalize the given data table up to 3NF.

(Student# , Advisor , Adv-Room , Class1 , Class2 , Class3)

Which normalisation transformation corresponds to "Eliminating partial key dependencies"?

unnormalised to 1NF

1NF to 2NF

2NF to 3NF


A back-up and recovery regime should protect an organisation against:

incorrect data

corrupt media

insecure data

Transactions are often referred to in terms of ACID. Which one of the following is not part of the term ACID?





Question No: 12 ( Marks: 2 ) - Please choose one

In ------- type of partitioning table is split on the basis of rows




None of the given

Question No: 13 ( Marks: 2 ) - Please choose one

Which of the following is a good example of what is meant by?

All disk access happens one after another

The result of the transactions is the same as if the transactions went
one after another

The situation where the Lost Update problem exists

All transactions happen one after another

Regards Vuhelps

No comments: