Q1. Explain the difference between the following SQL commands . Command1: GRANT

Question

Q1. Explain the difference between the following SQL commands.

Command1: GRANT SELECT ON EMPLOYEE TO user1;

Command2: GRANT SELECT ON EMPLOYEE TO user1 WITH GRANT OPTION;

Q2. What is Horizontal Fragmentation? Consider the following University database with three computer sites (one for each college). Site 2 and 3 are for CHS and CCI colleges respectively (we ignore site 1 for this question). You are required to apply horizontal fragmentation for sites 2 and 3 based on CollegeId = 2 and CollegeId = 3. You have to show relation fragments at site 2 corresponding to CollegeId = 2, and at site 3 corresponding to CollegeId = 3.

STUDENTS Frame Ahmed Abdulahd Ali Khalil Mohammed Othman Abduljabbar Rami Address Collegeld Stld DoB Lname Abdulrehman 1300100100 09-01-1986 731, abc street, JD 10-02-1987 1400200200 300, alpha street, JD 3 Hasan 635, xyz street, RD D2 11-03-1983 1300300301 Yasser Mohammed T1300 300401 536, alpha street, MD 2 10-09-1982 1400400521 11-10-1980 Ahmed 534, stu street, JD 1400200200 10-02-1984 300, alpha street, JD 3 1300100120 11-0 234, alpha Street, RD 2 1400200355 12-12-1979 123, aplha, street, DM 1 ibrahim Ahmed Abdulrehman

Explanation / Answer

Using WITH GRANT OPTION we can create a sequence of privelages that is to whomever we give this privelage that one can further extend this privelage. Where as this is not possible without the WITH GRANT OPTION.

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.