Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

a) Explain how a Domain Name Server (DNS) cache poisoning can be initiated by a network hacker. Propose a method that can mitigate or eliminate

image text in transcribed

a) Explain how a Domain Name Server (DNS) cache poisoning can be initiated by a network hacker. Propose a method that can mitigate or eliminate such an attack. (7 marks) b) Discuss TWO (2) suitable strategies of a Disaster Recovery Plan (DRP) that can be implemented by an e-commerce company to ensure business continuity. QUESTION 3 The Database Administrator (DBA) is the central authority for managing a database system. The DBA's responsibilities include granting privileges to users who need to use the system and also classifying users and data in accordance with the policy of the organization. Write the query/command in SQL for the following criteria: a) Suppose that the DBA creates four accounts (A1, A2, A3, A4). DBA wants only A1 to be able to create base relations. (3 marks) b) User account AI then create tables under the schema called EXAMPLE. Then, AI creates the two base relations EMPLOYEE and DEPARTMENT. Suppose that A1 wants to grant A2 the privilege to insert and delete tuples in both of these relations, but A1 does not want A2 to be able to propagate these privileges to additional accounts. (3 marks) c) Suppose that A1 wants to allow A3 to retrieve information from either of the two tables and also to be able to propagate the SELECT privilege to other accounts. (3 marks) d) Suppose that Al decides to revoke the SELECT privilege on the EMPLOYEE relation from A3

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Advances In Databases And Information Systems Second East European Symposium Adbis 98 Poznan Poland September 1998 Proceedings Lncs 1475

Authors: Witold Litwin ,Tadeusz Morzy ,Gottfried Vossen

1st Edition

3540649247, 978-3540649243

More Books

Students also viewed these Databases questions

Question

4 How can you create a better online image for yourself?

Answered: 1 week ago