Answer Oracle Design Quiz Final Exam

1.            An entity can only have one Primary UID. True or False?                Mark for Review
(1) Points
                True (*)
                False

2.            If an entity has no attribute suitable to be a Primary UID, we can create an artificial one. True or False?  Mark for Review
(1) Points
                True (*)
                False

3.            There is no limit to how many columns can make up an entity's UID. True or False?          Mark for Review
(1) Points
                True (*)
                False

4.            A unique identifier can only be made up of one attribute. True or False?               Mark for Review
(1) Points
                True
                False (*)

5.            When is an entity in 2nd Normal Form? Mark for Review
(1) Points
                When all non-UID attributes are dependent upon the entire UID. (*)
                When attributes with repeating or multi-values are present.
                When no attritibutes are mutually independent and all are fully dependent on the primary key.
                None of the Above.

6.            What is the rule of Second Normal Form?             Mark for Review
(1) Points
                No non-UID attributes can be dependent on any part of the UID.
                Some non-UID attributes can be dependent on the entire UID.
                All non-UID attributes must be dependent upon the entire UID. (*)
                None of the above

7.            Examine the following entity and decide how to make it conform to the rule of 2nd Normal Form:
ENTITY: RECEIPT
ATTRIBUTES:
   #CUSTOMER ID
   #STORE ID
   STORE LOCATION
   DATE
 Mark for Review
(1) Points
                Do nothing, it is already in 2nd Normal Form.
                Delete the attribute STORE ID
                Move the attribute STORE LOCATION to a new entity, STORE, with a UID of STORE ID, and create a relationship to the original entity. (*)
                Move the attribute STORE LOCATION to a new entity, STORE, with a UID of STORE LOCATION, and create a relationship to the original entity.

8.            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
                Dependency
                Functional dependency
                Non-dependency
                Transitive dependency (*)

9.            Examine the following Entity and decide which rule of Normal Form is being violated:
ENTITY: CLIENT
ATTRIBUTES:
    # CLIENT ID
    FIRST NAME
    LAST NAME
    ORDER ID
    STREET
    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.

10.          As a database designer, you do not need to worry about where in the datamodel you store a particular attribute; as long as you get it onto the ERD, your job is done. True or False?       Mark for Review
(1) Points
                True
                False (*)

11.          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. (*)

12.          When data is stored in more than one place in a database, the database violates the rules of ___________.                Mark for Review
(1) Points
                Normalcy
                Replication
                Normalization (*)
                Decency

13.          If an entity has a multi-valued attribute, to conform to the rule of 1st Normal Form we: Mark for Review
(1) Points
                Make the attribute optional
                Do nothing, an entity does not have to be in 1st Normal Form
                Create an additional entity and relate it to the original entity with a 1:M relationship. (*)
                Create an additional entity and relate it to the original entity with a M:M relationship.

14.          An entity ORDER has the attributes Order ID, Order Date, Product id, Customer ID. This entity is in 1st Normal Form. True or False?       Mark for Review
(1) Points
                True
                False (*)

15.          An entity can have repeated values and still be in 1st Normal Form. True or False?            Mark for Review
(1) Points
                True
                False (*)

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

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

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

19.          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

20.          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

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

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

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

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

Section 8
                (Answer all questions in this section)

25.          Which of the following would be a logical constraint when modeling time for a country entity?   Mark for Review
(1) Points
                Daily traffic patterns must be monitored to determine which countries are overcrowded.
                People have births and deaths in their countries that must be tracked by the system.
                If you are doing a system for France or Germany, you would need security clearance.
                Countries may change their names and/or borders over a period of time. (*)

Section 8
                (Answer all questions in this section)

26.          Which of the following would be a logical constraint when modeling time for a City entity?           Mark for Review
(1) Points
                Daily traffic patterns must be monitored to determine how many law enforcement officers are needed.
                If you are doing a system for any French City, you would need security clearance.
                Cites may change their names and/or country association if the borders of a country change. (*)
                People are born in the city and people die in the city.

27.          All systems must include functionality to provide logging or journaling in conceptual data models. True or False?   Mark for Review
(1) Points
                True
                False (*)

28.          When a system requires that old values for attributes are kept on record, this is know as Journaling or Logging. True or False?  Mark for Review
(1) Points
                True (*)
                False

29.          There is no point in trying to group your entities together on your diagram according to volume, and making a diagram look nice is a waste of time. True or False?      Mark for Review
(1) Points
                True
                False (*)

30.          Formal rules exist for drawing ERD's. You must always follow them, even if it results in an ERD that is difficult to read. True or False?   Mark for Review
(1) Points
                True
                False (*)

31.          Which of the following scenarios should be modeled so that historical data is kept? (Choose two)             Mark for Review
(1) Points
                                                (Choose all correct answers)    
                LIBRARY and NUMBER OF BOOKS
                STUDENT and GRADE (*)
                STUDENT and AGE
                LIBRARY and BOOK (*)

32.          Historical data must never be kept. True or False?            Mark for Review
(1) Points
                True
                False (*)

Section 9
                (Answer all questions in this section)

33.          The explanation below is an example of which constraint type?
A primary key must be unique, and no part of the primary key can be null.           Mark for Review
(1) Points
                Referential integrity
                Column integrity
                Entity integrity (*)
                User-defined integrity

34.          Foreign keys cannot be null when            Mark for Review
(1) Points
                It refers to the same table
                It is part of a primary key (*)
                It refers to another table
                It contains three or more columns

35.          The explanation below is an example of which constraint type?
If the value in the balance column of the ACCOUNTS table is below 100, we must send a letter to the account owner which will require extra programming to enforce.             Mark for Review
(1) Points
                User-defined integrity (*)
                Entity integrity
                Column integrity
                Referential integrity

Section 9
                (Answer all questions in this section)

36.          A foreign key cannot refer to a primary key in the same table. True or False?      Mark for Review
(1) Points
                True
                False (*)

37.          Column integrity refers to            Mark for Review
(1) Points
                Columns always containing text data less than 255 characters
                Columns always containing values consistent with the defined data format (*)
                Columns always having values
                Columns always containing positive numbers

38.          When an Arc is transformed to the physical model every relationship in the Arc becomes a mandatory Foreign Key. True or False?         Mark for Review
(1) Points
                True
                False (*)

39.          One-to-Many Optional to Mandatory becomes a _______________ on the Master table.          Mark for Review
(1) Points
                Unique Key
                Optional Foreign Key (*)
                Mandatory Foreign Key
                Primary Key

40.          A barrred Relationship will result in a Foreign Key column that also is part of:       Mark for Review
(1) Points
                The Column Name
                The Check Constraint
                The Table Name
                The Primary Key (*)

Section 9
                (Answer all questions in this section)

41.          Relationships on an ERD can only be transformed into UIDs in the physical model? True or False?              Mark for Review
(1) Points
                True
                False (*)

42.          One-to-One relationships are transformed into Check Constraints in the tables created at either end of that relationship. True or False?         Mark for Review
(1) Points
                True
                False (*)

43.          The "Arc Implementation" is a synonym for what type of implementation?          Mark for Review
(1) Points
                Cascade Implementation
                Supertype Implementation
                Subtype Implementation
                Supertype and Subtype Implementation (*)

44.          When mapping supertypes, relationships at the supertype level transform as usual. Relationships at the subtype level are implemented as foreign keys, but the foreign key columns all become optional. True or False?                Mark for Review
(1) Points
                True (*)
                False

45.          The transformation from an ER diagram to a physical design involves changing terminology. Entities in the ER diagram become __________ :                Mark for Review
(1) Points
                Columns
                Tables (*)
                Foreign Keys
                Unique Keys

Section 9
                (Answer all questions in this section)

46.          The conceptual model is transformed into a physical model. The physical implementation will be a relational database. True or False?               Mark for Review
(1) Points
                True (*)
                False

47.          In an Oracle database, why would 1_TABLE not work as a table name?   Mark for Review
(1) Points
                There is no problem here. You can create a table called 1_TABLE.
                Object names must not start with a number. They must begin with a letter. (*)
                TABLE is a reserved word.
                The database does not understand all capital letters.

48.          In an Oracle database, why would the following table name not be allowed 'EMPLOYEE JOBS'?   Mark for Review
(1) Points
                JOBS is a reserved word
                The database does not understand all capital letters
                You cannot have spaces between words in a table name (*)
                EMPLOYEE is a reserved word

Section 10
                (Answer all questions in this section)

49.          In which phases of the System Development Life Cycle will we need to use SQL as a language? (Choose Two)                Mark for Review
(1) Points
                                                (Choose all correct answers)    
                Build and Document (*)
                Analysis
                Transition (*)
                Strategy

50.          During which phases of the System Development Life Cycle would you roll out the system to the users?                Mark for Review
(1) Points
                Build and Transition
                Design and Production
                Strategy and Analysis

                Transition and Production (*)