Practice Test Geeks(1Z0-006) Oracle Database Foundations Associate Practice Test
← All 1Z0-006 Flashcard Decks

Data Modeling Flashcards

7 cards from real 1Z0-006 practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.

Read the first 7 Data Modeling flashcards as text

  1. Which of the following is an example of a multivalued attribute in an ERD?

    Answer: Employee's phone numbers (can have several)

    A multivalued attribute can hold more than one value for a single entity instance, such as an employee having multiple phone numbers.

  2. In Third Normal Form (3NF), which type of dependency must be eliminated?

    Answer: Transitive dependency of a non-key attribute on another non-key attribute

    3NF requires that no non-key attribute depends on another non-key attribute (transitive dependency); all non-key attributes must depend directly on the primary key.

  3. What distinguishes a physical data model from a logical data model?

    Answer: A physical model includes specific DBMS data types, indexes, and storage details

    A physical data model extends the logical model with DBMS-specific details such as data types, indexes, tablespaces, and partitioning strategies.

  4. An EMPLOYEE entity has a 'Years_of_Service' attribute that is always calculated from 'Hire_Date'. What type of attribute is 'Years_of_Service'?

    Answer: Derived attribute

    A derived attribute is one whose value is computed from other stored attributes and is typically shown with a dashed oval in ERDs.

  5. Which constraint ensures that a foreign key value in a child table must match an existing primary key value in the parent table?

    Answer: Referential integrity constraint

    Referential integrity ensures that a foreign key either matches a primary key in the referenced table or is NULL, preventing orphaned records.

  6. In conceptual data modeling, what is the primary goal?

    Answer: Capture business concepts and rules independent of any technology

    A conceptual model captures high-level business entities, relationships, and rules without concern for how data will be physically stored or which DBMS will be used.

  7. What does cardinality specify in a data model?

    Answer: The number of instances of one entity that can relate to instances of another entity

    Cardinality defines the numerical relationship between entity occurrences, such as one-to-one, one-to-many, or many-to-many.