100% satisfaction guarantee Immediately available after payment Both online and in PDF No strings attached
logo-home
WGU C170 Data Management - Applications Exam Questions With Correct Answers $6.99   Add to cart

Exam (elaborations)

WGU C170 Data Management - Applications Exam Questions With Correct Answers

 9 views  0 purchase
  • Course
  • WGU c170
  • Institution
  • WGU C170

WGU C170 Data Management - Applications Exam Questions With Correct Answers

Preview 2 out of 5  pages

  • October 24, 2024
  • 5
  • 2024/2025
  • Exam (elaborations)
  • Questions & answers
  • WGU c170
  • WGU c170
avatar-seller
Constantina
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

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

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

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)

67866 documents were sold in the last 30 days

Founded in 2010, the go-to place to buy study notes for 14 years now

Start selling
$6.99
  • (0)
  Add to cart