Langsung ke konten utama

Section 3 Quiz Database Design Oracle

Section 3 Quiz
                (Answer all questions in this section)
1.            What are the three properties that every relationship should have?        Mark for Review
(1) Points
                Name, optionality, cardinality (*)
                A UID bar, a diamond, an arc
                Name, optionality, arcs
                Transferability, degree, name

2.            Relationships can be either mandatory or optional. True or False?            Mark for Review
(1) Points
                True (*)
                False

3.            In a business that sells pet food, choose the best relationship name between FOOD TYPE and ANIMAL (e.g. dog, horse, or cat). (Choose Two)            Mark for Review
(1) Points
                                                (Choose all correct answers)      
                Each ANIMAL must be the seller of one or more FOOD TYPES.
                Each FOOD TYPE may be manufactured by one or more ANIMALs.
                Each FOOD TYPE must be suitable for one or more ANIMALs. (*)
                Each FOOD TYPE may be given to one or more ANIMALs. (*)

4.            One Relationship can be mandatory in one direction and optional in the other direction. True or False?  Mark for Review
(1) Points
                True (*)
                False

5.            Which of the following are used to show Cardinality on an ERD? (Choose two)    Mark for Review
(1) Points
                                                (Choose all correct answers)      
                Crow's foot. (*)
                Solid line.
                Single toe. (*)
                Dashed line.

6.            Which of the following are true about Cardinality? (Choose two)               Mark for Review
(1) Points
                                                (Choose all correct answers)      
                Cardinality tells "how many". (*)
                Cardinality specifies a counting number (like 1, 2, 3, 4 etc.) in a relationship.
                Cardinality specifies whether something is required or not.
                Cardinality specifies only singularity or plurality, but not a specific plural number. (*)

7. Which symbol is used to show that a particular attribute is mandatory?             Mark for Review
(1) Points
                &
                #
                o
                * (*)

8.            Entity boxes are drawn as            Mark for Review
(1) Points
                Soft Boxes (*)
                Hard Boxes
                Normal Circles
                Bold Circles

9.            ERDish describes a relationship in words. True or False? Mark for Review
(1) Points
                True (*)
                False

10.          Which of the following are used to show a relationship on an ERD? (Choose Three)          Mark for Review
(1) Points
                                                (Choose all correct answers)      
                Dashed line. (*)
                Crow's foot. (*)
                Solid line. (*)
                # symbol.

11. When reading a relationship between 2 entities, the relationship is read both from left to right and right to left. True or False?    Mark for Review
(1) Points
                True (*)
                False

12. Relationship names are not shown on an ERD. True or False?               Mark for Review
(1) Points
                True
                False (*)

13. Matrix Diagrams show Optionality and Cardinality of the ERDs they document. True or False?              Mark for Review
(1) Points
                True
                False (*)

14.          Matrix Diagrams are developed BEFORE the ERD. True or False?                Mark for Review
(1) Points
                True (*)
                False

15.          Matrix Diagrams are used to verify that all relationships have been identified for an ERD. True or False? Mark for Review
(1) Points
                True (*)
                False
1.            Which of the following are used to show a relationship on an ERD? (Choose Three)          Mark for Review
(1) Points
                                                (Choose all correct answers)      
                # symbol.
                Solid line. (*)
                Dashed line. (*)
                Crow's foot. (*)

2.            Relationship names are not shown on an ERD. True or False?      Mark for Review
(1) Points
                True
                False (*)

3.            When reading the relationships in an ERD, you are said to be speaking:  Mark for Review
(1) Points
                Entity-ish
                Gibberish
                ERDish (*)
                Relationship-ish

4.            ERDish describes a relationship in words. True or False? Mark for Review
(1) Points
                True (*)
                False

5.            What are the three properties that every relationship should have?        Mark for Review
(1) Points
                Name, optionality, arcs
                Transferability, degree, name
                Name, optionality, cardinality (*)
                A UID bar, a diamond, an arc

6.            Relationships can be either mandatory or optional. True or False?            Mark for Review
(1) Points
                True (*)
                False

7.            Which of the following are used to show Cardinality on an ERD? (Choose two)    Mark for Review
(1) Points
                                                (Choose all correct answers)      
                Single toe. (*)
                Dashed line.
                Crow's foot. (*)
                Solid line.

8.            Relationships always exist between        Mark for Review
(1) Points
                3 or more attributes
                3 or more entities
                2 entities (or one entity and itself) (*)
                2 attributes

9.            In a business that sells pet food, choose the best relationship name between FOOD TYPE and ANIMAL (e.g. dog, horse, or cat). (Choose Two)            Mark for Review
(1) Points
                                                (Choose all correct answers)      
                Each ANIMAL must be the seller of one or more FOOD TYPES.
                Each FOOD TYPE may be given to one or more ANIMALs. (*)
                Each FOOD TYPE may be manufactured by one or more ANIMALs.
                Each FOOD TYPE must be suitable for one or more ANIMALs. (*)

10.          Which of the following are true about Cardinality? (Choose two)               Mark for Review
(1) Points
                                                (Choose all correct answers)      
                Cardinality specifies whether something is required or not.
                Cardinality specifies only singularity or plurality, but not a specific plural number. (*)
                Cardinality tells "how many". (*)
                Cardinality specifies a counting number (like 1, 2, 3, 4 etc.) in a relationship.

11.          To identify an attribute as part of a unique identifier on an ER diagram, the # symbol goes in front of it. True or False?              Mark for Review
(1) Points
                True (*)
                False

12.          Entity names are always singular. True or False?                Mark for Review
(1) Points
                True (*)
                False

13.          Matrix Diagrams show Optionality and Cardinality of the ERDs they document. True or False?     Mark for Review
(1) Points
                True
                False (*)

14.          Matrix Diagrams are developed BEFORE the ERD. True or False?                Mark for Review
(1) Points
                True (*)
                False

15.          Matrix Diagrams are used to verify that all relationships have been identified for an ERD. True or False? Mark for Review
(1) Points
                True (*)
                False

1.            Entity names are always singular. True or False?                Mark for Review
(1) Points
                True (*)
                False

2.            Entity boxes are drawn as            Mark for Review
(1) Points
                Normal Circles
                Hard Boxes
                Soft Boxes (*)
                Bold Circles

3.            Relationship names are not shown on an ERD. True or False?      Mark for Review
(1) Points
                True
                False (*)

4.            ERDish describes a relationship in words. True or False? Mark for Review
(1) Points
                True (*)
                False

5.            Which of the following are used to show a relationship on an ERD? (Choose Three)          Mark for Review
(1) Points
                                                (Choose all correct answers)      
                Crow's foot. (*)
                Solid line. (*)
                # symbol.
                Dashed line. (*)

6.            When reading a relationship between 2 entities, the relationship is read both from left to right and right to left. True or False?          Mark for Review
(1) Points
                True (*)
                False

7.            Which of the following are true about Cardinality? (Choose two)               Mark for Review
(1) Points
                                                (Choose all correct answers)      
                Cardinality specifies whether something is required or not.
                Cardinality tells "how many". (*)
                Cardinality specifies only singularity or plurality, but not a specific plural number. (*)
                Cardinality specifies a counting number (like 1, 2, 3, 4 etc.) in a relationship.

8.            Which of the following are true about Relationship Optionality? (Choose two)    Mark for Review
(1) Points
                                                (Choose all correct answers)      
                Optionality specifies only singularity or plurality, but not a specific plural number.
                Optionality answers "may or must". (*)
                Optionality specifies a counting number (like 1, 2, 3, 4 etc.) in a relationship.
                Optionality specifies whether something is required or not. (*)

9.            In a business that sells pet food, choose the best relationship name between FOOD TYPE and ANIMAL (e.g. dog, horse, or cat). (Choose Two)            Mark for Review
(1) Points
                                                (Choose all correct answers)      
                Each FOOD TYPE may be given to one or more ANIMALs. (*)
                Each FOOD TYPE may be manufactured by one or more ANIMALs.
                Each FOOD TYPE must be suitable for one or more ANIMALs. (*)
                Each ANIMAL must be the seller of one or more FOOD TYPES.

10. What are the three properties that every relationship should have? Mark for Review
(1) Points
                Transferability, degree, name
                Name, optionality, arcs
                Name, optionality, cardinality (*)
                A UID bar, a diamond, an arc

11.          Relationship Cardinality is important. True or False?         Mark for Review
(1) Points
                True (*)
                False

12.          Relationships can be either mandatory or optional. True or False?            Mark for Review
(1) Points
                True (*)
                False

13.          Matrix Diagrams are used to verify that all relationships have been identified for an ERD. True or False? Mark for Review
(1) Points
                True (*)
                False

14.          Matrix Diagrams are developed BEFORE the ERD. True or False?                Mark for Review
(1) Points
                True (*)
                False

15.          Matrix Diagrams show Optionality and Cardinality of the ERDs they document. True or False?     Mark for Review
(1) Points
                True
                False (*)

1.            Entity boxes are drawn as            Mark for Review
(1) Points
                Normal Circles
                Hard Boxes
                Bold Circles
                Soft Boxes (*)

2.            Entity names are always singular. True or False?                Mark for Review
(1) Points
                True (*)
                False

3.            Matrix Diagrams are developed BEFORE the ERD. True or False?                Mark for Review
(1) Points
                True (*)
                False

4.            Matrix Diagrams show Optionality and Cardinality of the ERDs they document. True or False?     Mark for Review
(1) Points
                True
                False (*)

5.            Matrix Diagrams are used to verify that all relationships have been identified for an ERD. True or False? Mark for Review
(1) Points
                True (*)
                False

6.            Which of the following are used to show a relationship on an ERD? (Choose Three)          Mark for Review
(1) Points
                                                (Choose all correct answers)      
                # symbol.
                Dashed line. (*)
                Crow's foot. (*)
                Solid line. (*)

7.            When reading the relationships in an ERD, you are said to be speaking:  Mark for Review
(1) Points
                Entity-ish
                Relationship-ish
                Gibberish
                ERDish (*)

8.            Relationship names are not shown on an ERD. True or False?      Mark for Review
(1) Points
                True
                False (*)

9.            ERDish describes a relationship in words. True or False? Mark for Review
(1) Points
                True (*)
                False

10.          Which of the following are true about Relationship Optionality? (Choose two)    Mark for Review
(1) Points
                                                (Choose all correct answers)      
                Optionality specifies a counting number (like 1, 2, 3, 4 etc.) in a relationship.
                Optionality answers "may or must". (*)
                Optionality specifies only singularity or plurality, but not a specific plural number.
                Optionality specifies whether something is required or not. (*)

11.          One Relationship can be mandatory in one direction and optional in the other direction. True or False?  Mark for Review
(1) Points
                True (*)
                False

12.          Relationships always exist between        Mark for Review
(1) Points
                3 or more attributes
                3 or more entities
                2 entities (or one entity and itself) (*)
                2 attributes

13.          Which of the following are true about Cardinality? (Choose two)               Mark for Review
(1) Points
                                                (Choose all correct answers)      
                Cardinality specifies whether something is required or not.
                Cardinality specifies a counting number (like 1, 2, 3, 4 etc.) in a relationship.
                Cardinality tells "how many". (*)
                Cardinality specifies only singularity or plurality, but not a specific plural number. (*)

14. Which of the following are used to show Cardinality on an ERD? (Choose two)             Mark for Review
(1) Points
                                                (Choose all correct answers)      
                Single toe. (*)
                Crow's foot. (*)
                Dashed line.
                Solid line.

15.          What are the three properties that every relationship should have?        Mark for Review
(1) Points
                A UID bar, a diamond, an arc
                Transferability, degree, name
                Name, optionality, cardinality (*)
                Name, optionality, arcs


Komentar

  1. That's nice explanation sir i really appreciate that

    BalasHapus
  2. Cool! Thank you very much, nice work!

    BalasHapus
  3. Hair follicle testing can reach back as far as 90 days with high levels of accuracy, giving it the longest range of detection among the available drug test types. Depending on the substance used, a hair follicle test can even determine when someone started and ended their use period. Hair follicle drug tests can detect drug use in the past 90 days. Typically, because they’re such an expensive testing method, they’ll come few and far between. That means you can stock up on detox shampoo and keep it handy if something like that ever does occur! In this guide today, we went over frequently asked questions users have about detoxing their hair, as well as the detox methods involved. We touched on the best detox shampoos, why and when to use them, and more. Visit: https://www.urineworld.com/

    BalasHapus
  4. The many end of a Relationship is called:
    Gulls Foot
    Crows Ear
    Pigs Ear
    Crows Foot *

    BalasHapus

Posting Komentar

Postingan populer dari blog ini

Section 6 Quiz Oracle Database Programming with SQL

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                      

Section 10 Quiz Database Programming With SQL

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

Section 6 Quiz Database Design Oracle

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