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
SQL
SQL stands for Structured Query Language, is a form of communication that uses queries structured in a specific format to store, manage & retrieve data from a relational database.
Queries
A query is a type of computer programming language that is used to retrieve data from a database. Databases are useful in a variety of ways. They enable the retrieval of records or parts of records, as well as the performance of various calculations prior to displaying the results. A search query is one type of query that many people perform several times per day. A search query is executed every time you use a search engine to find something. When you press the Enter key, the keywords are sent to the search engine, where they are processed by an algorithm that retrieves related results from the search index. Your query's results are displayed on a search engine results page, or SER.
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
Trending now
This is a popular solution!
Step by step
Solved in 4 steps
