Question
Who among the following lives immediately below H’s
floor? Study the following information carefully and answer the questions given below. Nine persons – A, B, C, D, E, F, G, H and I – are living on the same building such as ground floor is numbered as 1, just above it is floor 2, then the top floor is numbered as 9 but not necessarily in the same order. The following information is known about them. Only two persons live between C’s floor and B’s floor. Neither C nor H lives on an odd-numbered floor. The person who lives immediately above B lives three floors above F. There is only one floor between H’s floor and D’s floor. The number of floors above D is the same as the number of floors below G. At least one person lives between B and H. The number of floors between G and F is the same as the number of floors between E and D. A lives below I but above ESolution
 Only two persons live between C’s floor and B’s floor. Neither C nor H lives on an odd-numbered floor. The person who lives immediately above B lives three floors above F. 
The number of floors between G and F is the same as the number of floors between E and D. A lives below I but above E. This eliminates case 4. 
Which type of join returns rows when there is a match in both tables?
Which SQL constraint ensures that a column cannot have NULL values?
A software defect that causes a program to produce incorrect output without crashing or displaying an error message is typically classified as a:Â
A system is in a safe state when:
A transaction that reads a value then later sees a different value because another transaction updated and committed in between experiences which anomaly?
Which of the following is a type of database index?
Which of the following is used to enforce referential integrity?
Which constraint ensures that a column contains only unique values, but allows NULL values?
In two-phase locking, a transaction releases its locks:
Which of the following illustrates an advantage of DBMS over traditional file systems?
Relevant for Exams:
