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

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

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