Question
who visits just before the one who has
White? Study the following information carefully and answer the questions given below it. Seven persons namely – A, B, C, D, E, F and G visits different place viz. Udaipur, Raipur, Jaipur, Rampur, Kanpur, Rudrapur and Bilaspur from Monday to Sunday. Each of them has different colour viz. Red, White, BLACK, Yellow, Pink, Green and Blue. All the above given information is not necessary in same order. There were three days gap between the one who has Pink and the one who visits Bilaspur. The one, who visits Udaipur, visits on any day after Friday. There were two days gap between the one, who have Yellow and F who visits Udaipur. There were three days gap between D and the one who visits Jaipur. One person visits between the one who visits Bilaspur and C, who has Red. The one, who visits Kanpur, visits on adjacent day of the one who has Green. At least three person visits between the one, who visits Rampur and the one, who has Blue. There were two days gap between G and the one who likes White, who visits on adjacent day of the one who has Yellow. C neither visits on adjacent day of the one has Yellow nor on adjacent day of F. A visits Raipur on Tuesday. G neither has Pink nor visits before the one who visits Kanpur and he visits Rudrapur. D and the one who has BLACK, visits the cities on adjacent days. Neither D nor B visits Jaipur. There were two days gap between A and the one who has Green.Solution
We have: The one, who visits Udaipur, visits on any day after Friday, that means we have two possible day for the one who visits Udaipur, in case (1) the one who visits Udaipur, visits on Saturday, in case (2) the one who visits Udaipur, visits on Sunday. There were two days gap between the one, who have Yellow and F who visits Udaipur. A visits Raipur on Tuesday. There were two days gap between A and the one who has Green. The one, who visits Kanpur, visits on adjacent day of the one who has Green, that means we have three possible day for the one who visits Kanpur, in case (1) & case (2a) the one who visits Kanpur visits on Thursday, in case (2b) the one who visits Kanpur visits on Saturday. Based on above given information we have: Again, we have: C neither visits on adjacent day of the one has Yellow nor on adjacent day of F. One person visits between the one who visits Bilaspur and C, who has Red, that means C visits on Monday. There were three days gap between the one who has Pink and the one who visits Bilaspur. G neither has Pink nor he visits before the one who visits Kanpur and he visits Rudrapur. There were two days gap between G and the one who likes White, who visits on adjacent day of the one who has Yellow, that means case (2b) is not valid, in case (1) G visits on Friday, in case (2a) G visits on Saturday.
Case (2b) is not valid as G doesn’t visit before the one who visits Kanpur. Again, we have: The one who has BLACK and D visits on adjacent days. There were three days gap between D and the one who visits Jaipur, that means in case (1) D visits on Wednesday, in case (2) D visits on Friday. Neither D nor B visits Jaipur, that means in case (1) B visits Kanpur. At least three person visits between the one, who visits Rampur and the one, who has Blue, that means case (2a) is not valid. Based on above given information we have final arrangement we have:
Which of the following joins returns all rows from both tables, filling in NULL values for non-matching rows?
What does the term "referential integrity" mean in a database context?
How many types of architecture we have in DBMS
What does the term "normalization" refer to in the context of database design?
In the context of databases, what does the term sharding refer to?
Pick the odd one out.
Which of the following is true about Information?
Which of the following memories has the shortest access times?Â
Which of the following is used to speed up data retrieval in a relational database?
In a relational database, a foreign key is used to: