CS614 Midterm spring 2024

short Questions,
Write the statements as correct or incorrect and give reson for each
1)OLAP is not concerned with historical data.
2) OLTP is concered with day-to-day transactions
5 statements likhi thi,
OLTP aur DWH k baray mein
unke agay likhna th k konsi DWH h aur konsi OLTP h
aik table th,
us mein
FLAT table,
user access,
user involvement
aur 3 aur words likhe th
in mein btana th k konsa OLTP h aur konsa DWH
wisdom is the application of intelligence and experience
yeh mcq aya th
Data sources are unstructured & heterogeneous.
yeh mcq ayi thi
1st Normal form thi di hui usy 2nd r 3rd form MN convert krna tha .
Third normal form ki definition likhai hui thi r btana thak kis ki definition .
OLTP and OLAP. K column thy.
Fact and dimensions ka tha ak question.
UK time r pk time style likhy huwy thy.r Sath road measure thy pk ka r UK ka
In ka btana tha Kon sa conversation he
Mcqs Vu topper ki files sy thy 8 9

CS614 9:30 am
Midterm
Date:31-5-2024
MCQ’S
1 to 18 lecture form Handouts,
Past files no idea
Subjective
Short
1.ak statement di hui thi or btana tha k ye correct ha ya incorrect OLTP k lehaz se, statement incorrect thi .

2. Decision making K related tha pre joining ?
3. Two statement thi oltp and dwh verify krna tha?
   Long
4. A table was given and identify the additive and non additive from them.
5. A table wase given One to many relation and any process use pre joining and normalization or de dimension.
6. A table was given and identify the Fraud detection ,Profitability analysis, Direct mail/database marketing,Credit risk prediction, Customer retention modeling, Yield management, and Inventory management

CS614 9:30 am
Midterm
MCQ’S
8-9 from past others was form Handouts
Subjective
Short

In OLAP test FASMI Stands for ?

Write the two activities used in wisdom ?

Write the three types of transformation ?
Long

A table was given and identify the facts, dimensions and primary key from them.

Write the name of four types of Cube operations.

A table was given and identify the Fraud detection ,Profitability analysis, Direct mail/database marketing,Credit risk prediction, Customer retention modeling, Yield management, and Inventory management from them.
Today CS614 Paper
Time: 8:00AM
Mcq’s from Handouts
Short Questions

FASMI stand for

Enlist 3 Data Warehouse Factors

Unit Conversion or Date Conversion ko identify krna tha statements mein se
Long Questions

Query chlani thi studentID, StudentProgram aisa tha kuch jis me Adding Redundant Column ki query chlani thi to avoid joining

Table tha jis me se Primary key, Facts or Dimensions ko identify krna tha

4 statements di hui thi jin me se Fraud Detection, mail marketing, yield management wgera ko identify krna tha
Cs614
Mcqs kuch past ppr file sy thy bki handouts sy
SQ statements thi btana tha correct hai k nai OLTP ki knowledge drive kis sy hoti hai
LQ ik table ka data tha or btana tha k 2nd NF hai yh 3rd
Or ik student table given tha usko campus k reference horizontal splitting krni thi