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.

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.

相关考题:

I think the door is locked. But I'll go and (). A、checkB、examine

An office has been set up recently to examine the tourism industry.() 此题为判断题(对,错)。

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

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

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

Examine the structure of the EMPLOYEES table:What is the correct syntax for an inline view?() A.B.C.D.

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.

Examine the structure if the EMPLOYEES and NEW EMPLOYEES tables:Which MERGE statement is valid?() A.B.C.D.

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

After __________ (examine) the lady, the doctor suggested that his back was badly hurt in the accident.

检查A.expectB.exceptC.excuseD.examine

检查()A、expectB、exceptC、excuseD、examine

After adding a new Ethernet card to a system and rebooting, the system administrator notices the card was not configured. How can the system administrator determine if there were errors during the configuration process for the card?()A、Examine the bootlog with the command: alog -o -f /var/adm/ras/bootlogB、Display the device attributes and errors with the command: lsdev -C -l ent0C、Examine the AIX errlog for configuration method errors with the command: errpt -a -C ent0D、Examine the ODM for configuration errors with the command: odmget -q "method_errors" ent0

The()may examine or re-examine the goods or take samples from them straightaway in the absence of the consignee or the consignor whenever it considers this necessary.A、CustomsB、The ministry of commerceC、The state councilD、the commodity inspection institution

Which of the following commands should Karen, a technician, use to examine and restoreprotected system files?()A、SFCB、RECOVERC、REPLACED、COPY

To examine the Exhibit, press the Exhibit button. Which of the following addresses will be reachable without adding any routes?()A、129.35.54.21B、129.35.57.21C、129.35.58.21D、129.35.55.21

Your alert log file has the following information: Tue May 25 17:43:38 2004  ORA-00060: Deadlock detected. More info in file  /u01/app/oracle/admin/ORCL/udump/orcl_ora_3173.trc.  What would you do to ensure that database is still running correctly?()A、examine the trace file and kill the session that caused the deadlockB、examine the trace file and kill both the sessions responsible for the deadlockC、examine the trace file for details and ask the user who caused the deadlock to roll back the transactionD、examine the trace file for details and remember that deadlocks are resolved automatically by Oracle databaseE、examine the trace file for details and use the Undo Advisor to rollback the transaction that caused the deadlock

You have a computer that runs Windows 7. You configure the computer to automatically install all updates.You need to verify whether a specific update is installed.  What should you do?()A、In Event Viewer, examine the Application log.B、In Windows Update, examine the update history.C、At the command prompt, run Wusa.exe and specify the /kb parameter.D、At the command prompt, run Verifier.exe and specify the /query parameter.

Your network consists of a single Active Directory domain that contains two domain controllers. Both domain controllers run Windows Server 2003 Service Pack 2 (SP2). Auditing of successful account logon events is enabled on all computers in the domain. You need to identify the last time a specific user logged on to the domain. What should you do? ()A、Examine the System Event Log on the user’s computer.B、Examine the System Event Log on both domain controllers.C、Examine the Security Event Log on both domain controllers.D、Examine the Application Event Log on the user’s computer.

You are the network administrator for You administer a Windows Server 2003 computer named TestKing5. The hardware vendor for TestKing5 notifies you that a critical hotfix is available. This hotfix is required for all models of this computer that have a certain network interface card. You need to find out if the network interface card that requires the hotfix is installed in TestKing5. 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.

单选题Whose duty is it to examine and verify the state and condition of the cargo carried on board?().ATallyman'sBMarine surveyor'sCCargo surveyor'sDBoarding inspector's

单选题The()may examine or re-examine the goods or take samples from them straightaway in the absence of the consignee or the consignor whenever it considers this necessary.ACustomsBThe ministry of commerceCThe state councilDthe commodity inspection institution

单选题A systematic textbook evaluation is NOT to examine whether a textbook .Acovers all grammatical rulesBprovides authentic languageCmatches the needs of learnersDcan help realize the objectives of a language program

单选题For visitors whose time is limited and are unable to learn the history and examine the building in detail on the spot, it is suggested that the following plan of a journey be followed.AwhoseBand are unableConDbe followed

单选题Put in the engine turning gear Now examine thoroughly inside the crankcase to () that everything is correct.Amake sureBbe sureCassureDbelieve

单选题You have a server that runs Windows Server 2003 Service Pack 2 (SP2). An incremental backup runs every weekday at 01:00. On Friday, you examine the Windows Backup log and discover that the last entry in the log is one week old. You need to identify the problem that prevents the backup from running. What should you do? ()AFrom Scheduled Tasks, examine the log.BFrom Event Viewer, examine the system log.CFrom Windows Backup, enable detailed logging and then perform a manual backup.DFrom Windows Explorer, examine the files in the %systemroot%/system32/LogFiles folder.

单选题For a general cargo ship, is not the necessary certificate/document that the PSCO will examine()ASurvey Report FileBMinimum Safe Manning documentCCertificates of CompetencyDInternational Oil Pollution Prevention

单选题What is NOT a requirement of the reinspection for a tank barge with a certificate of inspection valid for two years? ()AThe reinspection will be made between the fourteenth and sixteenth monthsBThe inspector shall examine all accessible parts of the vessels's hullCThe inspector shall examine the vessel's machinery as well as equipmentDThe scope of the reinspection shall be the same as for the inspection for certification,but in less detail