API tools faq
paste
Advertisement
Guest User

loading

a guest
Dec 1st, 2015
105
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 22.45 KB | None | 0 0
raw download clone embed print report
  1. http://oacexam.blogspot.be/2012/10/mid-term-exam-semester-1.html
  2. http://www.scribd.com/doc/249679884/Oracle-Academy-Mid-Term-Exam-Semester-1-Answers#scribd
  3. https://pricimircea.wordpress.com/about/
  4.  
  5. 1. Oracle Database Software provides which of the following functionality? (Choose two) Mark for Review
  6. (1) Points
  7.  
  8. Graphical User Interface (*)
  9.  
  10. Internet Browser
  11.  
  12. Server (*)
  13.  
  14. Operating System
  15.  
  16.  
  17.  
  18. 2. The first step in system development is to document the requirements. Why? Mark for Review
  19. (1) Points
  20.  
  21. Wrong. A blueprint for the database design is not needed. We can just start coding straight away.
  22.  
  23. It clarifies what a business wants to accomplish, and provides measures for deciding if the system delivers all that is required. (*)
  24.  
  25. It allows application development to be conducted without having to consider database design.
  26.  
  27. It keeps businesses honest.
  28.  
  29.  
  30.  
  31. 3. The main subject areas taught by the Oracle Academy are: Mark for Review
  32. (1) Points
  33.  
  34. Computer Repairs
  35.  
  36. Database performance tuning.
  37.  
  38. Data Modeling, SQL and PL/SQL (*)
  39.  
  40. Systems programming and computer architecture
  41.  
  42.  
  43.  
  44. 4. Consider your school library. It will have a database with transaction details of which student borrows which books. Is details of the total number of books out on loan in one given month Data or Information? Mark for Review
  45.  
  46. Data
  47.  
  48. Information (*)
  49.  
  50. Both
  51.  
  52. Neither
  53.  
  54.  
  55.  
  56. 5. Data modelling is performed for the following reasons: (Choose Two) Mark for Review
  57. (1) Points
  58.  
  59. (Choose all correct answers)
  60.  
  61. The ERD’s becomes a blueprint for designing the actual system. (*)
  62.  
  63. It helps discussions and reviews. (*)
  64.  
  65. We do not need datamodels, we can just start coding right away.
  66.  
  67. We just draw the ERD’s to please the users, once they are finished we never look at them again. They serve no purpose in the real world.
  68.  
  69.  
  70.  
  71. 6. Entity and Attribute names are always interchangable, so you need not worry about choosing the right type. True or False? Mark for Review
  72. (1) Points
  73.  
  74. True
  75.  
  76. False (*)
  77.  
  78.  
  79.  
  80. 7. All of the following would be instances of the entity ANIMAL SPECIES except which? Mark for Review
  81. (1) Points
  82.  
  83. Dog
  84.  
  85. Bird
  86.  
  87. Elephant
  88.  
  89. Leaf (*)
  90.  
  91.  
  92.  
  93. 8. The entity/relationship model is created before the physical database design model? True or False? Mark for Review
  94. (1) Points
  95.  
  96. True (*)
  97.  
  98. False
  99.  
  100.  
  101.  
  102. 9. In a physical data model, a relationship is represented as a? Mark for Review
  103. (1) Points
  104.  
  105. Column
  106.  
  107. Row
  108.  
  109. Instance
  110.  
  111. Foreign Key (*)
  112.  
  113.  
  114.  
  115. 10. Volatile entities have special requirements and need special attention when you are doing data modelling. True or False? Mark for Review
  116. (1) Points
  117.  
  118. True (*)
  119.  
  120. False
  121.  
  122. 11. A/an _________ is a picture of all the information that will form the basis for the finished system.
  123. ERD (*)
  124.  
  125.  
  126. 12. When reading an ERD including Relationships you are said to be speaking:
  127. ERDish (*)
  128.  
  129.  
  130. 13. All the Attributes in a system are just written on the ERD, and they all go in the Top Left Hand Corner of the paper. True or False?
  131. False (*)
  132.  
  133.  
  134.  
  135. 14. A Matrix Diagram should be developed by your users. True or False?
  136. False (*)
  137.  
  138.  
  139.  
  140. 15. Relationship Degree/Cardinality is important. True or False? Mark for Review
  141. True (*)
  142.  
  143.  
  144.  
  145. 16. Relationship Names are optional. True or False? Mark for Review
  146. False (*)
  147.  
  148. 17. A new system would have a mixture of both Procedural and Structural Business Rules as part of the documentation of that new system. True or False? Mark for Review
  149. (1) Points
  150. True (*)
  151.  
  152.  
  153.  
  154. 18. The “Other” subtype is mandatory. True or False? Mark for Review
  155. False (*)
  156.  
  157.  
  158.  
  159. 19. A supertype can only have two subtypes and no more. True or False? Mark for Review
  160. (1) Points
  161.  
  162. True
  163.  
  164. False (*)
  165.  
  166.  
  167.  
  168. 20. You can only create relationships to a Supertype, not to a Subtype. True or False? Mark for Review
  169. (1) Points
  170.  
  171. True
  172.  
  173. False (*)
  174.  
  175.  
  176.  
  177. 21. A Supertype can have only one subtype. True or False? Mark for Review
  178. (1) Points
  179.  
  180. True
  181.  
  182. False (*)
  183.  
  184.  
  185.  
  186. 22. When creating entities you must follow these rules: (Choose Two) Mark for Review
  187. (1) Points
  188.  
  189. (Choose all correct answers)
  190.  
  191. Name them in Plural
  192.  
  193. Name them in Singular (*)
  194.  
  195. Exclude Attributes
  196.  
  197. Include Attributes (*)
  198.  
  199.  
  200.  
  201. 23. If a relationship can NOT be moved between instances of the entities it connects, it is said to be: Mark for Review
  202. (1) Points
  203.  
  204. Mandatory
  205.  
  206. Optional
  207.  
  208. Transferrable
  209.  
  210. Non-Transferrable (*)
  211.  
  212.  
  213.  
  214. 24. Which of the following pairs of entities is most likely to be modeled as a M:M relationship? Mark for Review
  215. (1) Points
  216.  
  217. CAR and WHEEL
  218.  
  219. TREE and BRANCH
  220.  
  221. PERSON and FINGERPRINT
  222.  
  223. TEACHER and SUBJECT AREA (*)
  224.  
  225.  
  226.  
  227. 25. If two entities have two relationships between them, these relationships can be either _____________ or _____________ ? Mark for Review
  228. (1) Points
  229.  
  230. Redundant or Required (*)
  231.  
  232. Replicated or Required
  233.  
  234. Resourced and Really Good
  235.  
  236. Redundant and Replicated
  237.  
  238.  
  239.  
  240. 26. What uncommon relationship is described by the statements: “Each DNA SAMPLE may be taken from one and only one PERSON and each PERSON may provide one and only one DNA SAMPLE” Mark for Review
  241. (1) Points
  242.  
  243. One to Many Optional
  244.  
  245. One to Many Mandatory
  246.  
  247. One to One Optional (*)
  248.  
  249. Many to Many Mandatory
  250.  
  251.  
  252.  
  253. 27. How do you include a relationship as part of the UID for an entity? Mark for Review
  254. (1) Points
  255.  
  256. By barring the relationship in question (*)
  257.  
  258. By reporting it in an external document
  259.  
  260. By including the UID from the parent entity as an attribute in the entity
  261.  
  262. You cannot model that.
  263.  
  264.  
  265.  
  266. 28. When you resolve a M-M you simply re-draw the relationships between the two original entities, no new entities are created. True or False? Mark for Review
  267. (1) Points
  268.  
  269. True
  270.  
  271. False (*)
  272.  
  273.  
  274.  
  275. 29. Intersection Entities often have the relationships participating in the UID, so the relationships are often barred. True or False? Mark for Review
  276. (1) Points
  277.  
  278. True (*)
  279.  
  280. False
  281.  
  282.  
  283.  
  284. 30. What do you call the entity created when you resolve a M:M relationship? Mark for Review
  285. (1) Points
  286.  
  287. Intersection entity (*)
  288.  
  289. Inclusion entity
  290.  
  291. Recursive entity
  292.  
  293. M:M entity
  294.  
  295. 31. When is an entity in 2nd Normal Form? Mark for Review
  296. (1) Points
  297.  
  298. When all non-UID attributes are dependent upon the entire UID. (*)
  299.  
  300. When no attritibutes are mutually independant and fully independent on the primary key.
  301.  
  302. When no attritibutes are mutually independent and all are fully dependent on the primary key.
  303.  
  304. None of the Above.
  305.  
  306.  
  307.  
  308. 32. All entities must be given a new artificial UID. True or False? Mark for Review
  309. (1) Points
  310.  
  311. True
  312.  
  313. False (*)
  314.  
  315.  
  316.  
  317. 33. There is no limit to how may UID’s an entity can have. True or False? Mark for Review
  318. (1) Points
  319.  
  320. True (*)
  321.  
  322. False
  323.  
  324.  
  325.  
  326. 34. Normalizing an Entity to 1st Normal Form is done by removing repeated or redundant attributes. True or False? Mark for Review
  327. (1) Points
  328.  
  329. True (*)
  330.  
  331. False
  332.  
  333.  
  334.  
  335. 35. No commercial database systems in the world will accept tables that are not on 3rd Normal Form. True or False? Mark for Review
  336. (1) Points
  337.  
  338. True
  339.  
  340. False (*)
  341.  
  342.  
  343.  
  344. 36. If Audit trail attributes are added to an entity they must be in the entities they are auditing. True or False? Mark for Review
  345. (1) Points
  346.  
  347. True (*)
  348.  
  349. False
  350.  
  351.  
  352.  
  353. 37. Which of the following would be good as a Unique Identifier for its Entity? (Choose Three) Mark for Review
  354. (1) Points
  355.  
  356. (Choose all correct answers)
  357.  
  358. Personal Identification number for Person (*)
  359.  
  360. Vehicle Registration Number for Car (*)
  361.  
  362. ISBN Number for Book (*)
  363.  
  364. Date of birth for Baby
  365.  
  366.  
  367.  
  368. 38. No parts of an UID are mandatory. True or False? Mark for Review
  369. (1) Points
  370.  
  371. True
  372.  
  373. False (*)
  374.  
  375.  
  376.  
  377. 39. Primary UIDs are: Mark for Review
  378. (1) Points
  379.  
  380. Something that each Entity should have, but is not mandatory (*)
  381.  
  382. Useful as an alternative means of identifying instances of an entity, independent of their datatype
  383.  
  384. Mandatory in data modeling
  385.  
  386. Always comprised of numbers
  387.  
  388.  
  389.  
  390. 40. Arcs are Mandatory in Data modeling. All ERD’s must have at least one Arc. True or False? Mark for Review
  391. (1) Points
  392.  
  393. True
  394.  
  395. False (*)
  396.  
  397. 31. When is an entity in 2nd Normal Form? Mark for Review
  398. (1) Points
  399.  
  400. When all non-UID attributes are dependent upon the entire UID. (*)
  401.  
  402. When no attritibutes are mutually independant and fully independent on the primary key.
  403.  
  404. When no attritibutes are mutually independent and all are fully dependent on the primary key.
  405.  
  406. None of the Above.
  407.  
  408.  
  409.  
  410. 32. All entities must be given a new artificial UID. True or False? Mark for Review
  411. (1) Points
  412.  
  413. True
  414.  
  415. False (*)
  416.  
  417.  
  418.  
  419. 33. There is no limit to how may UID’s an entity can have. True or False? Mark for Review
  420. (1) Points
  421.  
  422. True (*)
  423.  
  424. False
  425.  
  426.  
  427.  
  428. 34. Normalizing an Entity to 1st Normal Form is done by removing repeated or redundant attributes. True or False? Mark for Review
  429. (1) Points
  430.  
  431. True (*)
  432.  
  433. False
  434.  
  435.  
  436.  
  437. 35. No commercial database systems in the world will accept tables that are not on 3rd Normal Form. True or False? Mark for Review
  438. (1) Points
  439.  
  440. True
  441.  
  442. False (*)
  443.  
  444.  
  445.  
  446. 36. If Audit trail attributes are added to an entity they must be in the entities they are auditing. True or False? Mark for Review
  447. (1) Points
  448.  
  449. True (*)
  450.  
  451. False
  452.  
  453.  
  454.  
  455. 37. Which of the following would be good as a Unique Identifier for its Entity? (Choose Three) Mark for Review
  456. (1) Points
  457.  
  458. (Choose all correct answers)
  459.  
  460. Personal Identification number for Person (*)
  461.  
  462. Vehicle Registration Number for Car (*)
  463.  
  464. ISBN Number for Book (*)
  465.  
  466. Date of birth for Baby
  467.  
  468.  
  469.  
  470. 38. No parts of an UID are mandatory. True or False? Mark for Review
  471. (1) Points
  472.  
  473. True
  474.  
  475. False (*)
  476.  
  477.  
  478.  
  479. 39. Primary UIDs are: Mark for Review
  480. (1) Points
  481.  
  482. Something that each Entity should have, but is not mandatory (*)
  483.  
  484. Useful as an alternative means of identifying instances of an entity, independent of their datatype
  485.  
  486. Mandatory in data modeling
  487.  
  488. Always comprised of numbers
  489.  
  490.  
  491.  
  492. 40. Arcs are Mandatory in Data modeling. All ERD’s must have at least one Arc. True or False? Mark for Review
  493. (1) Points
  494.  
  495. True
  496.  
  497. False (*)
  498.  
  499.  
  500.  
  501. 41. All relationships participating in an arc must be mandatory. True or False? Mark for Review
  502. (1) Points
  503.  
  504. True
  505.  
  506. False (*)
  507.  
  508.  
  509.  
  510. 42. An arc can also be modeled as Supertype and Subtypes. True or False? Mark for Review
  511. (1) Points
  512.  
  513. True (*)
  514.  
  515. False
  516.  
  517.  
  518.  
  519. 43. Modeling historical data is Optional. True or False? Mark for Review
  520. (1) Points
  521.  
  522. True (*)
  523.  
  524. False
  525.  
  526.  
  527.  
  528. 44. When you add the concept of time to your data model, your model becomes more complex. True or False? Mark for Review
  529. (1) Points
  530.  
  531. True (*)
  532.  
  533. False
  534.  
  535.  
  536.  
  537. 45. Which of the following is a logical constraint that could result from considering how time impacts an example of data storage? Mark for Review
  538. (1) Points
  539.  
  540. An ASSIGNMENT may only refer to an EMPLOYEE with a valid employee record at the Start Date of the ASSIGNMENT. (*)
  541.  
  542. EMPLOYEE periods can overlap causing the database to crash.
  543.  
  544. End Date must be before the Start Date.
  545.  
  546. Dates must be stored with Time.
  547.  
  548.  
  549.  
  550. 46. All systems must include functionality to provide logging or journaling in conceptual data models. True or False? Mark for Review
  551. (1) Points
  552.  
  553. True
  554.  
  555. False (*)
  556.  
  557.  
  558.  
  559. 47. All datamodels must be transformed from specific to generic. True or False? Mark for Review
  560. (1) Points
  561.  
  562. True
  563.  
  564. False (*)
  565.  
  566.  
  567.  
  568. 48. A datamodel containing generic modeling techniques must not be mixed in with non-generic models. The generic entities MUST be drawn on a diagram of their own. True or False? Mark for Review
  569. (1) Points
  570.  
  571. True
  572.  
  573. False (*)
  574.  
  575.  
  576.  
  577. 49. There is no point in trying to group your entities together on your diagram according to volume. Making a diagram pretty is a waste of time. True or False? Mark for Review
  578. (1) Points
  579.  
  580. True
  581.  
  582. False (*)
  583.  
  584.  
  585.  
  586. 50. Which of the following statements are true for ERD’s to enhance their readability. (Choose Two) Mark for Review
  587. (1) Points
  588.  
  589. (Choose all correct answers)
  590.  
  591. Is is OK to break a big ERD down into subsets of the overall picture. This way you end up with more than one ERD, that together documents the entire system. (*)
  592.  
  593. Try to avoid crossing lines (*)
  594.  
  595. The crows feet (many ends) can point whichever way is the easiest to draw
  596.  
  597. You must ensure you have all the entities on one single, big diagram, even if you have hundreds
  598.  
  599. 1. Entities are transformed into Tables during the Database Design process. True or False? Mark for Review
  600. (1) Points
  601.  
  602. True (*)
  603.  
  604. False
  605.  
  606.  
  607.  
  608. 2. Oracle Database Software provides which of the following functionality? (Choose two) Mark for Review
  609. (1) Points
  610.  
  611. (Choose all correct answers)
  612.  
  613. Graphical User Interface (*)
  614.  
  615. Internet Browser
  616.  
  617. Server (*)
  618.  
  619. Operating System
  620.  
  621.  
  622.  
  623. 3. Consider your school library. It will have a database with transaction details of which student borrows which books. Is details of the total number of books out on loan in one given month Data or Information? Mark for Review
  624. (1) Points
  625.  
  626. Data
  627.  
  628. Information (*)
  629.  
  630. Both
  631.  
  632. Neither
  633.  
  634.  
  635.  
  636. 4. The main subject areas taught by the Oracle Academy are: Mark for Review
  637. (1) Points
  638.  
  639. Computer Repairs
  640.  
  641. Database performance tuning.
  642.  
  643. Data Modeling, SQL and PL/SQL (*)
  644.  
  645. Systems programming and computer architecture
  646.  
  647. 5. Data modelling is performed for the following reasons: (Choose Two) Mark for Review
  648. (1) Points
  649.  
  650. (Choose all correct answers)
  651.  
  652. The ERD’s becomes a blueprint for designing the actual system. (*)
  653.  
  654. It helps discussions and reviews. (*)
  655.  
  656. We do not need datamodels, we can just start coding right away.
  657.  
  658. We just draw the ERD’s to please the users, once they are finished we never look at them again. They serve no purpose in the real world.
  659.  
  660.  
  661. 6. Entity Relationship modeling is dependent on the hardware or software used for implementation, so you will need to change your ERD if you decide to change Hardware Vendor. True or False? Mark for Review
  662. (1) Points
  663.  
  664. True
  665.  
  666. False (*)
  667.  
  668.  
  669.  
  670. 7. All of the following could be attributes of an ENTITY called PERSON except one. Select the incorrect one: Mark for Review
  671. (1) Points
  672.  
  673. Haircolor
  674.  
  675. Weight
  676.  
  677. Gender
  678.  
  679. Natacha Hansen (*)
  680.  
  681. Correct
  682.  
  683. 8. Which of the following statements about relationships are true? (Choose Two) Mark for Review
  684. (1) Points
  685.  
  686. (Choose all correct answers)
  687.  
  688. They become foreign keys in the database. (*)
  689.  
  690. They must be mandatory to be created in the database.
  691.  
  692. They can be either mandatory or optional. (*)
  693.  
  694. They must exist between two different Entities.
  695.  
  696.  
  697.  
  698. 9. Volatile entities have special requirements and need special attention when you are doing data modelling. True or False? Mark for Review
  699. (1) Points
  700.  
  701. True (*)
  702.  
  703. False
  704.  
  705.  
  706.  
  707. 10. All of the following would be instances of the entity ANIMAL SPECIES except which? Mark for Review
  708. (1) Points
  709.  
  710. Dog
  711.  
  712. Bird
  713.  
  714. Elephant
  715.  
  716. Leaf (*)
  717.  
  718.  
  719.  
  720. 11. An entity is instantiated as a ? Mark for Review
  721. (1) Points
  722.  
  723. Experience
  724.  
  725. Instance
  726.  
  727. Table (*)
  728.  
  729. None of the above
  730.  
  731.  
  732.  
  733. 12. Relationship Degree/Cardinality is important. True or False? Mark for Review
  734. (1) Points
  735.  
  736. True (*)
  737.  
  738. False
  739.  
  740.  
  741.  
  742. 13. Which of the following are valid relationship degrees? (Choose two) Mark for Review
  743. (1) Points
  744.  
  745. (Choose all correct answers)
  746.  
  747. 1:1 (*)
  748.  
  749. 1:M (*)
  750.  
  751. 1:O
  752.  
  753. O:O
  754.  
  755.  
  756.  
  757. 14. Matrix Diagrams are mandatory when doing data modelling. True or False? Mark for Review
  758. (1) Points
  759.  
  760. True
  761.  
  762. False (*)
  763.  
  764.  
  765.  
  766. 15. A Matrix Diagram should be developed by your users. True or False? Mark for Review
  767. (1) Points
  768.  
  769. True
  770.  
  771. False (*)
  772.  
  773.  
  774.  
  775. 16. Entity names are always singular. True or False? Mark for Review
  776. (1) Points
  777.  
  778. True (*)
  779.  
  780. False
  781.  
  782.  
  783.  
  784. 17. A new system would have a mixture of both Procedural and Structural Business Rules as part of the documentation of that new system. True or False? Mark for Review
  785. (1) Points
  786.  
  787. True (*)
  788.  
  789. False
  790.  
  791.  
  792.  
  793. 18. When creating entities you must follow these rules: (Choose Two) Mark for Review
  794. (1) Points
  795.  
  796. (Choose all correct answers)
  797.  
  798. Name them in Plural
  799.  
  800. Name them in Singular (*)
  801.  
  802. Exclude Attributes
  803.  
  804. Include Attributes (*)
  805.  
  806.  
  807.  
  808. 19. You can only create relationships to a Supertype, not to a Subtype. True or False? Mark for Review
  809. (1) Points
  810.  
  811. True
  812.  
  813. False (*)
  814.  
  815.  
  816.  
  817. 20. All ER diagrams must have one of each of the following: (Choose two) Mark for Review
  818. (1) Points
  819.  
  820. (Choose all correct answers)
  821.  
  822. One or more Entities (*)
  823.  
  824. Relationships between entities (*)
  825.  
  826. Arcs
  827.  
  828. At least one supertype and subtype
  829.  
  830. 21. The “Other” subtype is mandatory. True or False? Mark for Review
  831. (1) Points
  832.  
  833. True
  834.  
  835. False (*)
  836.  
  837.  
  838.  
  839. 22. A Supertype can have only one subtype. True or False? Mark for Review
  840. (1) Points
  841.  
  842. True
  843.  
  844. False (*)
  845.  
  846.  
  847.  
  848. 23. Intersection Entities are at the Master end in the relationships between it and the original entities. So the original entities are details or children of the newly created intersection entity. True or False? Mark for Review
  849. (1) Points
  850.  
  851. True
  852.  
  853. False (*)
  854.  
  855.  
  856.  
  857. 24. When you resolve a M-M you simply re-draw the relationships between the two original entities, no new entities are created. True or False? Mark for Review
  858. (1) Points
  859.  
  860. True
  861.  
  862. False (*)
  863.  
  864.  
  865.  
  866. 25. Intersection Entities often have the relationships participating in the UID, so the relationships are often barred. True or False? Mark for Review
  867. (1) Points
  868.  
  869. True (*)
  870.  
  871. False
  872.  
  873.  
  874.  
  875. 26. If a relationship can NOT be moved between instances of the entities it connects, it is said to be: Mark for Review
  876. (1) Points
  877.  
  878. Mandatory
  879.  
  880. Optional
  881.  
  882. Transferrable
  883.  
  884. Non-Transferrable (*)
  885.  
  886.  
  887.  
  888. 27. What uncommon relationship is described by the statements: “Each DNA SAMPLE may be taken from one and only one PERSON and each PERSON may provide one and only one DNA SAMPLE” Mark for Review
  889. (1) Points
  890.  
  891. One to Many Optional
  892.  
  893. One to Many Mandatory
  894.  
  895. One to One Optional (*)
  896.  
  897. Many to Many Mandatory
  898.  
  899.  
  900.  
  901. 28. How do you include a relationship as part of the UID for an entity? Mark for Review
  902. (1) Points
  903.  
  904. By barring the relationship in question (*)
  905.  
  906. By reporting it in an external document
  907.  
  908. By including the UID from the parent entity as an attribute in the entity
  909.  
  910. You cannot model that.
  911.  
  912.  
  913.  
  914. 29. Many to many relationships must be left in the Model. It is important to have them documented as M-M. True or False? Mark for Review
  915. (1) Points
  916.  
  917. True
  918.  
  919. False (*)
  920.  
  921.  
  922.  
  923. 30. Which of the following pairs of entities is most likely to be modeled as a M:M relationship? Mark for Review
  924. (1) Points
  925.  
  926. CAR and WHEEL
  927.  
  928. TREE and BRANCH
  929.  
  930. PERSON and FINGERPRINT
  931.  
  932. TEACHER and SUBJECT AREA (*)
  933.  
  934. 31. The first UID for an entity is called the Primary UID, the second is called Secondary UID and so on. Mark for Review
  935. (1) Points
  936.  
  937. Yes, this is the way UID’s are named. (*)
  938.  
  939. No, it is not possible to have more than one UID for an Entity.
  940.  
  941. Yes, but then it stops. No entities can have more than two UID’s.
  942.  
  943. No, each Entity can only have one UID, the secondary one.
  944.  
  945.  
  946.  
  947. 32. There is no limit to how may UID’s an entity can have. True or False? Mark for Review
  948. (1) Points
  949.  
  950. True (*)
  951.  
  952. False
  953.  
  954.  
  955.  
  956. 33. 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
  957. (1) Points
  958.  
  959. True
  960.  
  961. False (*)
  962.  
  963.  
  964.  
  965. 34. Would it be a good idea to model age as an attribute of STUDENT? Mark for Review
  966. (1) Points
  967.  
  968. Yes
  969.  
  970. Maybe it could stop us having to calculate someone’s age every time we need it
  971.  
  972. Sometimes
  973.  
  974. No – it breaks the Normalization rules (*)
  975.  
  976.  
  977.  
  978. 35. Until all attributes are single-valued, the database model is said to be: Mark for Review
  979. (1) Points
  980.  
  981. Normalized
  982.  
  983. Not Normalized (*)
  984.  
  985. 1st Normal Form
  986.  
  987. 2nd Normal Form
  988.  
  989. Incorrect. Refer to Section 6 Lesson 2.
  990.  
  991.  
  992.  
  993. 36. Primary UIDs are: Mark for Review
  994. (1) Points
  995.  
  996. Something that each Entity should have, but is not mandatory (*)
  997.  
  998. Useful as an alternative means of identifying instances of an entity, independent of their datatype
  999.  
  1000. Mandatory in data modeling
  1001.  
  1002. Always comprised of numbers
  1003.  
  1004.  
  1005.  
  1006. 37. Which of the following is NOT a relationship type? Mark for Review
  1007. (1) Points
  1008.  
  1009. Some to None (*)
  1010.  
  1011. One to One
  1012.  
  1013. One to Many
  1014.  
  1015. Many to Many
  1016.  
  1017.  
  1018.  
  1019. 38. No parts of an UID are mandatory. True or False? Mark for Review
  1020. (1) Points
  1021.  
  1022. True
  1023.  
  1024. False (*)
  1025.  
  1026.  
  1027.  
  1028. 39. Which of the following would best be represented by an arc? Mark for Review
  1029. (1) Points
  1030.  
  1031. TEACHER (Female, Bob)
  1032.  
  1033. DELIVERY ADDRESS (Home, Office) (*)
  1034.  
  1035. PARENT (Girl, Bob)
  1036.  
  1037. STUDENT (Grade A student, Average Student)
  1038.  
  1039.  
  1040.  
  1041. 40. Arcs are Mandatory in Data modeling. All ERD’s must have at least one Arc. True or False? Mark for Review
  1042. (1) Points
  1043.  
  1044. True
  1045.  
  1046. False (*)
  1047.  
  1048. 41. Historical data must never be kept. True or False? Mark for Review
  1049. (1) Points
  1050.  
  1051. True
  1052.  
  1053. False (*)
  1054.  
  1055.  
  1056.  
  1057. 42. A recursive relationship must Mandatory at both ends. True or False? Mark for Review
  1058. (1) Points
  1059.  
  1060. True
  1061.  
  1062. False (*)
  1063.  
  1064.  
  1065.  
  1066. 43. If a system includes the concept of time and it stores Start Dates, then End Dates becomes Mandatory. For each Start Date attribute you create, you MUST create an End Date attribute and it must be mandatory. True or False? Mark for Review
  1067. (1) Points
  1068.  
  1069. True
  1070.  
  1071. False (*)
  1072.  
  1073.  
  1074.  
  1075. 44. All systems must have an entity called WEEK with a holiday attribute, so you know when to give your employees a holiday. True or False? Mark for Review
  1076. (1) Points
  1077.  
  1078. True
  1079.  
  1080. False (*)
  1081.  
  1082.  
  1083.  
  1084. 45. All systems must include functionality to provide logging or journaling in conceptual data models. True or False? Mark for Review
  1085. (1) Points
  1086.  
  1087. True
  1088.  
  1089. False (*)
  1090.  
  1091.  
  1092.  
  1093. 46. Which of the following is a logical constraint that could result from considering how time impacts an example of data storage? Mark for Review
  1094. (1) Points
  1095.  
  1096. An ASSIGNMENT may only refer to an EMPLOYEE with a valid employee record at the Start Date of the ASSIGNMENT. (*)
  1097.  
  1098. EMPLOYEE periods can overlap causing the database to crash.
  1099.  
  1100. End Date must be before the Start Date.
  1101.  
  1102. Dates must be stored with Time.
  1103.  
  1104.  
  1105.  
  1106. 47. All datamodels must be transformed from specific to generic. True or False? Mark for Review
  1107. (1) Points
  1108.  
  1109. True
  1110.  
  1111. False (*)
  1112.  
  1113.  
  1114.  
  1115. 48. Generic models are generally far more complex than a specific model. True or False? Mark for Review
  1116. (1) Points
  1117.  
  1118. True
  1119.  
  1120. False (*)
  1121.  
  1122.  
  1123.  
  1124. 49. There are formal rules for how to draw ERD’s, even though they are only guidelines, you should always try to follow them. True or False? Mark for Review
  1125. (1) Points
  1126.  
  1127. True (*)
  1128.  
  1129. False
  1130.  
  1131.  
  1132.  
  1133. 50. There is no point in trying to group your entities together on your diagram according to volume. Making a diagram pretty is a waste of time. True or False? Mark for Review
  1134. (1) Points
  1135.  
  1136. True
  1137.  
  1138. False (*)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!