Database Q1: Select the correct SQL statement to provide the user Samer with read only permission on Employees table a) Grant read on Employee where username = Samer; b) Grant read only on Employee to Samer; c) Grant select to Samer on Employee; d) Grant select on Employee to Samer; Q2: Based on the TWO schema structures below, which SQL statement will create a view to show department names where each department has at least 5 employees? Employee (E_ID, E_Name, D_ID, E_Salary) Department (D_ID, D_Name, D_Address) (Select one) a) Create View Dept_Emp as select D_Name, count(E_ID) from Employee, Department where Employee D_ID = Department D_ID Group by D_Name Where count (E_ID) >= 5; b) Create View Dept_Emp as select D_Name, count(E_ID) from Employee D_ID = Department D_ID Group by D_Name Having count (E_ID) >= 5; c) Create View Dept_Emp as select D_Name, count(D_ID) from Employee, Department where Employee D_ID = Department D_ID Group by D_Name Having count (E_ID) >= 5; d) Create View Dept_Emp as select D_Name, count(E_ID) from Employee join Department Having count (E_ID) >= 5; Group by D_Name Q3: Consider the TWO relations: T (a, d, c) and S (d, b). Assume that relations T has 7 rows and relation S has 9 rows. What is the maximum number of rows that can be returned by executing the following query? SELECT * FROM T join S; a) Maximum = 49 b) Maximum = 9 c) Maximum = 63 d) Maximum = 81

Database

Q1:

Select the correct SQL statement to provide the user Samer with read only permission on Employees

table

a) Grant read on Employee where username = Samer;

b) Grant read only on Employee to Samer;

c) Grant select to Samer on Employee;

d) Grant select on Employee to Samer;

Q2:

Based on the TWO schema structures below, which SQL statement will create a view to show

department names where each department has at least 5 employees?

Employee (E_ID, E_Name, D_ID, E_Salary)

Department (D_ID, D_Name, D_Address)

(Select one)

a) Create View Dept_Emp as

select D_Name, count(E_ID)

from Employee, Department

where Employee D_ID = Department D_ID

Group by D_Name

Where count (E_ID) >= 5;

b) Create View Dept_Emp as

select D_Name, count(E_ID)

from Employee D_ID = Department D_ID

Group by D_Name

Having count (E_ID) >= 5;

c) Create View Dept_Emp as

select D_Name, count(D_ID)

from Employee, Department

where Employee D_ID = Department D_ID

Group by D_Name

Having count (E_ID) >= 5;

d) Create View Dept_Emp as

select D_Name, count(E_ID)

from Employee join Department

Having count (E_ID) >= 5;

Group by D_Name

Q3:

Consider the TWO relations: T (a, d, c) and S (d, b).

Assume that relations T has 7 rows and relation S has 9 rows.

What is the maximum number of rows that can be returned by executing the following query?

SELECT * FROM T join S;

a) Maximum = 49

b) Maximum = 9

c) Maximum = 63

d) Maximum = 81