API tools faq
paste
Advertisement
Guest User

Test: Mid Term Exam Semester 1

a guest
Nov 24th, 2014
1,340
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 15.70 KB | None | 0 0
raw download clone embed print report
  1. 2013-2015 Oracle Academy English Database Design - Student
  2. Test: Mid Term Exam Semester 1
  3. Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.
  4.  
  5.     Section 1
  6.     (Answer all questions in this section)
  7.                    
  8.         1.  Entities are transformed into Tables during the Database Design process. True or False?  Mark for Review
  9. (1) Points
  10.                    
  11.            
  12.     True (*)
  13.  
  14.            
  15.     False
  16.  
  17.                    
  18.                
  19. Correct     Correct
  20.  
  21.                    
  22.         2.  Databases were invented in 1989? True or False?  Mark for Review
  23. (1) Points
  24.                    
  25.            
  26.     True
  27.  
  28.            
  29.     False (*)
  30.  
  31.                    
  32.                
  33. Correct     Correct
  34.  
  35.                    
  36.         3.  The market for IT professionals is still increasing and will continue to do so in the future as the world gets ever more dependent on computer systems. True or False?   Mark for Review
  37. (1) Points
  38.                    
  39.            
  40.     True (*)
  41.  
  42.            
  43.     False
  44.  
  45.                    
  46.                
  47. Correct     Correct
  48.  
  49.                    
  50.         4.  What is the difference between "information" and "data"?     Mark for Review
  51. (1) Points
  52.                    
  53.            
  54.     Data is held and understood only by users.
  55.  
  56.            
  57.     Information is held and understood only by users.
  58.  
  59.            
  60.     Information and data have no differences - they are two words for the same thing.
  61.  
  62.            
  63.     Data turns into useful information. It is stored in a database and accessed by systems and users. (*)
  64.  
  65.                    
  66.                
  67. Correct     Correct
  68.  
  69.                    
  70.  
  71.                    
  72.     Section 2
  73.     (Answer all questions in this section)
  74.                    
  75.         5.  The Physical Model is derived from the Conceptual Model. True or False?  Mark for Review
  76. (1) Points
  77.                    
  78.            
  79.     True (*)
  80.  
  81.            
  82.     False
  83.  
  84.                    
  85.                
  86. Correct     Correct
  87.  
  88.                    
  89.         6.  Which of the following are examples of ENTITY: Instance ? (Choose Two)   Mark for Review
  90. (1) Points
  91.                    
  92.             (Choose all correct answers)   
  93.                    
  94.            
  95.     TRANSPORTATION METHOD: Car (*)
  96.  
  97.            
  98.     ANIMAL: Dog (*)
  99.  
  100.            
  101.     MEAT PRODUCT: Lettuce
  102.  
  103.            
  104.     BODY PART: Larry Ellison
  105.  
  106.                    
  107.                
  108. Correct     Correct
  109.  
  110.                    
  111.         7.  Volatile attributes have special requirements and need special attention when you are doing data modelling. True or False?   Mark for Review
  112. (1) Points
  113.                    
  114.            
  115.     True (*)
  116.  
  117.            
  118.     False
  119.  
  120.                    
  121.                
  122. Correct     Correct
  123.  
  124.                    
  125.         8.  A/an _________ is a picture of all the information that will form the basis for the finished system.     Mark for Review
  126. (1) Points
  127.                    
  128.            
  129.     ERD (*)
  130.  
  131.            
  132.     Process
  133.  
  134.            
  135.     Table
  136.  
  137.            
  138.     Attribute
  139.  
  140.                    
  141.                
  142. Correct     Correct
  143.  
  144.                    
  145.         9.  In a physical data model, a relationship is represented as a/an?     Mark for Review
  146. (1) Points
  147.                    
  148.            
  149.     Column
  150.  
  151.            
  152.     Row
  153.  
  154.            
  155.     Instance
  156.  
  157.            
  158.     Foreign Key (*)
  159.  
  160.                    
  161.                
  162. Correct     Correct
  163.  
  164.                    
  165.         10.     Relationship names are usually verbs. True or False?     Mark for Review
  166. (1) Points
  167.                    
  168.            
  169.     True (*)
  170.  
  171.            
  172.     False
  173.  
  174.                    
  175.                
  176. Correct     Correct
  177.  
  178.                    
  179. Page 1 of 5 Next    Summary
  180.  
  181.  
  182.  
  183. Test: Mid Term Exam Semester 1
  184. Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.
  185.  
  186.     Section 2
  187.     (Answer all questions in this section)
  188.                    
  189.         11.     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
  190. (1) Points
  191.                    
  192.            
  193.     True
  194.  
  195.            
  196.     False (*)
  197.  
  198.                    
  199.                
  200. Correct     Correct
  201.  
  202.                    
  203.  
  204.                    
  205.     Section 3
  206.     (Answer all questions in this section)
  207.                    
  208.         12.     Which of the following are true about Cardinality? (Choose two)  Mark for Review
  209. (1) Points
  210.                    
  211.             (Choose all correct answers)   
  212.                    
  213.            
  214.     Cardinality tells "how many". (*)
  215.  
  216.            
  217.     Cardinality specifies only singularity or plurality, but not a specific plural number. (*)
  218.  
  219.            
  220.     Cardinality specifies a counting number (like 1, 2, 3, 4 etc.) in a relationship.
  221.  
  222.            
  223.     Cardinality specifies whether something is required or not.
  224.  
  225.                    
  226.                
  227. Correct     Correct
  228.  
  229.                    
  230.         13.     One Relationship can be mandatory in one direction and optional in the other direction. True or False?   Mark for Review
  231. (1) Points
  232.                    
  233.            
  234.     True (*)
  235.  
  236.            
  237.     False
  238.  
  239.                    
  240.                
  241. Correct     Correct
  242.  
  243.                    
  244.         14.     A Matrix Diagram should be developed by the end-users of your database. True or False?   Mark for Review
  245. (1) Points
  246.                    
  247.            
  248.     True
  249.  
  250.            
  251.     False (*)
  252.  
  253.                    
  254.                
  255. Correct     Correct
  256.  
  257.                    
  258.         15.     Which symbol is used to show that a particular attribute is mandatory?   Mark for Review
  259. (1) Points
  260.                    
  261.            
  262.     * (*)
  263.  
  264.            
  265.     o
  266.  
  267.            
  268.     #
  269.  
  270.            
  271.     &
  272.  
  273.                    
  274.                
  275. Correct     Correct
  276.  
  277.                    
  278.         16.     Two entities can ONLY have one relationship between them. True or False?     Mark for Review
  279. (1) Points
  280.                    
  281.            
  282.     True
  283.  
  284.            
  285.     False (*)
  286.  
  287.                    
  288.                
  289. Correct     Correct
  290.  
  291.                    
  292.  
  293.                    
  294.     Section 4
  295.     (Answer all questions in this section)
  296.                    
  297.         17.     "Only teachers may supervise exams" is an example of which of the following?     Mark for Review
  298. (1) Points
  299.                    
  300.            
  301.     A procedural business rule (*)
  302.  
  303.            
  304.     An attribute that should be stored on the PERSON entity
  305.  
  306.            
  307.     A structural business rule
  308.  
  309.            
  310.     An attribute that is not be inherited from the PERSON supertype and is unique to the TEACHER subtype
  311.  
  312.                    
  313.                
  314. Correct     Correct
  315.  
  316.                    
  317.         18.     You can only create relationships to a Supertype, not to a Subtype. True or False?   Mark for Review
  318. (1) Points
  319.                    
  320.            
  321.     True
  322.  
  323.            
  324.     False (*)
  325.  
  326.                    
  327.                
  328. Correct     Correct
  329.  
  330.                    
  331.         19.     All ER diagrams must have one of each of the following: (Choose two)     Mark for Review
  332. (1) Points
  333.                    
  334.             (Choose all correct answers)   
  335.                    
  336.            
  337.     One or more Entities (*)
  338.  
  339.            
  340.     Relationships between entities (*)
  341.  
  342.            
  343.     Arcs
  344.  
  345.            
  346.     At least one supertype and subtype
  347.  
  348.                    
  349.                
  350. Correct     Correct
  351.  
  352.                    
  353.         20.     When creating entities you must follow these rules: (Choose Two)     Mark for Review
  354. (1) Points
  355.                    
  356.             (Choose all correct answers)   
  357.                    
  358.            
  359.     Name them in Plural
  360.  
  361.            
  362.     Name them in Singular (*)
  363.  
  364.            
  365.     Exclude Attributes
  366.  
  367.            
  368.     Include Attributes (*)
  369.  
  370.                    
  371.                
  372. Correct     Correct
  373.  
  374.                    
  375. Previous    Page 2 of 5 Next    Summary
  376.  
  377.  
  378.  
  379. Test: Mid Term Exam Semester 1
  380. Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.
  381.  
  382.     Section 4
  383.     (Answer all questions in this section)
  384.                    
  385.         21.     A Supertype can have only one subtype. True or False?    Mark for Review
  386. (1) Points
  387.                    
  388.            
  389.     True
  390.  
  391.            
  392.     False (*)
  393.  
  394.                    
  395.                
  396. Correct     Correct
  397.  
  398.                    
  399.         22.     A supertype can only have two subtypes and no more. True or False?   Mark for Review
  400. (1) Points
  401.                    
  402.            
  403.     True
  404.  
  405.            
  406.     False (*)
  407.  
  408.                    
  409.                
  410. Correct     Correct
  411.  
  412.                    
  413.  
  414.                    
  415.     Section 5
  416.     (Answer all questions in this section)
  417.                    
  418.         23.     If a relationship can NOT be moved between instances of the entities it connects, it is said to be:  Mark for Review
  419. (1) Points
  420.                    
  421.            
  422.     Mandatory
  423.  
  424.            
  425.     Optional
  426.  
  427.            
  428.     Transferable
  429.  
  430.            
  431.     Non-Transferable (*)
  432.  
  433.                    
  434.                
  435. Correct     Correct
  436.  
  437.                    
  438.         24.     Which of the following pairs of entities is most likely to be modeled as a M:M relationship?     Mark for Review
  439. (1) Points
  440.                    
  441.            
  442.     CAR and WHEEL
  443.  
  444.            
  445.     TREE and BRANCH
  446.  
  447.            
  448.     PERSON and FINGERPRINT
  449.  
  450.            
  451.     TEACHER and SUBJECT AREA (*)
  452.  
  453.                    
  454.                
  455. Correct     Correct
  456.  
  457.                    
  458.         25.     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
  459. (1) Points
  460.                    
  461.            
  462.     True
  463.  
  464.            
  465.     False (*)
  466.  
  467.                    
  468.                
  469. Correct     Correct
  470.  
  471.                    
  472.         26.     Relationships can be Redundant. True or False?   Mark for Review
  473. (1) Points
  474.                    
  475.            
  476.     True (*)
  477.  
  478.            
  479.     False
  480.  
  481.                    
  482.                
  483. Correct     Correct
  484.  
  485.                    
  486.         27.     If two entities have two relationships between them, these relationships can be either _____________ or _____________ .  Mark for Review
  487. (1) Points
  488.                    
  489.            
  490.     Redundant or Required (*)
  491.  
  492.            
  493.     Replicated or Required
  494.  
  495.            
  496.     Resourced and Really Good
  497.  
  498.            
  499.     Redundant and Replicated
  500.  
  501.                    
  502.                
  503. Correct     Correct
  504.  
  505.                    
  506.         28.     What do you call the entity created when you resolve a M:M relationship?     Mark for Review
  507. (1) Points
  508.                    
  509.            
  510.     Intersection entity (*)
  511.  
  512.            
  513.     Inclusion entity
  514.  
  515.            
  516.     Recursive entity
  517.  
  518.            
  519.     M:M entity
  520.  
  521.                    
  522.                
  523. Correct     Correct
  524.  
  525.                    
  526.         29.     Intersection Entities are at the Parent end of the newly created 1:M (Parent:Child) relationship; therefore, the original entities are the children of the newly created intersection entity. True or False?     Mark for Review
  527. (1) Points
  528.                    
  529.            
  530.     True
  531.  
  532.            
  533.     False (*)
  534.  
  535.                    
  536.                
  537. Incorrect       Incorrect. Refer to Section 5 Lesson 3.
  538.  
  539.                    
  540.         30.     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
  541. (1) Points
  542.                    
  543.            
  544.     True
  545.  
  546.            
  547.     False (*)
  548.  
  549.                    
  550.                
  551. Correct     Correct
  552.  
  553.                    
  554. Previous    Page 3 of 5 Next    Summary
  555.  
  556.  
  557.  
  558. Test: Mid Term Exam Semester 1
  559. Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.
  560.  
  561.     Section 6
  562.     (Answer all questions in this section)
  563.                    
  564.         31.     Until all attributes are single-valued, the database model is said to be:    Mark for Review
  565. (1) Points
  566.                    
  567.            
  568.     Normalized
  569.  
  570.            
  571.     Not Normalized (*)
  572.  
  573.            
  574.     in 1st Normal Form
  575.  
  576.            
  577.     in 2nd Normal Form
  578.  
  579.                    
  580.                
  581. Correct     Correct
  582.  
  583.                    
  584.         32.     No commercial database systems in the world will accept tables that are not on 3rd Normal Form. True or False?   Mark for Review
  585. (1) Points
  586.                    
  587.            
  588.     True
  589.  
  590.            
  591.     False (*)
  592.  
  593.                    
  594.                
  595. Correct     Correct
  596.  
  597.                    
  598.         33.     When is an entity in 2nd Normal Form?    Mark for Review
  599. (1) Points
  600.                    
  601.            
  602.     When all non-UID attributes are dependent upon the entire UID. (*)
  603.  
  604.            
  605.     When attributes with repeating or multi-values are removed.
  606.  
  607.            
  608.     When no attritibutes are mutually independent and all are fully dependent on the primary key.
  609.  
  610.            
  611.     None of the Above.
  612.  
  613.                    
  614.                
  615. Correct     Correct
  616.  
  617.                    
  618.         34.     People are not born with "numbers", but a lot of systems assign student numbers, customer IDs, etc. οΎ A shoe has a color, a size, a style, but may not have a descriptive "number". So, to be able to uniquely and efficiently identify one instance of the entity SHOE, a/an ______________ UID can be created.    Mark for Review
  619. (1) Points
  620.                    
  621.            
  622.     Artificial (*)
  623.  
  624.            
  625.     Unrealistic
  626.  
  627.            
  628.     Structured
  629.  
  630.            
  631.     Identification
  632.  
  633.                    
  634.                
  635. Correct     Correct
  636.  
  637.                    
  638.         35.     There is no limit to how many columns that can make up an entity's UID. True or False?   Mark for Review
  639. (1) Points
  640.                    
  641.            
  642.     True (*)
  643.  
  644.            
  645.     False
  646.  
  647.                    
  648.                
  649. Correct     Correct
  650.  
  651.                    
  652.  
  653.                    
  654.     Section 7
  655.     (Answer all questions in this section)
  656.                    
  657.         36.     A single relationship can be both Recursive and Hierarchical at the same time. True or False?    Mark for Review
  658. (1) Points
  659.                    
  660.            
  661.     True
  662.  
  663.            
  664.     False (*)
  665.  
  666.                    
  667.                
  668. Correct     Correct
  669.  
  670.                    
  671.         37.     An arc can also be modeled as Supertype and Subtypes. True or False?     Mark for Review
  672. (1) Points
  673.                    
  674.            
  675.     True (*)
  676.  
  677.            
  678.     False
  679.  
  680.                    
  681.                
  682. Correct     Correct
  683.  
  684.                    
  685.         38.     Primary UIDs are:    Mark for Review
  686. (1) Points
  687.                    
  688.            
  689.     Something that each Entity should have, but is not mandatory (*)
  690.  
  691.            
  692.     Useful as an alternative means of identifying instances of an entity, independent of their datatype
  693.  
  694.            
  695.     Mandatory in data modeling
  696.  
  697.            
  698.     Always comprised of numbers
  699.  
  700.                    
  701.                
  702. Correct     Correct
  703.  
  704.                    
  705.         39.     No parts of an UID are mandatory. True or False?     Mark for Review
  706. (1) Points
  707.                    
  708.            
  709.     True
  710.  
  711.            
  712.     False (*)
  713.  
  714.                    
  715.                
  716. Correct     Correct
  717.  
  718.                    
  719.         40.     Which of the following would best be represented by an arc?  Mark for Review
  720. (1) Points
  721.                    
  722.            
  723.     TEACHER (Female, Bob)
  724.  
  725.            
  726.     DELIVERY ADDRESS (Home, Office) (*)
  727.  
  728.            
  729.     PARENT (Girl, Bob)
  730.  
  731.            
  732.     STUDENT (Grade A student, Average Student)
  733.  
  734.                    
  735.                
  736. Correct     Correct
  737.  
  738.                    
  739. Previous    Page 4 of 5 Next    Summary
  740.  
  741.  
  742.  
  743. Test: Mid Term Exam Semester 1
  744. Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.
  745.  
  746.     Section 7
  747.     (Answer all questions in this section)
  748.                    
  749.         41.     All relationships participating in an arc must be mandatory. True or False?  Mark for Review
  750. (1) Points
  751.                    
  752.            
  753.     True
  754.  
  755.            
  756.     False (*)
  757.  
  758.                    
  759.                
  760. Correct     Correct
  761.  
  762.                    
  763.         42.     Modeling historical data can produce a unique identifier that always excludes dates. True or False?  Mark for Review
  764. (1) Points
  765.                    
  766.            
  767.     True
  768.  
  769.            
  770.     False (*)
  771.  
  772.                    
  773.                
  774. Correct     Correct
  775.  
  776.                    
  777.  
  778.                    
  779.     Section 9
  780.     (Answer all questions in this section)
  781.                    
  782.         43.     Which of the following is a logical constraint that could result from considering how time impacts an example of data storage?   Mark for Review
  783. (1) Points
  784.                    
  785.            
  786.     An ASSIGNMENT may only refer to an EMPLOYEE with a valid employee record at the Start Date of the ASSIGNMENT. (*)
  787.  
  788.            
  789.     EMPLOYEE periods can overlap causing the database to crash.
  790.  
  791.            
  792.     End Date must be before the Start Date.
  793.  
  794.            
  795.     Dates must be stored with Time.
  796.  
  797.                    
  798.                
  799. Correct     Correct
  800.  
  801.                    
  802.         44.     You are doing a data model for a computer sales company where the price of postage depends upon the day of the week that goods are shipped. So shipping is more expensive if the customer wants a delivery to take place on a Saturday or Sunday. What would be the best way to model this?  Mark for Review
  803. (1) Points
  804.                    
  805.            
  806.     Use a Delivery Day entity, which holds prices against week days, and ensure the we also have an attribute for the Requested Delivery Day in the Order Entity. (*)
  807.  
  808.            
  809.     Email current prices to all employees whenever a price changes.
  810.  
  811.            
  812.     Update the prices in the system, print out the current prices when they change, and pin them on the company noticeboard.
  813.  
  814.            
  815.     Allow them to enter whatever delivery charge they want.
  816.  
  817.                    
  818.                
  819. Correct     Correct
  820.  
  821.                    
  822.         45.     When you add the concept of time to your data model, your model becomes more complex. True or False?     Mark for Review
  823. (1) Points
  824.                    
  825.            
  826.     True (*)
  827.  
  828.            
  829.     False
  830.  
  831.                    
  832.                
  833. Correct     Correct
  834.  
  835.                    
  836.         46.     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
  837. (1) Points
  838.                    
  839.            
  840.     True
  841.  
  842.            
  843.     False (*)
  844.  
  845.                    
  846.                
  847. Correct     Correct
  848.  
  849.                    
  850.  
  851.                    
  852.     Section 10
  853.     (Answer all questions in this section)
  854.                    
  855.         47.     All datamodels must be transformed from specific to generic. True or False?  Mark for Review
  856. (1) Points
  857.                    
  858.            
  859.     True
  860.  
  861.            
  862.     False (*)
  863.  
  864.                    
  865.                
  866. Correct     Correct
  867.  
  868.                    
  869.         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
  870. (1) Points
  871.                    
  872.            
  873.     True
  874.  
  875.            
  876.     False (*)
  877.  
  878.                    
  879.                
  880. Correct     Correct
  881.  
  882.                    
  883.         49.     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
  884. (1) Points
  885.                    
  886.            
  887.     True
  888.  
  889.            
  890.     False (*)
  891.  
  892.                    
  893.                
  894. Correct     Correct
  895.  
  896.                    
  897.         50.     Which of the following statements are true for ERD's to enhance their readability. (Choose Two)  Mark for Review
  898. (1) Points
  899.                    
  900.             (Choose all correct answers)   
  901.                    
  902.            
  903.     It is OK to break down a large ERD into subsets of the overall picture. By doing so, you end up with more than one ERD that, taken together, documents the entire system. (*)
  904.  
  905.            
  906.     Avoid crossing one relationship line with another. (*)
  907.  
  908.            
  909.     The crows feet (many ends) can point whichever way is the easiest to draw.
  910.  
  911.            
  912.     You must ensure that you have every single entity--even if hundreds of them exist--on one single, big diagram.
  913.  
  914.                    
  915.                
  916. Correct     Correct
  917.  
  918.                    
  919. Previous    Page 5 of 5 Summary
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!