CMS专题
单选题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
题目
The commands execute successfully.
Command 6 produces an error because of circular role grant.
Command 5 produces an error because a role cannot be granted to another role.
Command 3 produces an error because the MGRROLE role already contains system privileges.
The table created by HR remains and HR still has the CREATE TABLE system privilege.
The table created by HR remains and HR can grant the CREATE TABLE system privilege to other users.
相似问题和答案
第1题：
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.
第2题：
In(71)programming, the user determines the sequence of instructions to be executed, not programmer。
A．structure
B．event-driven
C．top-down
D．data-driven
解析：在事件驱动的程序设计中，由用户而不是程序员来确定指令的执行顺序。
第3题：
Examine the following commands and their output:SQL> SELECT ename, sal FROM emp WHERE ename=‘JAMES‘; ENAME SAL JAMES 1050QL> UPDATE emp SET sal=sal+sal*1.2 WHERE ename=‘JAMES‘;1 row updated.SQL> SELECT ename, sal FROM emp WHERE ename=‘JAMES‘; ENAME SAL JAMES 2310View 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.
第4题：
Which of the following commands displays the number of system calls per second that are being executed？（）
- A、 sar
- B、 pstat
- C、 iostat
- D、 filemon
正确答案:A
第5题：
In ______ programming, the user determines the sequence of instructions to be executed, not programmer.
A．top-down
B．structure
C．data-driven
D．event-driven
解析：译文的含义是：在()编程中，用户决定了指令的执行顺序而不是由程序员决定。选项A、B、C、D的含义分别是自顶向下、结构、数据驱动，事件驱动。选项D符合题意，为所选。
第6题：
A. Only the data definition language (DDL) commands that resulted in errors are logged in the alert log file.
B. All DDL commands are logged in the alert log file.
C. All DDL commands are logged in a different log file that contains DDL statements and their execution dates.
D. Only DDL commands that resulted in the creation of new segments are logged.
E. All DDL commands are logged in XML format in the alert directory under the Automatic Diagnostic Repository (ADR) home.
第7题：
A sequence was created with the DDL statement shown below:CREATE SEQUENCE my_sequence CACHE 10 ORDER The following statements are successfully executed in sequence through separate database connections: CONNECTION1 - VALUES NEXT VALUE FOR my_sequence INTO :con1hvar CONNECTION2 - VALUES NEXT VALUE FOR my_sequence INTO :con2hvar CONNECTION1 - VALUES NEXT VALUE FOR my_sequence INTO:con1hvarWhat is the current value of the :con1hvar host variable?（）
A.2
B.3
C.11
D.30
第8题：
A. The execution of the script fails because multiple channels cannot coexist.
B. The script is executed and both the channels are used for the script execution.
C. The new channel, CHI, is Ignored because a channel has been configured already.
D. ration parameter DC1 is overridden because a new channel is allocated in RMAN RUN block.
第9题：
Which of the following commands should Karen, a technician, use to examine and restoreprotected system files?（）
- A、SFC
- B、RECOVER
- C、REPLACE
- D、COPY
正确答案:A
第10题：
Which of the following commands should be used to identify packet sequence problems？（）
- A、 ping and arp
- B、 lsattr and ifconfig
- C、 netstat and iostat
- D、 iptrace and tcpdump
正确答案:D