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 vuhelps@gmail.com or feel free to call at 03455242488
DBMS
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

►
3NF to BCNF

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?

►
Atomic

►
Isolation

►
Durable

►
Complete



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

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

►
Horizontal

►
Vertical

►
Parallel

►
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?
“Serialisability”

►
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