GoConqr hat ein neues Design! Sag uns, wie es dir gefällt.

Kostenlos registrieren

Quiz

Data Architecture

Brandon Gagon 20 Fragen

Quiz starten

Fragen in diesem Quiz (20)

  1. 1The entity integrity rule requires that ____.
    1. Aall primary key entries are unique
    2. Ba part of the key may be null
    3. Cforeign key values do not reference primary key values
    4. Dduplicate object values are allowed
  2. 2The referential integrity rule requires that ____.
    1. Aevery null foreign key value must reference an existing primary key value
    2. Ban attribute have a corresponding value
    3. Cevery non-null foreign key value reference an existing primary key value
    4. Dyou delete a row in one table whose primary key does not have a matching foreign key value in another table
  3. 3The ____ depicts the arrangement of higher-level entity supertypes (parent entities) and lower-level entity subtypes (child entities).
    1. Asubtype discriminator
    2. Binheritance
    3. Cspecialization hierarchy
    4. Dentity supertype
  4. 4Every subtype can have ____ supertype to which it is directly related.
    1. Anone
    2. Bonly one
    3. Cone or many
    4. Dmany
  5. 5Every subtype can have ____ supertype to which it is directly related.
    1. Anone
    2. Bonly one
    3. Cone or many
    4. Dmany
  6. 6A specialization hierarchy can have ____ levels of supertype/subtype relationships.
    1. Anone
    2. Bonly one
    3. Cone or many
    4. Dmany
  7. 7The property of ____ enables an entity subtype to inherit the attributes and relationships of the supertype.
    1. Asubtype discriminator
    2. Binheritance
    3. Cspecialization hierarchy
    4. Dentity supertype
  8. 8One important inheritance characteristic is that all entity subtypes inherit their ____ attribute from their supertype.
    1. Aprimary key
    2. Bnatural key
    3. Cforeign key
    4. Dsurrogate key
  9. 9What feature is a DDBMS disadvantage?
    1. AProcessor independence
    2. BUser-friendly interface
    3. CSecurity
    4. DFaster data access
  10. 10What feature is a DDBMS advantage?
    1. AReduced operating cost
    2. BComplexity of management and control
    3. CIncreased storage requirements
    4. DIncreased training cost

Informationen

Beschreibung
Data Architecture
Sprache
English
Aufrufe
240
Bewertung
Noch keine Bewertungen
Bewerte dieses Quiz
Bewerte dieses Quiz

Feedback

Worum geht es?

Wie gefällt dir das neue Design?

Dein Eindruck