Application Question(s) PS: This is a group assessment, max: 3 members per group, use hypothetical data...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Application Question(s) PS: This is a group assessment, max: 3 members per group, use hypothetical data where necessary. Question 1 (1st Group Member) Write an SQL query to differentiate between system privileges and object privileges in a Database. Question 3 (1st Group Member) Create a role named finance role and grant it the following privileges: Question 2 (3rd Group Member) (5 marks): You have a table named employees in your Oracle database. Create a user named hr_user and grant SELECT and INSERT object privileges on the employees table to this user. Provide the SQL commands to achieve this. (7 marks): • SELECT privilege on the invoices table • INSERT privilege on the transactions table 30 Marks (3 marks): Next, create a user named finance_user and assign the finance_role to this user. Provide the SQL commands to perform these tasks. Question 5 (3rd Group Member) Write SQL queries to demonstrate the following: Question 4 (2nd Group Member) (8 marks): Consider a scenario where you have a complex SQL query that involves joining multiple tables (orders, customers, and products). Write an SQL script to create this query and grant SELECT privilege on the necessary tables to a user named report_user so that they can execute this query successfully. Explain the steps you took and why each privilege is needed as comments on your SQL script. End of Formative Assessment 4 (7 marks): • Grant the CREATE TABLE system privilege to a user named admin_user. • Revoke the UPDATE object privilege on the inventory table from a user named inventory manager, [Total = 30 Marks] Grand Total: 30 Rubric Criteria Question 1: Differentiating Privileges Question 2: Granting Object Privileges Question 3: Using Roles Question 4: Granting Privileges for a Query Question 5: Granting/Revoking Privileges Total: Excellent (3 Marks) (5 Marks) (7 Marks) (8-7 Marks) (7 Marks) Good (4 Marks) (2 Marks) (6-5 Marks) (6-5 Marks) Satisfactory (6-5 Marks) (3 Marks) (4-3 Marks) (4-3 Marks) (4-3 Marks) Needs Improvement (1 Mark) (2-1 Marks) (2-1 Marks) (2-1 Marks) (2-1 Marks) Inadequate (0 Mark) (0 Mark) (0 Mark) (0 Mark) (0 Mark) Mark allocated /30 Application Question(s) PS: This is a group assessment, max: 3 members per group, use hypothetical data where necessary. Question 1 (1st Group Member) Write an SQL query to differentiate between system privileges and object privileges in a Database. Question 3 (1st Group Member) Create a role named finance role and grant it the following privileges: Question 2 (3rd Group Member) (5 marks): You have a table named employees in your Oracle database. Create a user named hr_user and grant SELECT and INSERT object privileges on the employees table to this user. Provide the SQL commands to achieve this. (7 marks): • SELECT privilege on the invoices table • INSERT privilege on the transactions table 30 Marks (3 marks): Next, create a user named finance_user and assign the finance_role to this user. Provide the SQL commands to perform these tasks. Question 5 (3rd Group Member) Write SQL queries to demonstrate the following: Question 4 (2nd Group Member) (8 marks): Consider a scenario where you have a complex SQL query that involves joining multiple tables (orders, customers, and products). Write an SQL script to create this query and grant SELECT privilege on the necessary tables to a user named report_user so that they can execute this query successfully. Explain the steps you took and why each privilege is needed as comments on your SQL script. End of Formative Assessment 4 (7 marks): • Grant the CREATE TABLE system privilege to a user named admin_user. • Revoke the UPDATE object privilege on the inventory table from a user named inventory manager, [Total = 30 Marks] Grand Total: 30 Rubric Criteria Question 1: Differentiating Privileges Question 2: Granting Object Privileges Question 3: Using Roles Question 4: Granting Privileges for a Query Question 5: Granting/Revoking Privileges Total: Excellent (3 Marks) (5 Marks) (7 Marks) (8-7 Marks) (7 Marks) Good (4 Marks) (2 Marks) (6-5 Marks) (6-5 Marks) Satisfactory (6-5 Marks) (3 Marks) (4-3 Marks) (4-3 Marks) (4-3 Marks) Needs Improvement (1 Mark) (2-1 Marks) (2-1 Marks) (2-1 Marks) (2-1 Marks) Inadequate (0 Mark) (0 Mark) (0 Mark) (0 Mark) (0 Mark) Mark allocated /30
Expert Answer:
Answer rating: 100% (QA)
I apologize for the repetition in the questions Lets proceed with answering the revised questions Question 1 1 Group Member To differentiate between system privileges and object privileges in a databa... View the full answer
Related Book For
An Introduction To Statistical Methods And Data Analysis
ISBN: 9781305465527
7th Edition
Authors: R. Lyman Ott, Micheal T. Longnecker
Posted Date:
Students also viewed these programming questions
-
Organizations require faster decision making to be competitive in today's marketplace. Data comes in faster and requires immediate conversion. Real-time data warehousing ( RDW ) is also known as...
-
Why would the probability of an employer offering retiree health insurance increase with the number of employees for large firms over 300 workers. Support your answer with scholarly resources.
-
Construct a synthetic one-year zero-coupon bond using the information. All bonds are free of default risk and have face value equal to $100. The annual coupon of 12% is paid in semi-annual...
-
As programs become more complex, it becomes increasingly important to plan or "design" your code before writing it. Designing your code will help you organize its logic. It will also help you keep...
-
Customers at a gas station pay with a credit card (A), debit card (B), or cash (C). Assume that successive customers make independent choices, with P(A) = .5, P(B) = .2, and P(C) = .3. a. Among the...
-
With the following data, fill in the empty blanks. Total 000 A 000 B % Across C % Down D Index All Adults 1824 2534 218,289 28,098 39,485 35,144 6,285 10,509 16.1 100.0 100
-
Prepare sales and cash collections budgets (Learning Objectives 2, 3) Rovniak Reeds, a manufacturer of saxophone, oboe, and clarinet reeds, has pro jected sales to be $890,000 in October, $950,000 in...
-
Hinckley Company is in the process of adjusting its books at the end of 2011. Hinckleys records reveal the following information: (a) Hinckley failed to accrue sales commissions at the end of 2009...
-
14.15 Briefly discuss the process for selecting a method of forecasting
-
? ?? ? ? Assume that Alpha and Omega compete in the same four-digit SIC code industry and offer comparable products and services. The following table contains their reported financial performance and...
-
Find all solutions to 3111(6) = T The answers are in the form A + Bk and C' + Dk where It represents any integer, and 0 S A
-
Provide two reasons why the evaluation and control of the communication process are important for successful marketing. Provide an example to illustrate your ideas. In replies to peers, discuss...
-
Could you please explain the talefilm of canada in detail like it's key senior management positions, middle management positions, non management positions and support staff in details?
-
Saxbury Corporation's relevant range of activity is 3,000 units to 7,000 units. When it produces and sells 5,900 units, its average costs per unit are as follows: Average Cost per Unit $ 5.80 Direct...
-
Reflect on the discussion of the views of inclusion held by some individuals in the Deaf community. Throughout the course, as you have read about the other disability categories, advocates of...
-
You are the controller of Wolf Media Corp. (Wolf), a publicly owned Canadian company. Wolf's operations include television production, live theatre production, and interactive media. The company...
-
Question 6 Find the slope of the graph and describ JA (-2,-1) (4.3)
-
The age-old saying for investing is "buy low and sell high," but this is easier said than done. Investors who panic about falling prices sell their investments, which in turn lowers the price and...
-
Biofeedback is a treatment technique in which people are trained to improve their health by using signals from their own bodies. Specialists in many different fields use biofeedback to help their...
-
The focal point of an agricultural research study was the relationship between when a crop is planted and the amount of crop harvested. If a crop is planted too early or too late farmers may fail to...
-
Refer to Exercise 3.45. Use a scatterplot to plot the price per roll and number of sheets per roll. In exercise a. Do the 24 points appear to fall on a straight line? b. If not, is there any other...
-
Financial accounting uses money measures to gauge the impact of business transactions on a separate business entity. Tell whether each of the following words or phrases relates most closely to (a) a...
-
You have been asked to compare the sales and assets of four companies that make computer chips to determine which company is the largest in each category. You have gathered the following data, but...
-
1. Indicate whether each of the following accounts is an asset (A), a liability (L), or a part of stockholders equity (SE): a. Cash e. Land b. Salaries Payable f. Accounts Payable c. Accounts...
Study smarter with the SolutionInn App