databse:

the logged in user has authority to allow access to all objects for all users. Using discretionary access control, which of the following is a valid way to allow UserC to retrieve Fname, Minit, Lname, Ssn attributes of Employee but only for employees whose salary is over 40000?

-GRANT SELECT ON Employee TO UserC WHERE Salary > 40000;

-GRANT SELECT ON Employee WHERE Salary > 40000 TO UserC;

-CREATE VIEW EmpGT40K AS SELECT Fname, Minit, Lname, Ssn FROM Employee;

-GRANT SELECT ON EmpGT40K TO UserC WHERE Salary > 40000; CREATE VIEW EmpGT40K AS SELECT Fname, Minit, Lname, Ssn FROM Employee WHERE Salary > 40000; GRANT SELECT ON EmpGT40K TO UserC;

q2:

Each partition of a vertically partitioned table contains which of the following? (Note: A subset contains only part of entire table.)

		a subset of the columns of the entire table
		a subset of both rows and columns of the entire table
		a subset of the rows in the entire table
		a subset of the keys of the entire tabl

Q3:Using discretionary access control, which of the following statements allow UserA to retrieve and modify Department and Dependent and can give other users privileges on these same tables.

		GRANT SELECT ON Dependent, Department TO UserA with GRANT OPTION;
		GRANT SELECT ON Dependent TO UserA WITH GRANT OPTION; GRANT SELECT ON Department TO UserA WITH GRANT OPTION;
		GRANT SELECT ON Dependent TO UserA; GRANT SELECT ON Department TO UserA;
		GRANT SELECT ON Dependent, Department TO UserA;