Langsung ke konten utama

Section 5 Quiz Database Design Oracle

Gambar
Oleh
Section 5 Quiz
            (Answer all questions in this section)
1.         Relationships can be Redundant. True or False?          Mark for Review
(1) Points
            True (*)
            False

2.         If two entities have two relationships between them, these relationships can be either _____________ or _____________ .        Mark for Review
(1) Points
            Redundant and Replicated
            Resourced and Really Good
            Redundant or Required (*)
            Replicated or Required

3.         What uncommon relationship is described by the statements: "Each DNA SAMPLE may be taken from one and only one PERSON and each PERSON may provide one and only one DNA SAMPLE"        Mark for Review
(1) Points
            One to One Optional (*)
            Many to Many Mandatory
            One to Many Mandatory
            One to Many Optional

4.         What relationship is described by the statements: "Each CUSTOMER may place one or more ORDERs, each ORDER must be placed by one and only one CUSTOMER"       Mark for Review
(1) Points
            One to Many (*)
            Many to Many
            Many to More
            One to One

5.         If the same relationship is represented twice in an Entity Relationship Model, it is said to be: Mark for Review
(1) Points
            Replicated
            Redundant (*)
            Removable
            Resourceful

6.         A non-transferable relationship is represented by which of the following symbols?   Mark for Review
(1) Points
            Diamond (*)
            Heart
            Triangle
            Circle

7.         If a relationship can NOT be moved between instances of the entities it connects, it is said to be:      Mark for Review
(1) Points
            Mandatory
            Non-Transferable (*)
            Optional
            Transferable

8.         Every ERD must have at least one non-transferable relationship. True or False?         Mark for Review
(1) Points
            True
            False (*)

9.         Non-transferable relationships can only be mandatory, not optional. True or False?   Mark for Review
(1) Points
            True
            False (*)

10.       Which of the following is an example of a non-transferable relationship        Mark for Review
(1) Points
            PERSON to BIRTH PLACE (*)
            EMPLOYEE to DEPARTMENT
            TEACHER to SCHOOL
            STUDENT to COURSE

11.       When you resolve a M:M by creating an intersection entity, this new entity will always inherit:         Mark for Review
(1) Points
            The attributes of both related entities.
            The UID's from the entities in the original M:M.
            Nothing is inherited from the original entities and relationship.
            A relationship to each entity from the original M:M. (*)

12.       What do you call the entity created when you resolve a M:M relationship?     Mark for Review
(1) Points
            M:M entity
            Intersection entity (*)
            Inclusion entity
            Recursive entity

13.       Intersection Entities often have the relationships participating in the UID, so the relationships are often barred. True or False?  Mark for Review
(1) Points
            True (*)
            False

14.       When you resolve a M:M, you simply re-draw the relationships between the two original entities; no new entities are created. True or False?       Mark for Review
(1) Points
            True
            False (*)

15.       A relationship on an ERD can have attributes. True or False? Mark for Review
(1) Points
            True
            False (*)

1.         If a relationship can NOT be moved between instances of the entities it connects, it is said to be:      Mark for Review
(1) Points
            Non-Transferable (*)
            Optional
            Transferable
            Mandatory

2.         Every ERD must have at least one non-transferable relationship. True or False?         Mark for Review
(1) Points
            True
            False (*)

3.         If a relationship can be moved between instances of the entities it connects, it is said to be:   Mark for Review
(1) Points
            Recursive
            Committed
            Implicit
            Transferable (*)

4.         Non-transferable relationships can only be mandatory, not optional. True or False?   Mark for Review
(1) Points
            True
            False (*)

5.         A non-transferable relationship means the relationship is manatory at both sides. True or False?       Mark for Review
(1) Points
            True
            False (*)

6.         If two entities have two relationships between them, these relationships can be either _____________ or _____________ .        Mark for Review
(1) Points
            Replicated or Required
            Redundant or Required (*)
            Redundant and Replicated
            Resourced and Really Good

7.         If the same relationship is represented twice in an Entity Relationship Model, it is said to be: Mark for Review
(1) Points
            Removable
            Replicated
            Resourceful
            Redundant (*)

8.         Which of the following pairs of entities is most likely to be modeled as a 1:1 relationship?    Mark for Review
(1) Points
            TEACHER and SUBJECT AREA
            TREE and BRANCH
            PERSON and FINGERPRINT (*)
            CAR and WHEEL

9.         Which of the following pairs of entities is most likely to be modeled as a M:M relationship? Mark for Review
(1) Points
            TREE and BRANCH
            TEACHER and SUBJECT AREA (*)
            CAR and WHEEL
            PERSON and FINGERPRINT

10.       One to many relationships are the most uncommon type of relationships in an ERD. True or False?  Mark for Review
(1) Points
            True
            False (*)

11.       When you resolve a M:M by creating an intersection entity, this new entity will always inherit:         Mark for Review
(1) Points
            The attributes of both related entities.
            The UID's from the entities in the original M:M.
            Nothing is inherited from the original entities and relationship.
            A relationship to each entity from the original M:M. (*)

12.       A barred relationship on an ERD signifies that the UID of the intersection entity is inherited from the entities that made up the original many to many relationship. True or False?  Mark for Review
(1) Points
            True (*)
            False

13.       Many to many relationships between entities usually hide what?        Mark for Review
(1) Points
            More attributes
            Uniqueness
            Another relationship
            Another entity (*)

14.       If an intersection entity is formed that contains no attributes of its own, its uniqueness may be modeled by        Mark for Review
(1) Points
            Creating new attributes.
            Barring the relationships to the original entities. (*)
            Placing the UID attributes from the original entities into the intersection entity.
            None of the above.

15.       Intersection Entities often have the relationships participating in the UID, so the relationships are often barred. True or False?  Mark for Review
(1) Points
            True (*)
            False

1.         Many to many relationships must be left in the Model. It is important to have them documented as M-M. True or False?  Mark for Review
(1) Points
            True
            False (*)

2.         What relationship is described by the statements: "Each CUSTOMER may place one or more ORDERs, each ORDER must be placed by one and only one CUSTOMER"       Mark for Review
(1) Points
            Many to Many
            Many to More
            One to One
            One to Many (*)

3.         If the same relationship is represented twice in an Entity Relationship Model, it is said to be: Mark for Review
(1) Points
            Redundant (*)
            Resourceful
            Removable
            Replicated

4.         One to many relationships are the most uncommon type of relationships in an ERD. True or False?  Mark for Review
(1) Points
            True
            False (*)

5.         Which of the following pairs of entities is most likely to be modeled as a M:M relationship? Mark for Review
(1) Points
            CAR and WHEEL
            TREE and BRANCH
            PERSON and FINGERPRINT
            TEACHER and SUBJECT AREA (*)

6.         A Diamond on a relationship indicates the Relationship as Non-Tranferable. True or False?  Mark for Review
(1) Points
            True (*)
            False

7.         Every ERD must have at least one non-transferable relationship. True or False?         Mark for Review
(1) Points
            True
            False (*)

8.         If a relationship can NOT be moved between instances of the entities it connects, it is said to be:      Mark for Review
(1) Points
            Optional
            Mandatory
            Non-Transferable (*)
            Transferable

9.         The relationship between CUSTOMER and RECEIPT is an example of a non-transferable relationship. True or False?  Mark for Review
(1) Points
            True (*)
            False

10.       If a relationship can be moved between instances of the entities it connects, it is said to be:   Mark for Review
(1) Points
            Recursive
            Implicit
            Transferable (*)
            Committed

11.       If an intersection entity is formed that contains no attributes of its own, its uniqueness may be modeled by        Mark for Review
(1) Points
            Creating new attributes.
            Barring the relationships to the original entities. (*)
            Placing the UID attributes from the original entities into the intersection entity.
            None of the above.

12.       When you resolve a M:M, you simply re-draw the relationships between the two original entities; no new entities are created. True or False?       Mark for Review
(1) Points
            True
            False (*)

13.       Many to many relationships between entities usually hide what?        Mark for Review
(1) Points
            More attributes
            Another relationship
            Uniqueness
            Another entity (*)

14.       A barred relationship on an ERD signifies that the UID of the intersection entity is inherited from the entities that made up the original many to many relationship. True or False?  Mark for Review
(1) Points
            True (*)
            False

15.       Intersection Entities often have the relationships participating in the UID, so the relationships are often barred. True or False?  Mark for Review
(1) Points
            True (*)
            False

1.         When you resolve a M:M by creating an intersection entity, this new entity will always inherit:         Mark for Review
(1) Points
            A relationship to each entity from the original M:M. (*)
            The attributes of both related entities.
            The UID's from the entities in the original M:M.
            Nothing is inherited from the original entities and relationship.

2.         What do you call the entity created when you resolve a M:M relationship?     Mark for Review
(1) Points
            M:M entity
            Inclusion entity
            Intersection entity (*)
            Recursive entity

3.         Many to many relationships between entities usually hide what?        Mark for Review
(1) Points
            Uniqueness
            Another relationship
            Another entity (*)
            More attributes

4.         A relationship on an ERD can have attributes. True or False? Mark for Review
(1) Points
            True
            False (*)

5.         If an intersection entity is formed that contains no attributes of its own, its uniqueness may be modeled by        Mark for Review
(1) Points
            Creating new attributes.
            Barring the relationships to the original entities. (*)
            Placing the UID attributes from the original entities into the intersection entity.
            None of the above.

6.         A Diamond on a relationship indicates the Relationship as Non-Tranferable. True or False?  Mark for Review
(1) Points
            True (*)
            False

7.         Non-transferable relationships can only be mandatory, not optional. True or False?   Mark for Review
(1) Points
            True
            False (*)

8.         The relationship between CUSTOMER and RECEIPT is an example of a non-transferable relationship. True or False?  Mark for Review
(1) Points
            True (*)
            False

9.         If a relationship can NOT be moved between instances of the entities it connects, it is said to be:      Mark for Review
(1) Points
            Non-Transferable (*)
            Optional
            Transferable
            Mandatory

10.       A non-transferable relationship means the relationship is manatory at both sides. True or False?       Mark for Review
(1) Points
            True
            False (*)

11.       Which of the following pairs of entities is most likely to be modeled as a 1:1 relationship?    Mark for Review
(1) Points
            PERSON and FINGERPRINT (*)
            CAR and WHEEL
            TEACHER and SUBJECT AREA
            TREE and BRANCH

12.       What uncommon relationship is described by the statements: "Each DNA SAMPLE may be taken from one and only one PERSON and each PERSON may provide one and only one DNA SAMPLE"        Mark for Review
(1) Points
            One to One Optional (*)
            One to Many Mandatory
            Many to Many Mandatory
            One to Many Optional

13.       Which of the following pairs of entities is most likely to be modeled as a M:M relationship? Mark for Review
(1) Points
            TREE and BRANCH
            PERSON and FINGERPRINT
            CAR and WHEEL
            TEACHER and SUBJECT AREA (*)

14.       What relationship is described by the statements: "Each CUSTOMER may place one or more ORDERs, each ORDER must be placed by one and only one CUSTOMER"       Mark for Review
(1) Points
            One to Many (*)
            One to One
            Many to More
            Many to Many

15.       Many to many relationships must be left in the Model. It is important to have them documented as M-M. True or False?  Mark for Review
(1) Points
            True

            False (*)
Label:

Komentar

  1. zulfa23 Mei 2019 pukul 06.07

    thanks gan, you are good !!!!

    BalasHapus
  2. Anonim18 Maret 2020 pukul 23.30

    I'M NOW FULFILL FINANCIALLY BECAUSE OF THE LOAN I GOT FROM LFDS .I would like to bring this to the notice of the public about how i came in contact with LFDS after i lost my job and being denied loan by my bank and other financial institution due to my credit score. I could not pay my children's fees. I was behind on bills, about to be thrown out of the house due to my inability to pay my rent, It was during this period my kids were taken from me by foster care. Then i set out to seek for funds online where i lost $3,670 that i borrowed from friends which i was rip off by two online loan companies. Until i read about:Le_Meridian Funding Service  (lfdsloans@outlook.com / lfdsloans@lemeridianfds.com) somewhere on the internet, Still wasn't convince because of what i have been through until a relative of mine who is a clergy also told me about the ongoing loan scheme of LFDS at a very low interest rate of 1.9%% and lovely repayment terms without penalty for default of payment. I have no choice than to also contact them which i did through text +1-989-394-3740 and Mr Benjamin responded back to me That day was the I'M best and greatest day of my life which can never be forgotten when i receive a credit alert of $400,000.00 Usd loan amount i applied for. I utilized the loan effectively to pay up my debts and to start up a business and today i and my kids are so happy and fulfill. You can as well contact them through email: (lfdsloans@outlook.com / lfdsloans@lemeridianfds.com)  WhatsApptext  helpline: +1-989-394-3740 Why am i doing this? I am doing this to save as many that are in need of a loan not to be victim of scams on the internet. Thanks and God bless you all, I'm Oleksander Artem from Horizon Park BC , Ukrain.

    BalasHapus
  3. andrei23 September 2020 pukul 12.20

    Cool! Thank you very much, nice work!

    BalasHapus
  4. Binx2 November 2020 pukul 03.14

    You rock dude

    BalasHapus
  5. Unknown21 Oktober 2021 pukul 16.31

    If an intersection entity is formed that contains no attributes of its own, its uniqueness may be modeled by
    Placing the UID attributes from the original entities into the intersection entity.

    BalasHapus
  6. Unknown11 Maret 2022 pukul 10.48

    Deni Ace: Section 5 Quiz Database Design Oracle >>>>> Download Now

    >>>>> Download Full

    Deni Ace: Section 5 Quiz Database Design Oracle >>>>> Download LINK

    >>>>> Download Now

    Deni Ace: Section 5 Quiz Database Design Oracle >>>>> Download Full

    >>>>> Download LINK Wd

    BalasHapus
  7. Unknown23 Maret 2022 pukul 17.17

    thanks for the fabulous answers😍🤗



    fanmail

    BalasHapus
  8. Unknown23 Maret 2022 pukul 17.17

    thanks for the fabulous answers😍🤗


    BalasHapus

Posting Komentar

Postingan populer dari blog ini

Section 6 Quiz Oracle Database Programming with SQL

Oleh
Section 6 Quiz             (Answer all questions in this section)                                                             1.         Given the following descriptions of the employees and jobs tables, which of the following scripts will display each employee ﾒ s possible minimum and maximum salaries based on their job title? EMPLOYEES Table: Name   Null?    Type EMPLOYEE_ID          NOT NULL     NUMBER (6) FIRST_NAME             VARCHAR2 (20) LAST_NAME  NOT NULL     VARCHAR2 (25) EMAIL NOT NULL     VARCHAR2 (25) PHONE_NUMBER                  VARCHAR2 (20) HIRE_DATE   NOT NULL     DATE JOB_ID           NOT NULL     VARCHAR2 (10) SALARY                     NUMBER (8,2) COMMISSION_PCT                NUMBER (2,2) MANAGER_ID                       NUMBER (6) DEPARTMENT_ID                 NUMBER (4) JOBS Table: Name   Null?    Type JOB_ID           NOT NULL     VARCHAR2 (10) JOB_TITLE     NOT NULL     VARCHAR2 (35) MIN_SALARY                      
40 komentar
Baca selengkapnya

Section 10 Quiz Database Programming With SQL

Oleh
Section 10 Quiz             (Answer all questions in this section) 1.         A multiple-row operator expects how many values?   Mark for Review (1) Points             One or more (*)             Only one             Two or more             None 2.         The salary column of the f_staffs table contains the following values: 4000 5050 6000 11000 23000 Which of the following statements will return the last_name and first_name of those employees who earn more than 5000?  Mark for Review (1) Points             SELECT last_name, first_name FROM f_staffs WHERE salary IN (SELECT last_name, first_name FROM f_staffs WHERE salary <5000 o:p="">             SELECT last_name, first_name FROM f_staffs WHERE salary = (SELECT salary FROM f_staffs WHERE salary < 5000);             SELECT last_name, first_name FROM f_staffs WHERE salary IN (SELECT salary FROM f_staffs WHERE salary > 5000); (*)             SELEC
30 komentar
Baca selengkapnya

Section 6 Quiz Database Design Oracle

Oleh
Section 6 Quiz             (Answer all questions in this section) 1.         Examine the following Entity and decide which rule of Normal Form is being violated: ENTITY: CLIENT ATTRIBUTES:     # CLIENT ID     FIRST NAME     LAST NAME     STREET     CITY     ZIP CODE  Mark for Review (1) Points             1st Normal Form.             2nd Normal Form.             3rd Normal Form.             None of the above, the entity is fully normalised. (*) 2.         A transitive dependency exists when any attribute in an entity is dependent on any other non-UID attribute in that entity.            Mark for Review (1) Points             True (*)             False 3.         When any attribute in an entity is dependent on any other non-UID attribute in that entity, this is known as:        Mark for Review (1) Points             Functional dependency             Dependency             Transitive dependency (*)             Non-dependency
17 komentar
Baca selengkapnya