20 mcqs and 14 msqs were from moaaz file
subjective questions.
1)List down any two disadvantages of Molap? (2 marks)
2)List down two step of basic sorted neighborhood? (2 marks)
3)aik statment identify kerni thi k correct hai ya in coorect from Orr’s Law ? (3 marks)
4) AIk statment TQM ki identify krni thi correct or incorrect? (3marks)
5)aik fact and dimensions table create kerna tha ( 5marks)
6)Orr’s Law ki aik aur statment 5 marks ki identfy kerni thi k correct hai ya in coorect and ans ko justify b krna tha (5 marks)
80% MCQ from Moaaz file and previous sem MCQs…
1)What is the difference between Additive and non-additive? (2 marks)
2)Define and explain one-to-many transformation? (2 marks)
3)If the Government use dirty DWH; what problems could happen ? (3 marks)
4) Dont remember? (3marks)
5)Identify atleast 3 or more facts in the fact table of a company’s sales record, company want to know per day aggregate sales in a specific store item wise. ( 5marks)
6)Clustering is one of the automatic data cleansing technique, list atleast 3 more automatic techniques and list down drawback of clustering if any? (5 marks)
1)List down any two disadvantages of Molap? (2 marks)
2)List down two step of basic sorted neighborhood? (2 marks)
3)aik statment identify kerni thi k correct hai ya in coorect from Orr’s Law ? (3 marks)
4) AIk statment TQM ki identify krni thi correct or incorrect? (3marks)
5)aik fact and dimensions table create kerna tha ( 5marks)
6)Orr’s Law ki aik aur statment 5 marks ki identfy kerni thi k correct hai ya in coorect and ans ko justify b krna tha (5 marks)
paper over all boht easy tha.
1. Define one-to-many Transformation with the help of example. 2 Marks
2. Write down four approches which are used to handle Multi-Values Dimensions. 2 Marks
3. Orr’s law say’s that data quality problem decreases when the age of system increases. 3 Marks
4. ER diagram ahve macro relations among data elements, is this right or wrong. Justify your answer. 3 Marks
5. MOLAP cube, pro-partitioning relation between cordinality and cube size, Justify your answer with logical reason. 5 Marks
6. Last question was related to data duplication. 5 Marks