Question
Which of the following statement is true with respect
to F? Answer the questions based on the information given below. Eight persons A, B, C, D, E, F, G and H live on different floors of aneight-storey building, where the bottommost floor is 1 and the floor above it is 2 and so on. They all have different genders i.e. male and female. Not more than two persons of same genders live on adjacent floors.Number of males is more than that of the number of females. Three persons live between D and the one who lives two floors above B, who is male. B doesn’t live above the 4th floor. A lives two floors below C, neither of them lives adjacent to D and B. D lives above C. The one who lives on the 2nd floor from the top is female. The number of person lives above G is one more than the number of person lives below E. At most two people live above G. Neither A nor G is female. D doesn’t live adjacent to E. H lives above F, who is male.Solution
Three persons live between D and the one who lives two floors above B, who is male. B doesn’t live above 4th A lives two floors below C, neither of them lives adjacent to D nor B. The one who live on 2nd floor from the top is female. 
The number of persons lives above G is one more than the number of persons lives below E. Neither A nor G is female. At most two people live above G. D doesn’t sit adjacent to E. D lives above C. H lives above F, who is male. 
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?
Relevant for Exams:
