This question refers to Oracle Database 12c. Examine these statements: Connect as sysdba Connected. GRANT CREATE USER
Fantastic news! We've Found the answer you've been seeking!
Question:
This question refers to Oracle Database 12c.
Transcribed Image Text:
Examine these statements: Connect as sysdba Connected. GRANT CREATE USER TO hr WITH ADMIN OPTION; Grant succeeded. GRANT CREATE USER To john; Grant succeeded. Connect hr/hr@PROD Connected. GRANT CREATE USER TO alice WITH ADMIN OPTION; Grant succeeded. connas sysdba Connected. REVOKE CREATE USER FROM hr; Revoke succeeded. Which two are true about the result and effects of executing these commands? (Choose two.) A. The REVOKE statement successfully revokes the system privilege from Alice. B. User Alice is not permitted to revoke the CREATE USER from user John. C. The REVOKE statement successfully revokes the system privilege from user HR. D. User Alice is permitted to grant the CREATE USER privilege to user HR. E. User HR is permitted to grant the CREATE USER privilege to any other user. F. User Alice is permitted to grant the CREATE USER privilege to user HR only. Examine these statements: Connect as sysdba Connected. GRANT CREATE USER TO hr WITH ADMIN OPTION; Grant succeeded. GRANT CREATE USER To john; Grant succeeded. Connect hr/hr@PROD Connected. GRANT CREATE USER TO alice WITH ADMIN OPTION; Grant succeeded. connas sysdba Connected. REVOKE CREATE USER FROM hr; Revoke succeeded. Which two are true about the result and effects of executing these commands? (Choose two.) A. The REVOKE statement successfully revokes the system privilege from Alice. B. User Alice is not permitted to revoke the CREATE USER from user John. C. The REVOKE statement successfully revokes the system privilege from user HR. D. User Alice is permitted to grant the CREATE USER privilege to user HR. E. User HR is permitted to grant the CREATE USER privilege to any other user. F. User Alice is permitted to grant the CREATE USER privilege to user HR only.
Expert Answer:
Related Book For
Posted Date:
Students also viewed these databases questions
-
"internet radios" for streaming audio, and personal video recorders and players. Describe design and evaluation processes that could be used by a start-up company to improve the usability of such...
-
Question (700 words) John Densmore, a law student and part-time musician, was seriously injured in a car accident. The other car's driver, Ray Manzarek, a renowned life motivation coach and a...
-
A company has the following results for the three accounting periods to 31 March 2021: Assuming that all possible claims are made to relieve the trading loss against total profits, calculate the...
-
In Note D to its 2011 financial statements, IBM includes disclosure about its derivatives as follows: Note: AOCI represents Accumulated other comprehensive income/(loss) in Consolidated Statement of...
-
PepsiCo's financial statements are presented in Appendix B. Financial statements of The Coca-Cola Company are presented in Appendix C. The complete annual reports of PepsiCo and Coca-Cola, including...
-
Extreme Machine manufactures machines and parts for various industries; they have an office in Youngstown, Ohio. Avery Dennison manufactures and sells labels from a plant in Mentor, Ohio. They use...
-
Citizens Produce Co-op is one of the biggest produce operations in northern Texas. Credit sales to retailers in the area constitute 80 percent of Citizens Produces business; cash sales to customers...
-
12. Your calculations show that if the wrong link is shared to a potential Democratic voter, there is a strong chance it could result in them changing their vote to Independent or Republican. If you...
-
When planning a report to the board of directors as hr professional in view of turnover as the business expanded, am I to explain eg the redesign and restructure in detail? Or give an explanation of...
-
I would like to get explain in creating a random sample password in java using; String passwordChars = "..!@#$%^&*()_+-= ?/,.;:[]{}"; the main method with this string and also creating an array of...
-
Suppose a company must decide to invest or not in project A that has the following characteristics: Project A Cost of equipment (investment) $800,000 Annual cash flow (year 2) $320,000 Annual cash...
-
Create a new record to represent your new data type (this will be in its own .java file): Tip: You can delete any file content VS Code initially creates then start typing record and select the second...
-
Make a loop that will write 5 random integers between value 0 and 20 to a new file called First Read the file First and append to the file 5 additional values that equal the current value read plus...
-
Rouge Industries reported the following items for the current year: Sales = $3,000,000; Cost of Goods Sold = $1,500,000; Depreciation Expense = $170,000; Administrative Expenses = $150,000; Interest...
-
Gun barrels are produced from one of the following process B-Explosive forming A-Tube drawing D-Swaging of a tube C- Deep drawing
-
The baseball player A hits the ball from a height of 3.36 ft with an initial velocity of 34.8 ft/s. 0.14 seconds after the ball is hit, player B who is standing 15 ft away from home plate begins to...
-
An ARIMA (1, 1, 0) model (AR(1) model for first differences) is fit to observations of a time series. The first 12 residual autocorrelations are shown in Figure P-6. The model was fit with a...
-
Thomas Furniture Company concludes that production scheduling can be improved by developing an accurate method of predicting quarterly sales. The company analyst, Mr. Estes, decides to investigate...
-
Recall Example 7.12. The full data set related to CEO compensation is contained in Appendix C. Use stepwise regression to select the "best" model with k = 3 predictor variables. Fit the stepwise...
-
In the January 1, 20X8, consolidated balance sheet, the amount of goodwill reported should be a. $0. b. $76,000. c. $95,000. d. $156,000. On January 1, 20X8, Ritt Corporation acquired 80 percent of...
-
In the December 31, 20X8, consolidated balance sheet, the amount of noncontrolling interest reported should be a. $200,000. b. $239,000. c. $251,000. d. $252,000. On January 1, 20X8, Ritt Corporation...
-
On January 1, 20X5, Post Company acquired an 80 percent investment in Stake Company. The acquisition cost was equal to Posts equity in Stakes net assets at that date. On January 1, 20X5, Post and...
Study smarter with the SolutionInn App