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

Quiz

SDP 6 (2)

хомяк убийца 141 Fragen 1.070 Aufrufe 5,0 (1 Bewertung)

Quiz starten

Fragen in diesem Quiz (141)

  1. 1The ___________ R S keeps tuple in the first {left} relation R; if no matching tuple found in S, then the attribute of S in the join are filled with NULL values
    1. Ao LEFT OUTER JOIN
    2. Bo RIGHT OUTER JOIN
    3. Co FULL OUTER JOIN
    4. Do LEFT INNER JOIN
  2. 2If a relation schema has more than one key, each is called a _______ key.
    1. Ao Candidate
    2. Bo Primary
    3. Co Public
    4. Do Foreign
  3. 3A _________conflict arises when an attribute may have different domains in two schemas, e.g. pounds vs kilograms
    1. Ao Domain
    2. Bo Type
    3. Co Norming
    4. Do Constraints
  4. 4UML _________ diagrams describe the dynamic relationships among components
    1. Ao Behavioral
    2. Bo Structural
    3. Co Class
    4. Do Direct
  5. 5Objects in an object-oriented programming language exist only during program execution, therefore they are called transient objects; an object-oriented database can extend the existence of objects so that they are stored permanently, therefore they are called
    1. Ao persistent object
    2. Bo instance variable
    3. Co attribute
    4. Do object structure
  6. 6_____ is the term used to refer to the problems that occur because of difference between the database model and the programming language model.
    1. Ao Independence mismatch
    2. Bo Denormalisation
    3. Co Redundancy
    4. Do Duplication
  7. 7A __________________ is typically used to loop over the tuples in a query result
    1. Ao Cursor {iterator variable}
    2. Bo Shared variable
    3. Co Communication variables
    4. Do fetch
  8. 8NULL values may mean value unknown, value exists but isn't available, and attribute does not apply to this tuple (value undefined)
    1. ARichtig
    2. BFalsch
  9. 9A THETA JOIN uses any of the comparison operators =,<,> or (not equal)
    1. ARichtig
    2. BFalsch
  10. 10For structured data, the schema information is mixed in with the data values, so it is sometimes referred to as self-describing data
    1. ARichtig
    2. BFalsch

Informationen

Beschreibung
- at Quiz am SDP 6 (2), erstellt von хомяк убийца am 17/12/2017.
Sprache
English
Aufrufe
1.070
Schlagwörter
at-
Bewertung
5,0 von 5 · 1 Bewertung
Bewerte dieses Quiz
Bewerte dieses Quiz

Feedback

Worum geht es?

Wie gefällt dir das neue Design?

Dein Eindruck