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