CREATE TABLESPACE user_tbspace DATAFILE 'user.dbf' SIZE 2m; create user mary identified by mary; grant create session to mary with admin option; create role tester; grant create table to tester; grant tester to peter; grant select on table to peter; CREATE VIEW emp_1 AS ( SELECT E.employee_id, E.first_name, E.last_name, E.email, E.phone_number, E.hire_date, E.job_id, E.commission_pct, E.manager_id, E.department_id FROM employees E JOIN departments D ON E.department_id = D.department_id JOIN locations L ON D.location_id = L.location_id WHERE L.country_id = 'US'); grant select on emp_1 to mary; Question: Explain whether It is possible for Mary to grant the privilege and the role emp_1 to other users?

Q: create database CTU__YourICASNo GO USE CTU__YourICASNo; GO CREATE TABLE Course(     CourseID int…

A: Table Course: Table Students: Table Semester: Table Facilitator: Table Module:

Q: Revoke the privilege to del

A: Revoke the privilege to delete rows in the ORDERS and ORDERITEMS tables from theCUSTOMERREP role…

Q: What happens to the data displayed by a view when the view is deleted?

A: Nothing will happen to the data displayed by a view, if the view is deleted.

Q: What restrictions can you apply when you are creating views?

A: Introduction: A view's referenced tables must all be in the same database. - Any user-defined…

Q: The following code would include: CREATE OR REPLACE TRIGGER TRG_LINE_PROD AFTER INSERT ON LINE…

A: Dear Student, The answer to your question with required explanation is given below -

Q: The Driver Relationship team wants to have quick search options for the active drivers. The team…

A: Task 4: INDEX is used search/retrieve data more quickly. It is basically used to speed up query.…

Q: CREATE TABLE keyvalue (  id SERIAL,  key VARCHAR(128) UNIQUE,  value VARCHAR(128) UNIQUE,…

A: The required stored procedure is given below   CREATE PROCEDURE dbo.keyValue AS BEGIN   UPDATE…

Q: When a view is destroyed, what happens to the data that was previously presented by the view?

A: Introduction: An Oracle view is a named and verified SQL query that is saved in the Oracle…

Q: 1. ID Last Name First Name Userid Salary Create the My Employee table with the following fields:…

A: Here is the complete solution of the above problem. See below steps.

Q: MySql Workbench CREATE TABLE students (   id INT PRIMARY KEY,   first_name VARCHAR(50),   last_name…

A: As per Bartleby's rules, we can answer the first 3 subparts of a question I have answered Q 1, 2 3…