Download WGU C175 D426 DATA MANAGEMENT FOUNDATIONS OA and more Exams Nursing in PDF only on Docsity!
1 H/H 18 WGU C175/D426 DATA MANAGEMENT FOUNDATIONS OA EXAM ACTUAL EXAM 2 LATEST VERSIONS 200 QUESTIONS AND CORRECT VERIFIED ANSWERS)/ALREADY GRADED A 1.WhichHrequirementHwithinHlarge,HcomplexHdatabasesHensuresHusersHhave Hlimited Haccess Hto Hthe Hdatabase? Recovery HPerformance HAuthorizatio n Confidentiality:HAuthorization 2.WhichHdesignHtypeHspecifiesHdatabaseHrequirementsHwithoutHregardHtoHa Hspecific Hdatabase Hsystem? Physical Hdesign HConceptualHdesign HLogical Hdesign Abstract Hdesign:HConceptual Hdesign 3.3.HWhat Hcharacterizes Hthe Hrules Hof Hrelational Hdatabases? -They Hare Hlogical Hconstraints Hthat Hensure Hthe Hdata His Hvalid. -TheyHareHbasedHonHbusinessHpolicyHandHspecificHdatabases. -TheyHrepresentHdataHvolumesHandHrapidlyHchangingHdataHstructures. -TheyHembodyHtheHtheoreticalHfoundationHofHtheHSQLHlanguage.:HTheyHareHlogical Hconstraints Hthat Hensure Hthe Hdata His Hvalid. 4.4.HWhichHeventHwillHresultHinHanHerrorHcodeHandHerrorHdescriptionHwhenHusing HMySQL HServer? When Hthe Hserver Hor Hupdates Hare Hincorrectly Hinstalled WhenHanHSQLHstatementHisHenteredHtoHlocateHerrorsHinHtheHdatabase HWhen Han HSQL Hstatement His Hsyntactically Hincorrect WhenHaHMacHOSHshortcutHcodeHisHusedHonHaHWindowsHOS:HWhen Han HSQL Hstatement His Hsyntactically Hincorrect 5.5.HWhichHdataHtypeHshouldHbeHusedHtoHstoreHwholeHintegerHvalues,HsuchHas Hage?
2 H/H 18
NUM
HVARCHA
RHDATE
INT:HINT
6.6.HWhich Htext-based HinterfaceHis Hincluded HinHthe HMySQL HServer HDownload? MySQL HCommand-Line HClient
4 H/H 18
=:HOR
5 H/H 18 13.13.HWhichHoperatorHisHusedHtoHcompareHcolumnsHfromHtheHleftHandHright Htables Hin HMySQL? <=
= *:H= 14.14.HWhich HtypeHof HjoinHcombines HtwoHtables HwithoutHcomparing Hcolumns? SELF HEQUIJOI NHOUTER CROSS:HCROSS 15.15.HWhich Htype Hof Hjoin Hcompares Hcolumns Husing Honly Hthe H= Hoperator? Equijoin HNon- equijoin HOuter Hjoin Inner Hjoin:HEquijoin 16.16.HWhichHtypeHofHjoinHisHdemonstratedHbyHtheHfollowingHquery? HSELECT HDog.Nickname, HKennel.Address FROMHDog,HKennel WHEREHDog.KennelIDH= HKennel.ID NON-EQUIJOIN HSELF HJOIN HCROSS HJOIN EQUIJOIN:HEQUIJOIN 17.17.HWhat His Hanother Hname Hfor Ha Hsubquery? Outer Hquery HNested Hquery HCorrelatedHquery SearchHquery:HNested Hquery 18.18.HWhichHoperatorHisHusedHtoHcompareHagainstHaHlistHofHvaluesHwhen Hdetermining Ha Hmatch Hin HaHWHERE Hclause? IN
7 H/H 18
LIKE
HOR:HIN
19.19.HWhichHwildcardHcharacterHisHusedHtoHrepresentHzeroHorHmoreHcharacters Hwhen Hsearching Hfor Ha Hspecified Hpattern Husing Ha HLIKE Hoperator? % _ < >:H% 20.20.HWhich Hfunction HisHconsidered Han HaggregatingHfunction Hin HSQL? TRIM HREPLAC EHMIN SUBSTRING:HMIN 21.21.HWhichHclauseHorHfunctionHisHusedHwithHaggregateHfunctionsHtoHproduce Hsummary Hrows? TRIM HREPLACE HORDER HBY GROUPHBY:HGROUPHBY 22.22.HWhichHtypeHofHjoinHreturnsHonlyHtheHmatchingHvaluesHwhenHselecting Hrows Hfrom Htwo Hor Hmore Htables? Full HJoin HOuterHJoin HEquijoin InnerHJoin:HInner HJoin 23.23.HWhich HjoinHtypeHselects HonlyHmatching HleftHand HrightHtable Hrows? Full HJoin HLeft HJoin HRightHJoin InnerHJoin:HInner HJoin 24.24.HWhichHphraseHrefersHtoHtheHviewHinHwhichHdataHisHpersistedHandHis Hautomatically Hchanged Has Hthe Hunderlying Hdata His Hchanged? VirtualHView
8 H/H 18 SnapshotHView HDenormalizedHView MaterializedHView:HMaterializedHView 25.25.HWhichHSQLHcommandHusesHtheHcorrectHsyntaxHtoHupdateHtheHsalaryHof Han Hemployee Hin Hthe HEmployee Htable? CHANGE HEmployee HSalary H= H 50000 HWHERE HID H= H1; HUPDATE HEmployeeHSETHSalaryH=H 50000 HWHEREHIDH=H1; HALTER HEmployee HSET HSalary H= H 50000 HWHERE HID H= H1; UPDATEHEmployeeH(Salary)H=H(50000)HWHEREHIDH=H1;:HUPDATEHEmployeeHSET HSalary H= H 50000 HWHERE HID H= H1; 26.26.HWhat Hdescribes Helements Hsuch Has Hcolumn Hname Hand Hdata Htype? Alter HTable HMetadat a CRUD:HMetadata 27.27.HWhichHtermHidentifiesHanHorderedHcollectionHofHelementsHenclosedHin Hparenthesis Hin Ha Htablespace? Cell HField HColum n Tuple:HTuple 28.28.HWhichHSQLHcommandHusesHtheHcorrectHsyntaxHtoHselectHtheHnameHand Hsalary Hcolumns Hfrom Hthe HEmployee Htable Hwhere Hthe Hsalary His Hgreater Hthan H50000, Hand Hsort Hthe Hresults Hby Hsalary Hin Hdescending Horder? -SELECTHname,HsalaryHFROMHEmployeeHWHEREHsalaryH>H 50000 HORDERH+HBY Hsalary HDESC; -SELECTHEmployee.name,HEmployee.salaryHWHEREHEmployee.salaryH>H 50000 HSORT HBY HEmployee.salary HDESC; -SELECTHname,HsalaryHFROMHEmployeeHSORTHBYHsalaryHDESCHWHEREHsalary > H50000; -SELECT Hname,Hsalary HFROM HEmployeeHWHERE Hsalary H> H 50000 HSORT HBY Hsalary HASC;:HSELECTHname,HsalaryHFROMHEmployeeHWHEREHsalaryH>H 50000 HORDER H+ HBY Hsalary HDESC;
10 H/ H 18 INSERTHINTOHtable_nameH(column1,Hcolumn2)HSETHvalue1,Hvalue2; INSERTHINTOHtable_nameHVALUESH(value1,Hvalue2);INSERTHINTOHtable_name H(column1, Hcolumn2)HVALUES H(value1, Hvalue2); INSERTHINTOHtable_nameHSETHcolumn1H=Hvalue1,Hcolumn2H=Hvalue2;:HINSERT HINTO Htable_name H(column1, Hcolumn2) HVALUES H(value1, Hvalue2); 30.30.HWhichHUPDATEHstatementHusesHvalidHsyntaxHinHSQL? UPDATEHtable_nameHcolumn_name=Hvalue1HWHEREHcondition UPDATEHtable_nameHSETHcolumn1H=Hvalue1,Hcolumn2H=Hvalue2HWHEREHcondi- Htion; UPDATEHSETHcolumn1H=Hvalue1,Hcolumn2H=Hvalue2HWHEREHconditionHIN Htable_name; UPDATEHtable_nameHSETHcolumn_nameH=Hvalue1:HUPDATEHtable_nameHSET Hcolumn1 H= Hvalue1, Hcolumn2 H= Hvalue2 HWHERE Hcondition; 31.31.HWhichHstatement HusedHtoHremove HdataHfromHtemporary Htables? DROP HDELETE HDEFAUL T TRUNCATE:HTRUNCATE 32.32.HWhichHkeywordHisHaHDDLH(dataHdefinitionHlanguage)HkeywordHinHSQL? INSERT HUPDATE HDELETE CREATE:HCREATE 33.33.HWhichHpropertyHisHenforcedHbyHaHprimaryHkeyHfield? Not HNull HNull HDuplicate Numeric:HNot HNull 34.34.HWhich Hproperty Hor Hfunction Hallows HSQL Hto Hinsert Ha Hfield Hvalue? Composite HSimple Auto-increment HNumeric:HAuto-
11 H/ H 18 increment
13 H/ H 18 One-to-many Many-to-many: H One-to-many 41.41.HWhichHstatementsHmayHbeHrejectedHwhenHaHforeignHkeyHconstraintHis Hspecified? INSERT HCHECK HSELEC T ORDER HBY:HINSERT 42.42.HWhichHkeyHdescribesHtheHuniqueHcolumnsHinHaHtableHthatHdoHnotHcontain Ha Hprimary Hkey? Foreign Hkey HSimple Hkey HCandidateHkey CompositeHkey:HCandidate Hkey 43.43.HWhichHindexHstoresHcolumnHvaluesHandHrowHpointersHinHaHhierarchy? Dense Hindex HSparse Hindex HMulti-levelHindex SecondaryHindex:HMulti-levelHindex 44.44.HWhich HtypeHof HindexHrefers HtoHentries Hthat Hare HassignedHto Hbuckets? Bitmap Hindex HLogical Hindex HHash Hindex Secondary Hindex:HHash Hindex 45.45. HWhich Htype Hof Hindex His Ha Hgrid Hof Hbits Hwhere Heach Hindex Hrow Hcorresponds Hto Ha Hunique Hrow Hin Ha Htable? Multi-levelHindex HLogical Hindex HHash Hindex BitmapHindex:HBitmap Hindex 46.46.HWhichHtypeHofHdevelopmentHactivityHisHusedHtoHconvertHanHentity-rela- Htionship Hmodel H(ERM) Hinto Htables, Hcolumns, Hand Hkeys?
14 H/ H 18 Execution
16 H/ H 18 Ternary Many-to-many HOne-to-one One-to-many:HOne-to-many 53.53.HWhichHrelationshipHorHassociationHexistsHbetweenHaHsupertypeHentity Hand Hits Hsubtype Hentities? IsA Hrelationship HWeak Hentity HAssociativeHentity Unary Hrelationship:HIsA Hrelationship 54.54.HWhichHsymbolHisHusedHinHanHentity-relationshipH(ER)HdiagramHforHan Hentity? Diamond HSquare HCircle Line:HSquare 55.55.HWhichHsymbolHisHusedHinHanHentity-relationshipH(ER)HdiagramHtoHindicate Han Hattribute? Diamond HSquare HCircle HLine: HCircle 56.56.HWhat Hmust Hbe Hdone Hbefore Hcreating Hsupertype Hand Hsubtype Hentities? Identify Hentities. Document Hentities. Determine Hattribute Hmaxima. HDocument Hcardinality:HIdentifyHentities. 57.57.HWhichHreal-worldHobjectHcanHbeHdistinctlyHidentifiedHandHgrouped,Hsuch Has Hall Hemployees Hin Ha Hcompany? Entity-relationshipH(ER)Hdiagram HGlossary Entity
17 H/ H 18 AttributeHtype:HEntity
