Blog Gue

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

Section 1             (Answer all questions in this section) 1.         The main subject areas taught by the Oracle Academy are:     Mark for Review (1) Points             Data Modeling, SQL, and PL/SQL (*)             Computer Repairs             Database performance tuning             Systems programming and computer architecture 2.         What is the difference between "information" and "data"?      Mark for Review (1) Points             Data turns into useful information. It is stored in a database and accessed by systems and users. (*)             Information and data have no differences - they are two words for the same thing.             Information is held and understood only by users.             Data is held and understood only by users. 3.         Consider your school library. It will have a database with transaction details of the books that are borrowed by students. Is the total number of books out on loan in one given month conside

Section 9 Quiz             (Answer all questions in this section) 1.         When translating an arc relationship to a physical design, you must turn the arc relationships into foreign keys. What additional step must you take with the created foreign keys to ensure the exclusivity principle of arc relationships? (Assume that you are implementing an Exclusive Design) (Choose Two)     Mark for Review (1) Points                                     (Choose all correct answers)             Make all relationships mandatory             Make all relationships optional (*)             Create an additional check constraint to verify that one foreign key is populated and the others are not (*)             All the above 2.         Which of the following is a valid reason for considering a Subtype Implementation?          Mark for Review (1) Points             The common access paths for the supertypes are different.             The resulting table will reside in a single databas