Examine the commands executed in the following sequence： 1：SQL> CREATE ROLE mgrrole； 2：SQL> GRANT create user，select any table，connect，resource TO mgrrole； 3：SQL> GRANT select，update ON sh.sales TO mgrrole； 4：SQL> CREATE ROLE ceo IDENTIFIED BY boss；

题目

Examine the commands executed in the following sequence： 1：SQL> CREATE ROLE mgrrole； 2：SQL> GRANT create user，select any table，connect，resource TO mgrrole； 3：SQL> GRANT select，update ON sh.sales TO mgrrole； 4：SQL> CREATE ROLE ceo IDENTIFIED BY boss； 5：SQL> GRANT mgrrole，drop any table，create any directory TO ceo； 6：SQL> GRANT ceo TO mgrrole； Which statement is true about the above commands（）

A、The commands execute successfully.
B、Command 6 produces an error because of circular role grant.
C、Command 5 produces an error because a role cannot be granted to another role.
D、Command 3 produces an error because the MGRROLE role already contains system privileges.
E、The table created by HR remains and HR still has the CREATE TABLE system privilege.
F、The table created by HR remains and HR can grant the CREATE TABLE system privilege to other users.

如果没有搜索结果或未解决您的问题，请直接联系老师获取答案。

相似问题和答案

第1题：

exist

A. experience B. examine C. excite D. explode

正确答案：B

第2题：

You are the administrator of a Windows Server 2003 computer named Server1. The hardware vendor forServer1 notifies you that a critical hotfix is available. This hotfix is required for all models of this computer thathave a certain network interface card.You need to find out if the network interface card that requires the hotfix is installed in Server1.What are two possible ways to achieve this goal? （）(Each correct answer presents a complete solution. Choose two.)

A. Open Network Connections, and then examine the properties of each connection that is listed.

B. Open the Component Services snap-in, expand Computers, expand My Computer, and then examine the list.

C. Run the netsh interface command, and then examine the list.

D. Open Device Manager, expand Network adapters, and then examine the list

参考答案：A, D

第3题：

I think the door is locked. But I'll go and ().

A、check

B、examine

参考答案：A

第4题：

Examine the structure of the EMPLOYEES and DEPARTMENTS tables:Evaluate this SQL statement:Which SQL statement is equivalent to the above SQL statement?()

参考答案：C

第5题：

Examine the following commands and their output:View the exhibit and examine the Flashback Version Query that was executed after the preceding commands.What could be the possible cause for the query not displaying any row?（）

A. Flashback logging is not enabled for the database.

B. The changes made to the table are not committed.

C. Supplemental logging is not enabled for the database.

D. The database is not configured in ARCHIVELOG mode.

参考答案：B

第6题：

(b) Examine how adopting a Six Sigma approach would help address the quality problems at UPC.

(10 marks)

正确答案：
(b) In many ways Six Sigma started out as a quality control methodology. It focused on measurement and the minimisation of
faults through pursuing Six Sigma as a statistical measure of some aspects of organisational performance. However, Six Sigma
has developed into something much more than a process control technique. It includes a problem-solving process called
DMAIC and a comprehensive toolkit ranging from brainstorming to balanced scorecards and process dashboards. It also has
defined team roles for managers and employees, often with martial arts names such as Black Belt, Green Belt and Master
Black Belt.
Six Sigma was first used in organisations in the early 1990s. However, it was its adoption and promotion by Jack Welch, the
CEO of GE that brought Six Sigma wider publicity. He announced that ‘Six Sigma is the most important initiative GE has ever
undertaken’. As Paul Harmon comments, ‘Welch’s popularity with the business press, and his dynamic style, guaranteed that
Six Sigma would become one of the hot management techniques of the late 1990s’.
Six Sigma uses an approach called DMAIC in its problem solving process. This stands for Define, Measure, Analyse, Improve
and Control. Three aspects of this are considered below in the context of how they would address the problems at UPC.
Defining the problem
Part of defining the problem is the identification of the customer. It is important to understand what customers really want
and value and one of the main themes of Six Sigma is its focus on the customer. Six Sigma explicitly recognises the ‘voice of
the customer’ (VOC) in its approach. In the UPC situation quality requirements are currently defined by the physical condition
of the goods and by the alignment of the image. However, this may be a limiting view of quality because there is no evidence

of any systematic investigation of the requirements of the customer. Solving these problems may not lead to any significant
long-term gain; they may be quickly replaced by other ‘quality issues’. Furthermore, the customer is also perceived in a limited
way. These quality requirements are in the eye of the gift shop owner who is interested in saleable products. The end customer
– the consumer – who buys and uses the product may have other requirements which can also be addressed at this time.
By considering the VOC the problem and scope of the project becomes re-defined and the solution of the problems potentially
more valuable.
Measurement
Measurement is fundamental to Six Sigma. This includes the gathering of data to validate and quantify the problem. The
creation of the inspection team was based on initial evidence about an increase in breakages. This needs to be quantified.
The inaccurate printing of the image had been quantified as 500 units per month, out of the 250,000 shipped out of the
company. This equates to a failure rate of 0·2%, so that 99·8% of items are shipped with a correctly aligned image. This
sounds quite reasonable but it still raises issues and complaints that have to be dealt with, as well as creating wastage costs
of $10,000 per month. The problem is that even a relatively low percentage of defects can lead to a lot of unhappy customers.
Aiming for Six Sigma would reduce defects down to about one faulty item per month, reducing the wastage cost to $20.
Analysis
Analysis is concerned with understanding the process to find the root cause. Six Sigma focuses on processes and their
analysis. Analysis concerns methods, machines, materials, measures, Mother Nature and people. The alignment problem
needs investigation to find out what causes the imaging machine to irregularly produce misaligned images. Management
currently appear to blame the machine but it may be due to the way that certain people load the machine. The analysis of
the breakages is particularly important. It is unclear at present where these breakages occur (for example, are some of the
items broken before they leave UPC’s despatch facility) or are they all broken in transit? Neither is it understood why the
breakages occur. Management appear to blame the packers for packing incorrectly and not following the correct method.
However, it may be that the material is just not strong enough to withstand heavy handling by couriers who are outside the
control of UPC. Additionally, the breakages may be due to some manufacturing problem or raw material imperfection in the
items that break. Six Sigma stresses understanding the problem before solving it.
Although DMAIC has been selected as the framework for the sample answer, focusing on other aspects of Six Sigma would
be acceptable – as long as they are presented in the context of the UPC scenario.

第7题：

Examine the structure of the EMPLOYEES table:What is the correct syntax for an inline view?()