Advertisement
Guest User

Untitled

a guest
Dec 8th, 2019
143
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.88 KB | None | 0 0
  1. 1. F database system is database and applications
  2. 2. F application programs are part of DBMS
  3. 3. F end users dont know about the structure of the db
  4. 4. F theres a bunch of free ones
  5. 5. F the schema doesnt change much
  6. 6. F they use external schema
  7. 7. T
  8. 8. T
  9. 9. F Network model is an implementation model
  10. 10. F relational model is also implementation model
  11. 11. F only atomic values are allowed
  12. 12. T have to store object ids
  13. 13. T
  14. 14. T
  15. 15. F
  16. 16. T
  17. 17. F
  18. 18. T
  19. 19. T
  20. 20. T cross product followed by select
  21. 21. T ? The attributes must be the same tho
  22. 22. T
  23. 23. F
  24. 24. T forall
  25. 25. F QBE
  26. 26. T I think so?
  27. 27. T I think so?
  28. 28. F sql is based on TRC
  29. 29. T it is more expressive
  30. 30. F no we need PL/SQL
  31. 31. T ? Maybe? Sometimes its just an attribute?
  32. 32. T I think he means one to one total participation
  33. 33. F he said once that binary convey different info
  34. 34. T
  35. 35. F
  36. 36. F?
  37. 37. F PL/SQL is an extension of SQL? He didn't really talk a ton about it...
  38. 38. F its def less efficient cuz prepares
  39. 39. T somewhere in his DBPL slides
  40. 40. T
  41. 41. A hierarchical can only do one to many
  42. 42. D object
  43. 43. C attributes are names for domains
  44. 44. C
  45. 45. B Codd did relational, bachman did network, gray did transactions and ellison did nothing useful for anyone ever
  46. 46. D Ellison didn't get one cuz he did nothing useful for anyone ever
  47. 47. C oracle cuz he <3 it and decides whats true
  48. 48. C ER is just a model
  49. 49. D key, entity, referential
  50. 50. D
  51. 51. C join is cross + select
  52. 52. A theta is when columns are specified
  53. 53. D outer join = full join
  54. 54. A you have to use all the variables declared
  55. 55. A maybe njoin? idk
  56. 56. A I think algebra requires multiple? All of them? Idk
  57. 57. C forall then exists
  58. 58. D
  59. 59. D weak entities need identifying relationships because they can't be identified otherwise
  60. 60. B
  61. 61. B
  62. 62. B
  63. 63. C security is the benefit
  64. 64. D
  65. 65. B
  66. 66. A
  67. 67. B
  68. 68. A
  69. 69. C
  70. 70. D
  71. 71. D since ql and dml are needed
  72. 72. C
  73. 73. C/D? Idk
  74. 74. D?
  75. 75. B? Idk he uses while loops...
  76. 76. D
  77. 77. B
  78. 78. C
  79. 79. A
  80. 80. D
  81. 81. C
  82. 82. B
  83. 83. C/D I think its D... Teacher might be in the candidate key set?
  84. 84. A status not directly reliant on SIN
  85. 85. C/D? Idk what he wants but I think its 4th normal
  86. 86. C
  87. 87. D
  88. 88. C need one for student, course and takes relation
  89. 89. B could do it in 2 because program is a weak entity set?
  90. 90. D need another relation for phone number...
  91. 91. A, B or C all work so who knows...
  92. 92. B t2 and t3 were committed before the crash, after the checkpoint
  93. 93. C t4 started before the checkpoint but didn't commit, it needs undoing
  94. 94. A everything is oracle
  95. 95. D idk, was never mentioned but mongodb was the latest to add it so probs just outdated...
  96. 96. B
  97. 97. A hes missing brackets but w/e
  98. 98. A
  99. 99. D
  100. 100. D though A might work too
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement