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 firstname.lastname@example.org 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
3NF to BCNF
A back-up and recovery regime should protect an organisation against:
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