Database Management System Solution

Part A What are the differences between user and schema?What are the steps for creating users in Oracle?

Describe the two types of privileges. Describe the DBA responsibilities.

What is the function of below command?GRANTREVOKECONNECTDisplays the department numbers and maximum salaries for those departments with a maximum salary greater than $10,000.Displays the job ID and total monthly salary for each job that has a total payroll exceeding $13,000. Display the maximum average salary.Display all the employees who earn more than employee with last name of Abel.Displays the employee last name, job ID, and salary of all employees whose salary is equal to the minimum salary.Part A

1.      Whatare the differences between user and schema?

 

2.      Whatare the steps for creating users in Oracle?

 

3.      Describethe two types of privileges.

 

4.      Describethe DBA responsibilities.

 

5.      Whatis the function of below command?

a.      GRANT

b.      REVOKE

c.       CONNECT

 

Part B

Instructions:Use the table structure in HR schema. Show your codes and show the print screenof results.

1.     Displaysthe department numbers and maximum salaries for those departments with amaximum salary greater than $10,000.

2.     Displaysthe job ID and total monthly salary for each job that has a total payrollexceeding $13,000.

3.     Display the maximum averagesalary.

4.     Displayall the employees who earn more than employee with last name of Abel.

5.     Displaysthe employee last name, job ID, and salary of all employees whose salary isequal to the minimum salary.