Question
Seven person namely – A, B, C, D, E, F and G are
sitting in a row facing north. Each person likes different colour viz. White, Black, Red, Green, Orange, Yellow and Pink. All the given information are not necessary in same order. One who likes White sits third from right end. E, who doesn’t sit neighbor of one who likes White, sits second to left of one who likes Red. Only three person sits between C and one who likes White. E likes Pink. Only two person sits between D and one who likes Red. How many person sits right of one who likes Yellow? Statement I: B, who neither sits adjacent to one who likes Pink nor one who likes Red, sits second to right of one who likes Black. Only three person sits between one who likes Orange and A, who sits adjacent to E. Statement II: Only two person sits between D and G, who sits with one who likes Black. Only one person sits between one who likes Black and one who likes Green. Each of the questions below consists of a question and two statements numbered I and II given below it. You have to decide whether the data provided in the statements are sufficient to answer the question:Solution
We have: One who likes White sits third from right end. Only three person sits between C and one who likes White, that means C sits at extreme left end. E, who doesn’t sit neighbor of one who likes White, sits second to left of one who likes Red. E likes Pink, that means E sits second from left end.  Only two person sits between D and one who likes Red, that D sits at extreme right end. Based on above given information we have: From Statement I:
Clearly, one person sits immediate right of one who likes Yellow. Hence, statement I and II together sufficient.
Which command removes all rows but keeps table structure?
Which operator is used for pattern matching in SQL?
In PL/SQL, what type of parameter allows a procedure to both receive a value from the calling environment and return a modified value back to it?
ROW_NUMBER() OVER (PARTITION BY dept ORDER BY salary DESC) assigns:
In SQL, the ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW clause applies to:
Which type of index physically reorders the data rows in the table itself based on the index key, meaning the data is stored in the order of the index?
Deadlock in DBMS can be prevented using:
What is an SQL `VIEW`?
Which type of index physically reorders the data rows in the table itself based on the index key, meaning the data is stored in the order of the index?
In PL/SQL, what type of parameter allows a procedure to both receive a value from the calling environment and return a modified value back to it?