Exam (elaborations)
WGU C170 Data Management - Applications Exam Questions With Correct Answers
- Course
- Institution
WGU C170 Data Management - Applications Exam Questions With Correct Answers
[Show more]
Content preview
WGU C170 Data Management -Applications Exam Questions With
Correct Answers
domain c- ccorrect canswers✔✔In cdata cmodeling, cthe cconstruct cused cto corganize cand
cdescribe can cattribute's cset cof cpossible cvalues
superkey c- ccorrect canswers✔✔An cattribute cor cattributes cthat cuniquely cidentify ceach
centity cin ca ctable. cAny ccomposite ckey cwith cthis cis calso cthis.
candidate ckey c- ccorrect canswers✔✔A cminimal csuperkey; cthat cis, ca ckey cthat cdoes
cnot ccontain ca csubset cof cattributes cthat cis citself ca csuperkey
entity cintegrity c- ccorrect canswers✔✔The cproperty cof ca crelational ctable cthat
cguarantees ceach centity chas ca cunique cvalue cin ca cprimary ckey cand cthat cthe ckey
chas cno cnull cvalues
referential cintegrity c- ccorrect canswers✔✔A ccondition cby cwhich ca cdependent ctable's
cforeign ckey cmust chave ceither ca cnull centry cor ca cmatching centry cin cthe crelated
ctable
data cdictionary c- ccorrect canswers✔✔A cDBMS ccomponent cthat cstores cmetadata. cIt
ccontains cthe cdata cdefinition c& ctheir ccharacteristics cand crelationships; cmay calso
cinclude cdata cexternal cto cthe cDBMS
system ccatalog c- ccorrect canswers✔✔A cdetailed csystem cdata cdictionary cthat
cdescribes call cobjects cin ca cdatabase
homonym c- ccorrect canswers✔✔The cuse cof cthe csame cname cto clabel cdifferent
cattributes, cmuch clike csimilar-sounding cwords cwith cdifferent cmeanings
synonym c- ccorrect canswers✔✔The cuse cof cdifferent cnames cto cidentify cthe csame
cobject, csuch cas can centity, can cattribute, cor ca crelationship. cThese cshould cgenerally
cbe cavoided.
not cnull cand cunique c- ccorrect canswers✔✔Any ccandidate ckey cmust chave cthese ctwo
cconstraints cenforced
cardinality c- ccorrect canswers✔✔Term cfor chow cmany cinstances cof cone cobject care
crelated cto cinstances cof canother cobject c(maximum)
, modality c- ccorrect canswers✔✔Term cfor cwhether can cinstance cof ca cspecific centity cis
coptional cor cmandatory cin ca crelationship c(minimum)
connectivity c- ccorrect canswers✔✔Term cfor cthe cclassification cof cthe crelationship
cbetween centities. cClassifications cinclude c1:1, c1:M, cand cM:N
CREATE cSCHEMA cAUTHORIZATION c- ccorrect canswers✔✔SQL ccommand cto
ccreate ca cdatabase cschema
DEFAULT c- ccorrect canswers✔✔SQL coption cto cdefine ca cdefault cvalue cfor ca ccolumn
c(when cno cvalue cis cgiven)
CHECK c- ccorrect canswers✔✔SQL ccommand cto cvalidate cdata cin can cattribute, cused
cduring ctable ccolumn ccreation
CREATE cTABLE cAS c- ccorrect canswers✔✔SQL ccommand cto ccreate ca cnew ctable
cbased con ca cquery cin cthe cuser's cdatabase cschema
HAVING c- ccorrect canswers✔✔SQL coption cthat crestricts ca cselection cof cgrouped
crows cbased con ca ccondition
EXISTS c- ccorrect canswers✔✔SQL coption cthat cchecks cwhether ca csubquery creturns
cany crows
DECIMAL c- ccorrect canswers✔✔SQL cdata ctype clike cthe cNUMBER cspecification, cbut
cthe cstorage clength cis ca cminimum cspecification
True c- ccorrect canswers✔✔True cor cfalse: cif can cINSERT cor cSELECT ccommand cis
cembedded cinside ca cprogram cfor clater cuse, cthe cattribute clist cshould calways cbe
cused, cas cthe ctable cmay cchange cover ctime
inner cjoin c- ccorrect canswers✔✔A cjoin coperation cin cwhich conly crows cthat cmeet ca
cgiven ccriterion care cselected. cThe cmost ccommon ctype cof cjoin
outer cjoin c- ccorrect canswers✔✔A cjoin coperation cthat cproduces ca ctable cin cwhich call
cunmatched cpairs care cretained; cunmatched cvalues cin cthe crelated ctable care cleft cnull
cross cjoin c- ccorrect canswers✔✔A cjoin coperation cthat creturns cthe cCartesian cproduct
cof ctwo csets cor ctables
natural cjoin c- ccorrect canswers✔✔Join ctype cthat creturns conly cthe crows cwith
cmatching cvalues cin cthe cmatching ccolumns; cthe cmatching ccolumns cmust chave cthe
csame cnames cand csimilar cdata ctypes
left, cright, cfull c- ccorrect canswers✔✔Name cthe cthree ctypes cof couter cjoins
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller Constantina. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $6.99. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
80467 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now