Database Fundamentals

83 Responses | Created by abitofswish |
  1. 1

    A database provide layers of abstraction.

  2. 2

    Database items are stored exactly the way they are presented to the database user.

  3. 3

    A database provides less logical data independence than the file systems it replaced.

  4. 4

    A database provides both physical and logical data independence.

  5. 5

    Databases are always managed by a Database Management System (DBMS).

  6. 6

    Application programs can reference user views.

  7. 7

    People querying the database can reference user views.

  8. 8

    User views provide physical data independence.

  9. 9

    User views can be tailored to the needs of the database user.

  10. 10

    User views are important because data updates are shown in a delayed fashion.

  11. 11

    The physical layer of the ANSI/SPARC model provides physical data independence.

  12. 12

    The physical layer of the ANSI/SPARC model contains the physical files that comprise the database.

  13. 13

    The physical layer of the ANSI/SPARC model contains files that are read and written by the DBMS independent of the computers operating system.

  14. 14

    The physical layer of the ANSI/SPARC model is normally invisible to the database user.

  15. 15

    The physical layer of the ANSI/SPARC model supplies data to the logical layer.

  16. 16

    The logical layer of the ANSI/SPARC model contains database objects that are assembled by the DBMS for data in the physical layer.

  17. 17

    The logical layer of the ANSI/SPARC model provides logical data independence.

  18. 18

    The logical layer of the ANSI/SPARC model contains the database schema.

  19. 19

    The logical layer of the ANSI/SPARC model is referenced by the external layer.

  20. 20

    The logical layer of the ANSI/SPARC model lies between the physical and external layers.

  21. 21

    The external layer of the ANSI/SPARC model contains the database subschema.

  22. 22

    The external layer of the ANSI/SPARC model lies between the physical and logical layers.

  23. 23

    The external layer of the ANSI/SPARC model can be directly referenced by database users.

  24. 24

    The external layer of the ANSI/SPARC model contains all the user views for the database.

  25. 25

    The external layer of the ANSI/SPARC model provides physical data independence.

  26. 26

    Physical data independence is something a database either has or does not have.

  27. 27

    Physical data independence is a property that all computer systems have to some degree.

  28. 28

    Physical data independence allows nondisruptive changes to be made to the physical layer of the ANSI/SPARC model.

  29. 29

    Physical data independence is achieved through the separation of the physical and logical layers of the ANSI/SPARC model.

  30. 30

    Physical data independence is achieved through the separation of the logical and external layers of the ANSI/SPARC model.

  31. 31

    Logical data independence is a property that all computer systems have to some degree.

  32. 32

    Logical data independence is achieved through the separation of the physical and logical layers of the ANSI/SPARC model.

  33. 33

    Logical data independence is achieved through the separation of the logical and external layers of the ANSI/SPARC model.

  34. 34

    Logical data independence allows data to be freely deleted from the physical database files without disrupting existing database users and processes.

  35. 35

    Logical data independence allows database objects to be freely added to the physical database files without disrupting existing database users and processes.

  36. 36

    Flat file systems:

  37. 37

    The hierarchical database model stores data and methods together in the database.

  38. 38

    The hierarchical database model, in its pure form, permits only one parent for any given record.

  39. 39

    The hierarchical database model allows the processing of sets of database records.

  40. 40

    The network database model was first proposed by Dr. E.F. Codd.

  41. 41

    The network database model connects database records using physical address pointers.

  42. 42

    The network database model allows the processing of sets of database records.

  43. 43

    The network database model allows multiple parents for any given database record.

  44. 44

    The network database model is known for its simplicity of use.

  45. 45

    The relational database model was first proposed by Dr. E.F. Codd.

  46. 46

    The relational database model does not use physical pointers to connect database records.

  47. 47

    The relational database model provides superior flexibility for ad hoc queries.

  48. 48

    The relational database model is difficult to understand and use.

  49. 49

    The relational database model presents data as two-dimensional tables.

  50. 50

    The object-oriented model stores data as variables along with application logic modules called methods.

  51. 51

    The object-oriented model provides for free-form ad hoc query of variables.

  52. 52

    The object-oriented model was first invented in the 1980s.

  53. 53

    The object-oriented model provides better support for complex data types than the relational model.

  54. 54

    The object-oriented model restricts access to variables through encapsulation.

  55. 55

    The object-relational model was first proposed by Charles Bachman.

  56. 56

    The object-relational model combines concepts from the relational and object models in an attempt to get the best from each.

  57. 57

    The object-relational model is not supported by the mainstream (bestselling) DBMS products.

  58. 58

    The object-relational model overcomes the ad hoc query restrictions found in the relational model.

  59. 59

    The object-relational model overcomes the ad hoc query restrictions found in the object-oriented model.

  60. 60

    According to advocates of the relational model, the problems with the CODASYL model is that it is too mathematical.

  61. 61

    According to advocates of the relational model, the problems with the CODASYL model is that it is to complicated.

  62. 62

    According to advocates of the relational model, the problems with the CODASYL model is that it lacks generally accepted standards.

  63. 63

    According to advocates of the relational model, the problems with the CODASYL model is that its set-oriented queries are too difficult.

  64. 64

    According to advocates of the relational model, the problems with the CODASYL model is that an efficient implementation cannot be built.

  65. 65

    According to the advocates of the network model, the problems with the relational model is that record-at-a-time processing is poorly supported.

  66. 66

    According to the advocates of the network model, the problems with the relational model is that it is too complicated.

  67. 67

    According to the advocates of the network model, the problems with the relational model is that it has no formal mathematical underpinnings.

  68. 68

    According to the advocates of the network model, the problems with the relational model is that an efficient implementation cannot be built.

  69. 69

    According to the advocates of the network model, the problems with the relational model is that it lacks generally accepted standards.

  70. 70

    The relational model became popular when the computer systems became less expensive, so flexibility became more important than efficiency.

  71. 71

    the simple-to-use query languages such as SQL emerged is the main reason the relational model became so popular.

  72. 72

    The network model saw no commercial success which is the main reason the relational model became so popular.

  73. 73

    The main reason the relational model became so popular is due to products were developed that proved reasonable efficiency could be achieved.

  74. 74

    The main reason the relational model became so popular is relational calculus was invented.

  75. 75

    An important historic event in database development is that GUAM was the first commercially available database.

  76. 76

    An important historic event in database development is that General Electric's IDS was the first known network database.

  77. 77

    An important historic event in database development is when Dr. E.F. Codd published his famous research paper in 1970.

  78. 78

    An important historic event in database development is when early relational databases were built by both IBM and UC Berkeley.

  79. 79

    An important historic event in database development is that nearly all the commercial relational databases are descendents of either System R or INGRES.

  80. 80

    Currently available relational databases include Oracle.

  81. 81

    Currently available relational databases include Microsoft SQL Server.

  82. 82

    Currently available relational databases include System R.

  83. 83

    Currently available relational databases include IDS.

  84. 84

    Currently available relational databases include Sybase.

  85. 85

    Moving a file from one disk device to another is an example of physical changes that can be safely made in a system that has a high degree of physical data independence.

  86. 86

    Adding new user reviews is an example of physical changes that can be safely made in a system that has a high degree of physical data independence.

  87. 87

    Adding new data files is an example of physical changes that can be safely made in a system that has a high degree of physical data independence.

  88. 88

    Splitting or combining database objects is an example of physical changes that can be safely made in a system that has a high degree of physical data independence.

  89. 89

    Renaming a data file is an example of physical changes that can be safely made in a system that has a high degree of physical data independence.

  90. 90

    Moving a file from one disk device to another is an example of logical changes that can be safely made in a system that has a high degree of logical data independence.

  91. 91

    Deleting database objects is an example of logical changes that can be safely made in a system that has a high degree of logical data independence.

  92. 92

    Adding new database objects is an example of logical changes that can be safely made in a system that has a high degree of logical data independence.

  93. 93

    Adding data items to existing database objects is an example of logical changes that can be safely made in a system that has a high degree of logical data independence.

  94. 94

    Deleting data items from existing database objects is an example of logical changes that can be safely made in a system that has a high degree of logical data independence.

Similar Quizzes

Users Also Took

Rating

0 votes
Take this first to vote!

Add to Favorites

Tags

© 2012 Miva AK, Inc.