Part 5 Review Questions and Exercises.doc

SOLUTIONSTOREVIEWQUESTIONSANDEXERCISESFORPART5–SELECTEDDATABASEISSUES(CHAPTERS20–23)SolutionstoReviewQuestionsandExercisesChapter20SecurityandAdministration 3Chapter21Professional,Legal,andEthicalIssuesinDataManagement 1Chapter22TransactionManagement 6Chapter23QueryProcessing Explainthepurposeandscopeofdatabasesecurity. ,thescopeiswiderthanthatoftheDBMSalone,,italsoconsidersthehardware,software,andusers. - Explainthefollowingintermsofprovidingsecurityforadatabase: (a) authorization (b) authentication (c) access (d) views (e) backupandrecovery (f) integrity (g) encryption (h) RAIDtechnology (DAC)–(MAC)-basedonsystem-, essorOracleDBMS. ess,thismayinvolvesettingapassword(systemsecurity)oruser-levelsecurity(datasecurity),. ForOracle,againcanuseusernameandpasswordmechanism(systemsecurity).Oraclealsosupportsprivileges(bothatthesystemlevelandattheobjectlevel)