Question
Which type of slowly changing dimension (SCD) preserves
full history by adding a new row for each change and using effective date ranges?Solution
SCD Type 2 preserves history by inserting new rows with new surrogate keys and storing effective/expiry dates or current flag.
Given below is a question followed by two statements numbered I and II, each containing some information. Decide which of the statement(s) is/are suffic...
How will âwindâ be written in a certain code?
I. In this code âEvening wind is goodâ is written asâKt Rt Ct Ptâ.
II. In t...
In which direction is B facing now?
I. From point C, B walks 10m, then he takes left turn and walks 5m.
II. From point A, B walks 5m towa...
Six student M, N, O, P, Q and R scored different marks in an exam. Who scored the third lowest marks?
Statement I: M scored more than P and R,...
Z is in which direction with respect to R?
I. Q is 4 km towards north of R. S is 8 km towards west of Q. Z is 4 km towards north of Q.
Among E, G, H, I, J and K, who is second to the left of G if all are sitting around a circular table facing the centre.
I. J sits third to left o...
Eight boxes are kept one above another in a stack. Which box is kept three boxes above U?
Statement I: X is two boxes above T. Y is one box be...
How is P related to E?
What is Guna's age?
I. Guna, Vinay and Keshav are all of the same age.
II. Sum of ages of Vinay, Keshav and Arjun is 32; also, Arjun is a...
Preeti is in which direction with respect to Suhail?
I. Mohit is to the west of Tarun, who is to the north of Suhail. Preeti is to the north of ...
