7. Assume there is a payment history table with a column cal…
7. Assume there is a payment history table with a column called payment_type that indicates if a payment is regular salary, a bonus, or an award. What question does this correlated query answer? Begin your answer with “This query answers the question: who are the employees…” SELECT employee_id, first_name, last_nameFROM employees e1WHERE NOT EXISTS (SELECT ph.lastname FROM payment_history ph WHERE ph.emp_id = e1.employee_idAND ph.payment_type =’award’)
Read Details41. Owen is the owner of a fee simple in a house in the…
41. Owen is the owner of a fee simple in a house in the city of Danville and makes a valid inter vivos conveyance with this language: “I, Owen, convey my house in Danville, to Adam for life, then to Adam’s first child to reach 25.” Adam has no children. Assume in the relevant jurisdiction that the common law Rule Against Perpetuities applies to conveyances and wills and that the doctrine of destructibility of contingent remainders is abolished. At the time of the conveyance, Adam’s first child’s interest is best described as:
Read Details19. Owen wants to gift his house in the City of Overlan…
19. Owen wants to gift his house in the City of Overland, which he owns in fee simple, to his daughter, Linda, but he wants Linda to be more mature enough before giving her the property. Therefore, Owen conveys the following interests in a valid inter vivos conveyance: “I give my house in Overland to Linda when she turns 21.” After the conveyance, Linda’s future interest is best described as:
Read Details9. Owner owns Blackacre and took a mortgage from Bank…
9. Owner owns Blackacre and took a mortgage from Bank of New Public (BNP) that was validly recorded. Six months later, Owner took a second mortgage from First Finance Company (FFC) that was validly recorded. Owner then failed to make mortgage payments to FFC, but Owner’s payments to BNP are current. The outstanding loan balance on each mortgage is equal. If BNP forecloses, which of the following statements is most likely to be accurate?
Read Details22. Olson, owner in fee simple of a property with a bak…
22. Olson, owner in fee simple of a property with a bakery called Hot Cross Buns Bakery, creates a valid inter vivos instrument with the following language: “I give David my entire interest in Hot Cross Buns Bakery, provided that he does not use raisins in the bread.” What, if any, future interest is created by this conveyance?
Read Details5. Owen is married to Ariel and they have two children, Beth…
5. Owen is married to Ariel and they have two children, Beth and Cal, age 3 and 4. Owen owns Blackacre in fee simple and creates a valid will with the following language: “I grant Blackacre to my wife, Ariel, for her life; then to my daughter, Beth, for her life; then to my grandchildren who reach 21.” Assume in the relevant jurisdiction that the common law rule against perpetuities applies to conveyances and wills and that the doctrine of destructibility of contingent remainders is abolished. After Owen’s death, the future interest in Owen’s grandchildren who reach 21 is best characterized as:
Read Details20. Owen owns Blueacre in fee simple and then conveys…
20. Owen owns Blueacre in fee simple and then conveys Blueacre in a valid deed using the following language: “I grant my home to Angel for life, then to Betty if Angel dies without issue from his wife Betty, but if Angel dies with issue from his wife Betty, then to Candy.” Angel never has children with Betty and dies two years after Owen’s deed. Assume in the relevant jurisdiction that the doctrine of destructibility of contingent remainders is abolished.Who owns the property after Angel’s death?
Read Details16. John has a fee simple absolute in a lot with a flow…
16. John has a fee simple absolute in a lot with a flower shop called Green Shop. He conveys the following interests in a valid inter vivos conveyance: “I give Paul the Green Shop on the condition that the Green Shop continues to be operated as a flower shop and reserve my rights to the lot if Green Shop ever does not continue to be operated as a flower shop.” What is most correct statement describing Paul’s interest in the Green Shop?
Read Details