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

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

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

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

5.            When is an entity in 2nd Normal Form?
                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? 
                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
                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:
                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
                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
                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 ___________.
                Normalcy
                Replication
                Normalization (*)
                Decency

13.          If an entity has a multi-valued attribute, to conform to the rule of 1st Normal Form we:
                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?
                True
                False (*)

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

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

17.          A relationship between an entity and itself is called a/an:
                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?
                True
                False (*)

19.          A Hierarchical relationship is a series of relationships that reflect entities organized into successive levels. True or False?
                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?
                True (*)
                False

21.          Which of the following would best be represented by an arc?
                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.
                Sameness
                Differences
                Exclusivity (*)
                Inheritance

23.          An arc can often be modeled as Supertype and Subtypes. True or False?
                True (*)
                False

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

25.          Which of the following would be a logical constraint when modeling time for a country entity?
                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. (*)

26.          Which of the following would be a logical constraint when modeling time for a City entity?
                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?
                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?
                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?
                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?
                True
                False (*)

31.          Which of the following scenarios should be modeled so that historical data is kept? (Choose two)
                (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?
                True
                False (*)

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.
                Referential integrity
                Column integrity
                Entity integrity (*)
                User-defined integrity

34.          Foreign keys cannot be null when
                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.
                User-defined integrity (*)
                Entity integrity
                Column integrity
                Referential integrity

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

37.          Column integrity refers to
                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?
                True
                False (*)

39.          One-to-Many Optional to Mandatory becomes a _______________ on the Master table.
                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:
                The Column Name
                The Check Constraint
                The Table Name
                The Primary Key (*)

41.          Relationships on an ERD can only be transformed into UIDs in the physical model? True or False?
                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?
                True
                False (*)

43.          The "Arc Implementation" is a synonym for what type of implementation?
                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?
                True (*)
                False

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

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

47.          In an Oracle database, why would 1_TABLE not work as a table name?
                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'?
                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

49.          In which phases of the System Development Life Cycle will we need to use SQL as a language? (Choose Two)
                (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?
                Build and Transition
                Design and Production
                Strategy and Analysis
                Transition and Production (*)

Oracle Ilearning for Database Design
Pelajar yang menyelesaikan Desain & Pemrograman Database Oracle Academy dengan kursus SQL dapat sebagai gantinya (atau juga) memilih untuk mempersiapkan dan mengikuti ujian sertifikasi SQL Server SQL Expert. Namun, ujian Oracle Database SQL Expert berisi topik tambahan yang akan membutuhkan lebih banyak belajar mandiri dan berlatih sendiri untuk mempersiapkan.

Membutuhkan penyelesaian yang berhasil sebelum Ujian Sertifikasi Oracle Database SQL Expert, Pengantar Oracle Ujian Sertifikasi SQL, atau Oracle Database : Ujian Sertifikasi SQL Fundamentals.

Pembahasan didalam Oracle Ilearning - Oracle Academy

• Oracle Ilearning for Database Design
• Oracle Ilearning for Course Resources
• Oracle Ilearning for Introduction
• Oracle Ilearning for Entities and Attributes
• Oracle Ilearning for Relationship Basics
• Oracle Ilearning for Super/Sub Types and Business Rules
• Oracle Ilearning for Relationship Fundamentals
• Oracle Ilearning for UIDs and Normalization
• Oracle Ilearning for Arcs, Hierarchies, and Recursive Modeling
• Oracle Ilearning for Changes and Historical Modeling
• Oracle Ilearning for Mapping
• Oracle Ilearning for Creating Database Projects
• Oracle Ilearning for Presenting Database Projects
• Oracle Ilearning quiz answers for Database Design English Quizzes and Exams
• Oracle Ilearning quiz answers for Database Design Midterm Exam
• Oracle ilearning quiz answers for Database Design Final Exam

Download Source Code Program