ExaminethestructureoftheEMPLOYEEStable: Youissuethesestatements: Attheendofthistransaction,whatistrue?() A: Youhavenorowsinthetable. B: YouhaveanemployeewiththenameofJames. C: Youcannotrollbacktothesamesavepointmorethanonce. D: YourlastupdatefailstoupdateanyrowsbecauseemployeeID180wasalreadyeleted.
ExaminethestructureoftheEMPLOYEEStable: Youissuethesestatements: Attheendofthistransaction,whatistrue?() A: Youhavenorowsinthetable. B: YouhaveanemployeewiththenameofJames. C: Youcannotrollbacktothesamesavepointmorethanonce. D: YourlastupdatefailstoupdateanyrowsbecauseemployeeID180wasalreadyeleted.
ExaminethestructureoftheEMPLOYEEStable: EMPLOYEE_IDNUMBERPrimaryKey FIRST_NAMEVARCHAR2(25) LAST_NAMEVARCHAR2(25) HIRE_DATEDATE Youissuethesestatements: CREATEtablenew_emp(employee_idNUMBER,nameVARCHAR2(30));INSERTINTOnew_empSELECTemployee_id,last_namefromemployees; Savepoints1; UPDATEnew_empsetname=UPPER(name); Savepoints2; Deletefromnew_emp; Rollbacktos2; Deletefromnew_empwhereemployee_id=180; UPDATEnew_empsetname='James'; Rollbacktos2; UPDATEnew_empsetname='James'WHEREemployee_id=180; Rollback; Attheendofthistransaction,whatistrue?() A: Youhavenorowsinthetable. B: YouhaveanemployeewiththenameofJames. C: Youcannotrollbacktothesamesavepointmorethanonce. D: YourlastupdatefailstoupdateanyrowsbecauseemployeeID180wasalreadydeleted.
ExaminethestructureoftheEMPLOYEEStable: EMPLOYEE_IDNUMBERPrimaryKey FIRST_NAMEVARCHAR2(25) LAST_NAMEVARCHAR2(25) HIRE_DATEDATE Youissuethesestatements: CREATEtablenew_emp(employee_idNUMBER,nameVARCHAR2(30));INSERTINTOnew_empSELECTemployee_id,last_namefromemployees; Savepoints1; UPDATEnew_empsetname=UPPER(name); Savepoints2; Deletefromnew_emp; Rollbacktos2; Deletefromnew_empwhereemployee_id=180; UPDATEnew_empsetname='James'; Rollbacktos2; UPDATEnew_empsetname='James'WHEREemployee_id=180; Rollback; Attheendofthistransaction,whatistrue?() A: Youhavenorowsinthetable. B: YouhaveanemployeewiththenameofJames. C: Youcannotrollbacktothesamesavepointmorethanonce. D: YourlastupdatefailstoupdateanyrowsbecauseemployeeID180wasalreadydeleted.
ExaminethestructureoftheEMPLOYEEStable: EMPLOYEE_IDNUMBERPrimaryKey FIRST_NAMEVARCHAR2(25) LAST_NAMEVARCHAR2(25) HIRE_DATEDATE Youissuethesestatements: CREATEtablenew_emp(employe_idNUMBER,nameVARCGAR2(30));INSERTINTOnew_empSELECTemployee_id,last_namefromemployees;Savepoints1; UPDATEnew_empsetname=UPPER(name); Savepoints2; Deletefromnew_emp; Rollbacktos2; Deletefromnew_empwhereemployee_id=180; UPDATEnew_empsetname='James'; Rollbacktos2; UPDATEnew_empseyname='James'Whereemployee_id=180; Rollback; Attheendofthistransaction,whatistrue?() A: Youhavenorowsinthetable. B: YouhaveanemployeewiththenameofJames. C: Youcannotrollbacktothesamesavepointmorethanonce. D: YourlastupdatefailstoupdateanyrowsbecauseemployeeID180wasalreadydeleted.
ExaminethestructureoftheEMPLOYEEStable: EMPLOYEE_IDNUMBERPrimaryKey FIRST_NAMEVARCHAR2(25) LAST_NAMEVARCHAR2(25) HIRE_DATEDATE Youissuethesestatements: CREATEtablenew_emp(employe_idNUMBER,nameVARCGAR2(30));INSERTINTOnew_empSELECTemployee_id,last_namefromemployees;Savepoints1; UPDATEnew_empsetname=UPPER(name); Savepoints2; Deletefromnew_emp; Rollbacktos2; Deletefromnew_empwhereemployee_id=180; UPDATEnew_empsetname='James'; Rollbacktos2; UPDATEnew_empseyname='James'Whereemployee_id=180; Rollback; Attheendofthistransaction,whatistrue?() A: Youhavenorowsinthetable. B: YouhaveanemployeewiththenameofJames. C: Youcannotrollbacktothesamesavepointmorethanonce. D: YourlastupdatefailstoupdateanyrowsbecauseemployeeID180wasalreadydeleted.
PartC<br/>Directions:<br/><em>Readthefollowingtextsfromwhichfivesentenceshavebeenremoved.ChoosefromthesentencesA</em><em>—Gthemostsuitableonetofilleachnumberedgapinthetext(41—45).ThereareTWOextrasentencesthatyoudonotneedtouse.MarkyouranswersonyourANSWERSHEET.</em><br/>Humorandlaughteraregoodforus.Thereisincreasingevidencethattheycanhealusphysically,mentally,emotionally,andspiritually.Infacteverysystemofthebodyrespondstolaughterinsomepositive,healingway.Sohowcanwegetmorelaughterintoourlives?(41)______Psychologistandauthor,SteveWilson,hassomeanswers.<br/>Manypeoplebelievethatwearebornwithasenseofhumor.Theythink,“eitheryou’vegotit,oryoudon’t.”Dr.Wilsonpointsoutthatthisisfalse.(42)______<br/>Thepartsofthebrainandcentralnervoussystemthatcontrollaughingandsmilingarematureatbirth.(43)______(Afterall,whenababylaughs,wedon’trushoverandsay,“Thatkidhasagreatsenseofhumor!”)Asenseofhumorissomethingthatyoucandevelopoveralifetime.<br/>Sometimespeoplethinkthattheydon’thaveagoodsenseofhumorbecausetheyarenotgoodjoketellers.Dr.Wilsonremindsusthattellingjokesisonlyoneofmanywaystoexpresshumor.(44)______Thenwewillmakeotherslaugh,too.<br/>Apersonwhohasatruesenseofhumoriswillingandabletoseethefunnysideofeverydaylife.Oneofthebestdefinitionsofasenseofhumoris“theabilitytoseethenonseriouselementinasituation.”Considerthissignfromastorywindow:“Anyfaultymerchandisewillbecheerfullyreplacedwithmerchandiseofequalquality.”Thestoremanagerprobablyplacedthesigninthewindowtoimpresscustomerswiththestore’sexcellentservice.(45)______AsDr.Wilsonsays,“agoodsenseofhumormeansthatyoudon’thavetobefunny:youjusthavetoseewhat’sfunny.”<br/>[A]Everyoneexperiencesthisemotion.<br/>[B]Isitpossibletodevelopasenseofhumor?<br/>[C]Headvisesustoloseourinhibitions(抑制)andtrytolaughatourselves.<br/>[D]However,thatdoesnotmeanthatinfantshaveasenseofhumor.<br/>[E]Whatistrue,however,isthatwearebornwiththecapacitytolaughandsmile.<br/>[F]Hehadaseriouspurpose,butifyouhaveasenseofhumor,youwillprobablyfindthesignfunny!<br/>[G]Humorisasignofwisdomandintelligence.
PartC<br/>Directions:<br/><em>Readthefollowingtextsfromwhichfivesentenceshavebeenremoved.ChoosefromthesentencesA</em><em>—Gthemostsuitableonetofilleachnumberedgapinthetext(41—45).ThereareTWOextrasentencesthatyoudonotneedtouse.MarkyouranswersonyourANSWERSHEET.</em><br/>Humorandlaughteraregoodforus.Thereisincreasingevidencethattheycanhealusphysically,mentally,emotionally,andspiritually.Infacteverysystemofthebodyrespondstolaughterinsomepositive,healingway.Sohowcanwegetmorelaughterintoourlives?(41)______Psychologistandauthor,SteveWilson,hassomeanswers.<br/>Manypeoplebelievethatwearebornwithasenseofhumor.Theythink,“eitheryou’vegotit,oryoudon’t.”Dr.Wilsonpointsoutthatthisisfalse.(42)______<br/>Thepartsofthebrainandcentralnervoussystemthatcontrollaughingandsmilingarematureatbirth.(43)______(Afterall,whenababylaughs,wedon’trushoverandsay,“Thatkidhasagreatsenseofhumor!”)Asenseofhumorissomethingthatyoucandevelopoveralifetime.<br/>Sometimespeoplethinkthattheydon’thaveagoodsenseofhumorbecausetheyarenotgoodjoketellers.Dr.Wilsonremindsusthattellingjokesisonlyoneofmanywaystoexpresshumor.(44)______Thenwewillmakeotherslaugh,too.<br/>Apersonwhohasatruesenseofhumoriswillingandabletoseethefunnysideofeverydaylife.Oneofthebestdefinitionsofasenseofhumoris“theabilitytoseethenonseriouselementinasituation.”Considerthissignfromastorywindow:“Anyfaultymerchandisewillbecheerfullyreplacedwithmerchandiseofequalquality.”Thestoremanagerprobablyplacedthesigninthewindowtoimpresscustomerswiththestore’sexcellentservice.(45)______AsDr.Wilsonsays,“agoodsenseofhumormeansthatyoudon’thavetobefunny:youjusthavetoseewhat’sfunny.”<br/>[A]Everyoneexperiencesthisemotion.<br/>[B]Isitpossibletodevelopasenseofhumor?<br/>[C]Headvisesustoloseourinhibitions(抑制)andtrytolaughatourselves.<br/>[D]However,thatdoesnotmeanthatinfantshaveasenseofhumor.<br/>[E]Whatistrue,however,isthatwearebornwiththecapacitytolaughandsmile.<br/>[F]Hehadaseriouspurpose,butifyouhaveasenseofhumor,youwillprobablyfindthesignfunny!<br/>[G]Humorisasignofwisdomandintelligence.