Scribd Logo
Upload

Welcome to Scribd!

  • 1K views

    Oracle Quiz Answer - Section 6

    Uploaded by

    Muhammad Haqqi An Nazilli
    This document contains answers to multiple choice quizzes on database design topics including unique identifiers, normalization, and normal forms. It provides the answers to questions testing knowledge of concepts such as when an entity is in first normal form, the rules of second normal form, and which attribute combinations violate third normal form. The document is from a blog that offers Oracle certification exam answers and test cheating strategies.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    Oracle Quiz Answer - Section 6

    Uploaded by

    Muhammad Haqqi An Nazilli
    1K views4 pages
    This document contains answers to multiple choice quizzes on database design topics including unique identifiers, normalization, and normal forms. It provides the answers to questions testing knowledge of concepts such as when an entity is in first normal form, the rules of second normal form, and which attribute combinations violate third normal form. The document is from a blog that offers Oracle certification exam answers and test cheating strategies.

    Original Description:

    Oracle Quiz Answer – Section 6

    Original Title

    Oracle Quiz Answer – Section 6

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document contains answers to multiple choice quizzes on database design topics including unique identifiers, normalization, and normal forms. It provides the answers to questions testing knowledge of concepts such as when an entity is in first normal form, the rules of second normal form, and which attribute combinations violate third normal form. The document is from a blog that offers Oracle certification exam answers and test cheating strategies.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    1K views4 pages

    Oracle Quiz Answer - Section 6

    Uploaded by

    Muhammad Haqqi An Nazilli
    This document contains answers to multiple choice quizzes on database design topics including unique identifiers, normalization, and normal forms. It provides the answers to questions testing knowledge of concepts such as when an entity is in first normal form, the rules of second normal form, and which attribute combinations violate third normal form. The document is from a blog that offers Oracle certification exam answers and test cheating strategies.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    You are on page 1of 4

    2/11/2017 Section6Quizanswers|BlogulBlogurilor

    BlogulBlogurilorACADEMYORACLEANSWERS
    &CHEATINGSTUFF

    12NOV

    Section6Quizanswers

    PostedNovember12,2009byblogulblogurilorinOracleDesign.CommentsO

    Test:Quiz:Articial,CompositeandSecondaryUIDs

    1.Auniqueidentiercanonlybemadeupofonea ribute.TrueorFalse?

    True
    False

    2.AnentitycanonlyhaveoneUID.TrueorFalse?

    True
    False

    3.Peoplearenotbornwithnumbers,butalotofsystemsassignstudentnumbers,customerIDs,
    etc.Ashoehasacolor,asize,astyle,butmaynothaveadescriptivenumber.So,tobeableto
    uniquelyandecientlyidentifyoneinstanceoftheentitySHOE,a/an______________UIDcanbe
    created.

    articial
    unrealistic
    structured
    identication

    4.AUIDcanbemadeupfromthefollowing:(ChooseTwo)

    A ributes
    Entities
    Relationships
    Synonyms

    Test:Quiz:NormalizationandFirstNormalForm

    1.Whendataisstoredinmorethanoneplaceinadatabase,thedatabaseviolatestherulesof
    ___________.

    Normalization
    https://blogulblogurilor.wordpress.com/2009/11/12/section6quizanswers/ 1/4
    2/11/2017 Section6Quizanswers|BlogulBlogurilor

    Normalization
    Replication
    Normalcy
    Decency

    2.Anentitycanhaverepeatedvaluesandstillbein1stNormalForm.TrueorFalse?

    True
    False

    3.Thefollowingentityison1stnormalform:TrueorFalse?

    ENTITY:VEHICLE
    ATTRIBUTES:
    REGISTRATION
    MAKE
    MODEL
    COLOR
    DRIVER
    PASSENGER1
    PASSENGER2
    PASSENGER3

    True
    False

    4.Whenalla ributesaresinglevalued,thedatabasemodelissaidtoconformto:

    1stNormalForm
    2ndNormalForm
    3rdNormalForm
    4thNormalForm

    Test:Quiz:SecondNormalForm

    1.WhatistheruleofSecondNormalForm?

    AllnonUIDa ributesmustbedependentupontheentireUID
    SomenonUIDa ributescanbedependentontheentireUID
    NononUIDa ributescanbedependentonanypartoftheUID
    NoneoftheAbove

    2.Examinethefollowingentityanddecidewhicha ributebreaksthe2ndNormalFormrule:

    ENTITY:CLASS
    ATTRIBUTES:
    &nbspCLASSID
    &nbspDURATION
    &nbspSUBJECT
    &nbspTEACHERNAMEANDADDRESS

    CLASSID
    DURATION
    SUBJECT

    TEACHERNAMEANDADDRESS
    https://blogulblogurilor.wordpress.com/2009/11/12/section6quizanswers/ 2/4
    2/11/2017 Section6Quizanswers|BlogulBlogurilor

    TEACHERNAMEANDADDRESS

    3.Allinstancesofthesubtypesmustbeaninstanceofthesupertype.

    True
    False

    4.Notallinstancesofthesupertypeareinstancesofoneofthesubtypes.

    True
    False

    5.Asupertypeshouldhaveatleasttwosubtypes.

    True
    False

    6.Anentitycanbeon2ndNormalFormevenifithasrepeatedvalues.TrueorFalse?

    True
    False

    Test:Quiz:ThirdNormalForm

    1.ExaminethefollowingEntityanddecidewhichsetsofa ributesbreaksthe3rdNormalFormrule:
    (ChooseTwo)

    ENTITY:TRAIN(SYNONYM:ROLLINGSTOCK)
    ATTRIBUTES:
    TRAINID
    MAKE
    MODEL
    DRIVERNAME
    DEPARTURESTATION
    NUMBEROFCARRIAGES
    NUMBEROFSEATS
    DATEOFMANUFACTURE

    TRAINID,MAKE
    DEPARTURESTATION,DRIVERNAME
    NUMBEROFCARRIAGES,NUMBEROFSEATS
    MODEL,DATEOFMANUFACTURE

    2.Asadatabasedesigneritisyourjobtostoredatainonlyoneplaceandthebestplace.Trueor
    False?

    True
    False

    3.Nodatabasesintheworldisevertrulyon3rdNormalForm.Everyonealwaysstopsafter2nd
    NormalForm.TrueorFalse?

    True
    False

    https://blogulblogurilor.wordpress.com/2009/11/12/section6quizanswers/ 3/4
    2/11/2017 Section6Quizanswers|BlogulBlogurilor

    Advertisements(https://en.support.wordpress.com/aboutthese
    ads/)

    BlogatWordPress.com.

    https://blogulblogurilor.wordpress.com/2009/11/12/section6quizanswers/ 4/4

    You might also like