C170 WGU
DMLbn-bnanswers--IUDS,bnCR
insert,bnupdate,bndelete,bnselect
commit,bnrollback
INSERTbn-bnanswers--addbnnewbnrows
UPDATEbn-bnanswers--modifybndatabnofbnexistingbnrows
DELETEbn-bnanswers--deletebnsome/allbnrecordsbnfrombndatabase
canbnbebnrolledbnback
COMMITbn-bnanswers--permanentlybnsaves
ROLLBACKbn-bnanswers--undobnchanges
SELECTbn-bnanswers--databnretrieval
WHEREbn-bnanswers--limitsbnrowsbnreturned
usedbnbeforebngroupbnby
, ORDERbnBYbn-bnanswers--OC
sortsbncolumns
GROUPbnBYbn-bnanswers--GR
groupsbnrows
BETWEENbn-bnanswers--withinbnrange
ISbnNULLbn-bnanswers--valuebnisbnnull
LIKEbn-bnanswers--valuebnmatchesbnstringbnpattern
INbn-bnanswers--checksbnvaluebnifbnitbnmatchesbngivenbnvaluebnlist
EXISTSbn-bnanswers--checksbnifbnsubquerybnreturnsbnanybnrows
COUNTbn-bnanswers--tallybnamountbnofbnNON-NULLbnvalues
SUMbn-bnanswers--totalbnsumbnforbnspecifiedbnattribute
HAVINGbn-bnanswers--filtersbnthebngroupsbnsubjectbntobnsomebncondition
usedbnafterbngroupbnby
innerbnjoinbn-bnanswers--onlybnrowsbnthatbnmeetbncriteriabnselected
DMLbn-bnanswers--IUDS,bnCR
insert,bnupdate,bndelete,bnselect
commit,bnrollback
INSERTbn-bnanswers--addbnnewbnrows
UPDATEbn-bnanswers--modifybndatabnofbnexistingbnrows
DELETEbn-bnanswers--deletebnsome/allbnrecordsbnfrombndatabase
canbnbebnrolledbnback
COMMITbn-bnanswers--permanentlybnsaves
ROLLBACKbn-bnanswers--undobnchanges
SELECTbn-bnanswers--databnretrieval
WHEREbn-bnanswers--limitsbnrowsbnreturned
usedbnbeforebngroupbnby
, ORDERbnBYbn-bnanswers--OC
sortsbncolumns
GROUPbnBYbn-bnanswers--GR
groupsbnrows
BETWEENbn-bnanswers--withinbnrange
ISbnNULLbn-bnanswers--valuebnisbnnull
LIKEbn-bnanswers--valuebnmatchesbnstringbnpattern
INbn-bnanswers--checksbnvaluebnifbnitbnmatchesbngivenbnvaluebnlist
EXISTSbn-bnanswers--checksbnifbnsubquerybnreturnsbnanybnrows
COUNTbn-bnanswers--tallybnamountbnofbnNON-NULLbnvalues
SUMbn-bnanswers--totalbnsumbnforbnspecifiedbnattribute
HAVINGbn-bnanswers--filtersbnthebngroupsbnsubjectbntobnsomebncondition
usedbnafterbngroupbnby
innerbnjoinbn-bnanswers--onlybnrowsbnthatbnmeetbncriteriabnselected