12344321

1. 1An internally generated value that is unique to a row in a table is called
   
   

   1. Aan object identifier
   2. Ba foreign key
   3. Ca candidate key
   4. Dan external key
2. 2If a portion of a relation's key is a determinant, then the relation violates

   1. ASecond Normal Form
   2. BThird Normal Form
   3. CFourth Normal Form
   4. DFirst Normal Form
3. 3The rule that every attribute value must be atomic is called

   1. AThird Normal Form
   2. BSecond Normal Form
   3. CFirst Normal Form
   4. DFourth Normal Form
4. 4If a relation's key has more than one column, we say the key is

   1. Amultiple
   2. Bcomposite
   3. Cunique
   4. Drecursive
5. 5If a data value is null, then it

   1. Ais 0
   2. Bmay not apply
   3. Cis blank
   4. Dis the empty string
6. 6The column on the left side of a function dependency is called

   1. Athe determinant
   2. Bthe functional range
   3. Cthe functional domain
   4. Dthe decider
7. 7In the relational mode, a column that connects on table to another is called

   1. Aa null column
   2. Ba foreign key
   3. Ca relation
   4. Dan attribute
8. 8A foreign key that references its own table is called

   1. Arecursive
   2. Bparadoxical
   3. Chidden
   4. Dself-referential
9. 9When we use the word "key" we mean

   1. Athe primary key
   2. Bany candidate key
   3. Ca domestic key
   4. Da foreign key
10. 10If a relation is in Third Normal Form, then it is also in

    1. AFifth Normal Form
    2. BDomain-Key Normal Form
    3. CSecond Normal Form
    4. DFourth Normal Form

11. 11Relationship names usually correspond in natural language to

    1. Aadverbs
    2. Bnouns
    3. Cverbs
    4. Dadjectives
12. 12The attributes a specialization gets from its generalization are attributes the specialization

    1. Ainherits
    2. Bclaims
    3. Cowns
    4. Dreceives
13. 13A collection of things of a particular type is called

    1. Aan object class
    2. Ban attribute
    3. Ca relationship
    4. Dan object
14. 14Viewing the Checking Account and Savings Account classes are subclasses of the Account class is an example of

    1. Aregeneration
    2. Bcombination
    3. Cgeneralization
    4. Dreformulation
15. 15In UML the largest number of instances related to a single instance under a relationship is called multiplicity

    1. Amaximization
    2. Bmaximality
    3. Cmultiplicity
    4. Dnumericity
16. 16A superset of other sets is called

    1. Aa generalization
    2. Ba specialization
    3. Ca super-concept
    4. Da broadening
17. 17In our conceptual methodology we represent real world entities as

    1. Aobjects
    2. Bthings
    3. Crelations
    4. Dquantities
18. 18UML stands for

    1. AUnified Modeling Language
    2. BUniversally Meaningful Language
    3. CUnion of methodological Lists
    4. DUniform Master Linking
19. 19The symbol used to specify a cardinality of "many" is

    1. A!
    2. B+
    3. Cthere is no special symbol
    4. D*
20. 20Object class names usually correspond in natural language to

    1. Averbs
    2. Badverbs
    3. Cadjectives
    4. Dnouns
21. 21The type of designation Numeric(8,2) means

    1. Aa minimum of 2 digits, a maximum of 8
    2. B8 digits to the left, 2 digits to the right of the decimal
    3. C8 digits, 2 of them to the right of the decimal
    4. Dusually only 8 digits, but sometimes 10 digits
22. 22The advantage of using conceptual modeling in database design is
    
    

    1. Ait has languages for query
    2. Bit reduces complexity
    3. Ctext based modeling is easier to comprehend
    4. Dit is easier to implement
23. 23How is a one-to-many relationship implemented in the a database schema?

    1. AThe key of the one class becomes a foreign key in the many class.
    2. BAnother table is made which contains the keys from both classes.
    3. CThe keys of each class become foreign keys in the other class.
    4. DThe key of the many class becomes a foreign key in the one class.
24. 24In transforming a recursive relationship to the relational model a foreign key is created which references

    1. Aan intersection relation
    2. Bits own relation
    3. Ca specialization
    4. Da lexical attribute
25. 25The relational model concept equivalent to a one-to-many relationship is
    
    

    1. Aa lexical attribute
    2. Ba generalization
    3. Ca candidate key
    4. Da foreign key
26. 26When can a specialization class be subsumed into the relational table definition of the generalization class?
    
    

    1. AIt should always be subsumed
    2. BIt is never a valid option
    3. CIt is a valid option
    4. DIt depends on the number of other relationships
27. 27The relational model concept equivalent to an attribute is

    1. Aa many-many relationship
    2. Ba specialization
    3. Can attribute
    4. Da foreign key
28. 28How do you capture a recursive relationship in a relation schema?

    1. AA copy (renamed) of the primary key becomes a foreign key
    2. BThe primary key is also identified as a foreign key
    3. CA separate foreign key is defined
    4. DA separate intersection table is defined with the primary key and a copy (renamed) as a foreign key
29. 29In a one-to-one relationship whether the cardinality is 1..1 or 0..1 has NO bearing on the decision of where ot place foreign keys.

    1. ATrue
    2. BFalse
30. 30
    How are the keys transformed in the relations to capture a one-to-one relationship in the conceptual model?

    1. AA separate table is created with both primary keys as foreign keys
    2. BThe primary key of one class becomes a foreign key in the related class
    3. CThe primary key of each class is becomes a foreign key in the other class
    4. DA new table is created with its own primary key
31. 31The relational model concept equivalent to an association class is

    1. Aan intersection relation with non-key attributes
    2. Ba relation with no key attributes
    3. Ca relation with a one-column key
    4. Da relation with no foreign key
32. 32The relational model concept equivalent to a many-to-many relationship is

    1. Aa specialization
    2. Ban object set
    3. Ca foreign key
    4. Dan intersection relation
33. 33The relational model concept equivalent to a specialization is

    1. Aa relation with a set of attributes
    2. Ba relation with two primary keys
    3. Ca relation with no foreign key
    4. Da relation whose key is also a foreign key
34. 34How is a many-to-many relationship implemented in the database schema?

    1. AA new table is created with foreign keys of both classes
    2. BA key from one class becomes a foreign key in the other class. Either direction is okay.
    3. CThe key of each class becomes a foreign key in the opposite class
    4. DAll of the other choices are correct and will work.
35. 35The conceptual model is more effective than the relational model for understanding the user's business domain.

    1. ATrue
    2. BFalse
36. 36The relational model concept equivalent to an object class is

    1. Aa relation
    2. Ba key
    3. Can object set
    4. Dan attribute
37. 37The advantage of using the relational model is

    1. Acomplexity reduction
    2. Bease of implementation
    3. Cforeign keys tie the relations together
    4. Dtext based modeling is easier to comprehend
38. 38Because an external key is a unique identifier for an object, it is a good choice for the internal primary key in a relation of the relational schema.
    

    1. ATrue
    2. BFalse
39. 39Classes not derived from other classes are called

    1. Aspecialization classes
    2. Babstract classes
    3. Cassociation classes
    4. Dbase classes
40. 40Transforming a conceptual data model into a relational model in essence defines the database schema.

    1. ATrue
    2. BFalse
41. 41To remove a table from an SQL database, which statement would one use?

    1. ADelete
    2. BAlter
    3. CRemove
    4. DDrop
42. 42Which of the following is NOT a valid operation for defining the default action for a foreign key when a referenced row (tuple) is deleted?

    1. Aset null
    2. Bcascade
    3. Cremove
    4. Dno action
43. 43The SQL data type used for automatically generating row ID's is

    1. AVarChar
    2. BInteger
    3. CNumeric
    4. DChar
44. 44How is a many-to-many relationship implemented in the database schema?

    1. AThe key of each class becomes a foreign key in the opposite class
    2. BA key from one class becomes a foreign key in the other class. Either direction is okay.
    3. CA new table is created with foreign keys of both classes
    4. DAll of the other choices are correct and will work.
45. 45What would the primary key be when one implements an association class as a database table?

    1. AThe primary key would consists of the primary keys from the endpoint classes.
    2. BThe primary key of either endpoint class becomes a foreign key in the table.
    3. CA internal object identifier created by the developer.
    4. DThe table is not required to have a primary key.
46. 46When a foreign key constraint contains an "On Delete" clause, the record (tuple) being deleted would be:

    1. Athe nullable records (tuples)
    2. Bthe cascading record (tuple)
    3. Cthe record (tuple) containing the foreign key
    4. Dthe record (tuple) containing the primary key in the referenced table
47. 47How is a one-to-many relationship implemented in the a database schema?

    1. Ahe keys of each class become foreign keys in the other class.
    2. BThe key of the many class becomes a foreign key in the one class.
    3. CThe key of the one class becomes a foreign key in the many class.
    4. DAnother table is made which contains the keys from both classes.
48. 48How do you capture a 1..* recursive relationship in the design of a database table, e.g. when one employee is the supervisor of many other employees?

    1. AA separate intersection table is defined with the primary key and a copy (renamed) as a foreign key
    2. BAdd a foreign key that references its own primary key
    3. CAdd a foreign key reference to the primary key
    4. DCreate a new
49. 49he type designation Numeric(8,2) means

    1. Aa minimum of 2 digits, a maximum of 8
    2. Busually only 8 digits, but sometimes 10 digits
    3. C8 digits, 2 of them to the right of the decimal
    4. D8 digits to the left, 2 digits to the right of the decimal
50. 50If the primary key is a single column it is defined

    1. Aonly as part of the column definition, but nullable
    2. Bas part of the column definition, or after all column definitions
    3. Conly as part of the column definition, but not nullable
    4. Donly after all column definitions
51. 51The order in which SQL Select clauses are executed is Select, From, Where, Order by
    
    

    1. ATrue
    2. BFalse
52. 52Conditions connected by OR will be true if just one is true.
    
    

    1. ATrue
    2. BFalse
53. 53Conditions connected by AND will be true when one is true.

    1. ATrue
    2. BFalse
54. 54Month in Month(SaleDate) is a function that returns the name of the month in the date.

    1. ATrue
    2. BFalse
55. 55The SQL statement used to take rows out of a table is Delete.
    
    

    1. ATrue
    2. BFalse
56. 56The maximum number of clauses in an SQL Select statement is 8.

    1. ATrue
    2. BFalse
57. 57The SQL statement used to change data in an existing row is Update.
    
    

    1. ATrue
    2. BFalse
58. 58A column whose value is always unique in a table is called an individual.
    
    

    1. ATrue
    2. BFalse
59. 59To sort the result in reverse alphabetical order you use the key word Desc.

    1. ATrue
    2. BFalse
60. 60The From clause can contain a second name for a table. This name is called an alias.

    1. ATrue
    2. BFalse

Description

Quiz on 12344321, created by Justin Bittar on 16/03/2019.

Author

Justin Bittar

Language

English

Views

12

Rating

No ratings yet

Rate this quiz

Rate this quiz

More on Relational Model and ER Mapping