Langsung ke konten utama

Section 7 Quiz Database Design Oracle

Section 7 Quiz
                (Answer all questions in this section)

1.            Which of the following would best be represented by an arc?    Mark for Review
(1) Points
                STUDENT (senior, male)
                STUDENT (Grade A student, Average Student)
                STUDENT (graduating, female)
                STUDENT ( University, Technical College) (*)

2.            Arcs are Mandatory in Data modeling. All ERD's must have at least one Arc. True or False?            Mark for Review
(1) Points
                True
                False (*)

3.            To visually represent exclusivity between two or more relationships in an ERD you would most likely use an ________.         Mark for Review
(1) Points
                Arc (*)
                Relationship
                Attribute
                UID

4.            An arc can often be modeled as Supertype and Subtypes. True or False?              Mark for Review
(1) Points
                True (*)
                False

5.            Which of the following would best be represented by an arc?    Mark for Review
(1) Points
                TEACHER (Female, Bob)
                PARENT (Girl, Bob)
                DELIVERY ADDRESS (Home, Office) (*)
                STUDENT (Grade A student, Average Student)

6.            All relationships participating in an arc must be mandatory. True or False?             Mark for Review
(1) Points
                True
                False (*)

7.            Every business has restrictions on which attribute values and which relationships are allowed. These are known as:           Mark for Review
(1) Points
                Constraints. (*)
                Relationships
                Entities.
                Attributes

8.            Arcs are used to visually represent _________ between two or more relationships in an ERD.   Mark for Review
(1) Points
                Differences
                Inheritance
                Sameness
                Exclusivity (*)

9.            Cascading UIDs are a feature often found in what type of Relationship? Mark for Review
(1) Points
                Invalid Relationship
                Recursive Relationship
                General Relationship
                Heirarchical Relationship (*)

10.          A relationship between an entity and itself is called a/an:             Mark for Review
(1) Points
                Recursive Relationship (*)
                Invalid Relationship
                Heirarchical Relationship
                General Relationship

11.          A Recursive Relationship is represented on an ERD by a/an:         Mark for Review
(1) Points
                Single Toe
                Pig's Ear (*)
                Crow's Foot
                Dog's Tail

12.          A single relationship can be both Recursive and Hierarchical at the same time. True or False?       Mark for Review
(1) Points
                True
                False (*)

13.          Business organizational charts are often modeled as a Hierarchical relationship. True or False?    Mark for Review
(1) Points
                True (*)
                False

14.          A recursive relationship must be Mandatory at both ends. True or False?              Mark for Review
(1) Points
                True
                False (*)

15.          A Hierarchical relationship is a series of relationships that reflect entities organized into successive levels. True or False?    Mark for Review
(1) Points
                True (*)
                False

1.            A particular problem may be solved using either a Recursive Relationship or a Hierarchical Relationship, though not at the same time. True or False?       Mark for Review
(1) Points
                True (*)
                False

2.            A single relationship can be both Recursive and Hierarchical at the same time. True or False?       Mark for Review
(1) Points
                True
                False (*)

3.            A Recursive Relationship is represented on an ERD by a/an:         Mark for Review
(1) Points
                Single Toe
                Dog's Tail
                Pig's Ear (*)
                Crow's Foot

4.            Business organizational charts are often modeled as a Hierarchical relationship. True or False?    Mark for Review
(1) Points
                True (*)
                False

5.            A relationship between an entity and itself is called a/an:             Mark for Review
(1) Points
                General Relationship
                Recursive Relationship (*)
                Heirarchical Relationship
                Invalid Relationship

6.            A Hierarchical relationship is a series of relationships that reflect entities organized into successive levels. True or False?    Mark for Review
(1) Points
                True (*)
                False

7.            Cascading UIDs are a feature often found in what type of Relationship? Mark for Review
(1) Points
                Recursive Relationship
                General Relationship
                Invalid Relationship
                Heirarchical Relationship (*)

8. Which of the following would best be represented by an arc?                Mark for Review
(1) Points
                STUDENT (senior, male)
                STUDENT ( University, Technical College) (*)
                STUDENT (Grade A student, Average Student)
                STUDENT (graduating, female)

9.            To visually represent exclusivity between two or more relationships in an ERD you would most likely use an ________.         Mark for Review
(1) Points
                Relationship
                Arc (*)
                UID
                Attribute

10.          All relationships participating in an arc must be mandatory. True or False?             Mark for Review
(1) Points
                True
                False (*)

11.          An arc can often be modeled as Supertype and Subtypes. True or False?              Mark for Review
(1) Points
                True (*)
                False

12.          Arcs are used to visually represent _________ between two or more relationships in an ERD.   Mark for Review
(1) Points
                Sameness
                Differences
                Exclusivity (*)
                Inheritance

13.          Which of the following can be added to a relationship?  Mark for Review
(1) Points
                An optional attribute can be created
                A composite attribute
                An attribute
                An arc can be assigned (*)

14.          Which of the following would best be represented by an arc?    Mark for Review
(1) Points
                TEACHER (Female, Bob)
                STUDENT (Grade A student, Average Student)
                DELIVERY ADDRESS (Home, Office) (*)
                PARENT (Girl, Bob)

15.          Arcs are Mandatory in Data modeling. All ERD's must have at least one Arc. True or False?            Mark for Review
(1) Points
                True
                False (*)

1.            A relationship between an entity and itself is called a/an:             Mark for Review
(1) Points
                Invalid Relationship
                Recursive Relationship (*)
                General Relationship
                Heirarchical Relationship

2.            A recursive relationship must be Mandatory at both ends. True or False?              Mark for Review
(1) Points
                True
                False (*)

3.            A Hierarchical relationship is a series of relationships that reflect entities organized into successive levels. True or False?    Mark for Review
(1) Points
                True (*)
                False

4.            A single relationship can be both Recursive and Hierarchical at the same time. True or False?       Mark for Review
(1) Points
                True
                False (*)

5.            A particular problem may be solved using either a Recursive Relationship or a Hierarchical Relationship, though not at the same time. True or False?       Mark for Review
(1) Points
                True (*)
                False

6.            Business organizational charts are often modeled as a Hierarchical relationship. True or False?    Mark for Review
(1) Points
                True (*)
                False

7.            A Recursive Relationship is represented on an ERD by a/an:         Mark for Review
(1) Points
                Single Toe
                Pig's Ear (*)
                Crow's Foot
                Dog's Tail

8.            Which of the following can be added to a relationship?  Mark for Review
(1) Points
                An arc can be assigned (*)
                An optional attribute can be created
                An attribute
                A composite attribute

9.            Every business has restrictions on which attribute values and which relationships are allowed. These are known as:           Mark for Review
(1) Points
                Attributes
                Constraints. (*)
                Entities.
                Relationships

10.          Which of the following would best be represented by an arc?    Mark for Review
(1) Points
                TEACHER (Female, Bob)
                DELIVERY ADDRESS (Home, Office) (*)
                PARENT (Girl, Bob)
                STUDENT (Grade A student, Average Student)

11.          An arc can often be modeled as Supertype and Subtypes. True or False?              Mark for Review
(1) Points
                True (*)
                False

12.          Arcs are Mandatory in Data modeling. All ERD's must have at least one Arc. True or False?            Mark for Review
(1) Points
                True
                False (*)

13.          To visually represent exclusivity between two or more relationships in an ERD you would most likely use an ________.         Mark for Review
(1) Points
                Attribute
                Relationship
                UID
                Arc (*)

14.          Arcs model an Exclusive OR constraint. True or False?     Mark for Review
(1) Points
                True (*)
                False

15.          Arcs are used to visually represent _________ between two or more relationships in an ERD.   Mark for Review
(1) Points
                Differences
                Sameness
                Exclusivity (*)
                Inheritance

1.            All relationships participating in an arc must be mandatory. True or False?             Mark for Review
(1) Points
                True
                False (*)

2.            Arcs model an Exclusive OR constraint. True or False?     Mark for Review
(1) Points
                True (*)
                False

3.            An arc can often be modeled as Supertype and Subtypes. True or False?              Mark for Review
(1) Points
                True (*)
                False

4.            Which of the following would best be represented by an arc?    Mark for Review
(1) Points
                STUDENT (Grade A student, Average Student)
                TEACHER (Female, Bob)
                DELIVERY ADDRESS (Home, Office) (*)
                PARENT (Girl, Bob)

5.            To visually represent exclusivity between two or more relationships in an ERD you would most likely use an ________.         Mark for Review
(1) Points
                UID
                Arc (*)
                Attribute
                Relationship

6.            Which of the following would best be represented by an arc?    Mark for Review
(1) Points
                STUDENT (graduating, female)
                STUDENT ( University, Technical College) (*)
                STUDENT (Grade A student, Average Student)
                STUDENT (senior, male)

7.            Arcs are used to visually represent _________ between two or more relationships in an ERD.   Mark for Review
(1) Points
                Exclusivity (*)
                Differences
                Inheritance
                Sameness

8.            Every business has restrictions on which attribute values and which relationships are allowed. These are known as:           Mark for Review
(1) Points
                Entities.
                Relationships
                Constraints. (*)
                Attributes

9.            A single relationship can be both Recursive and Hierarchical at the same time. True or False?       Mark for Review
(1) Points
                True
                False (*)

10.          A recursive relationship must be Mandatory at both ends. True or False?              Mark for Review
(1) Points
                True
                False (*)

11.          Cascading UIDs are a feature often found in what type of Relationship? Mark for Review
(1) Points
                Recursive Relationship
                General Relationship
                Heirarchical Relationship (*)
                Invalid Relationship

12.          A Hierarchical relationship is a series of relationships that reflect entities organized into successive levels. True or False?    Mark for Review
(1) Points
                True (*)
                False

13.          A Recursive Relationship is represented on an ERD by a/an:         Mark for Review
(1) Points
                Crow's Foot
                Single Toe
                Pig's Ear (*)
                Dog's Tail

14.          A particular problem may be solved using either a Recursive Relationship or a Hierarchical Relationship, though not at the same time. True or False?       Mark for Review
(1) Points
                True (*)
                False

15.          Business organizational charts are often modeled as a Hierarchical relationship. True or False?    Mark for Review
(1) Points
                True (*)

                False

Komentar

  1. I really appreciate the information shared above. It’s of great help. If someone want to learn Online (Virtual) instructor lead live training in #IBM #INFORMATION #ANALYZER, kindly Contact MaxMunus
    MaxMunus Offer World Class Virtual Instructor-led training on #IBM #INFORMATION #ANALYZER. We have industry expert trainer. We provide Training Material and Software Support. MaxMunus has successfully conducted 1,00,000 + training in India, USA, UK, Australia, Switzerland, Qatar, Saudi Arabia, Bangladesh, Bahrain, and UAE etc.
    Avishek Priyadarshi
    MaxMunus
    E-mail: avishek@maxmunus.com
    Skype id: avishek_2.
    Ph:(0) 8553177744 / 080 - 41103383
    www.MaxMunus.com

    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