单选题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.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.

2.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.

3.Examine the following command;ALTER SYSTEM SET enable_ddl_logging = TRUE;Which statement is true?()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.

4.Examine the following set of RMAN commands:Which statement is true when the RMAN RUN block Is executed?()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.

参考答案和解析
正确答案： B
解析： 暂无解析
更多“Examine the commands executed in the following sequence：  1：”相关问题

  • 第1题：

    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


    正确答案：B
    解析：在事件驱动的程序设计中，由用户而不是程序员来确定指令的执行顺序。

  • 第2题：

    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


    正确答案：D
    解析：译文的含义是：在()编程中，用户决定了指令的执行顺序而不是由程序员决定。选项A、B、C、D的含义分别是自顶向下、结构、数据驱动，事件驱动。选项D符合题意，为所选。

  • 第3题：

    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

  • 第4题：

    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

    正确答案:B

  • 第5题：

    What is the impact of the following backup if it exceeds the duration allowance？（） Backup as compressed backupset duration 2：00 partial minimize load database ；  

    • A、 The entire backup will fail.It will not be usable for recovery.
    • B、 The entire backup will failbut any datafile successfully backed up will be usable for recovery.
    • C、 If this backup fails，subsequent backups will prioritize datafiles not backed up.
    • D、 If this backup fails，an error will be raised and any other commands will not be executed. 
    • E、 If this backup fails，no error will be raised and any other commands will be executed.

    正确答案:B

  • 第6题：

    问答题
    What is the next number in the following sequence?　　1 - 2 - 3 - 5 - 8 - 13

    正确答案： 21
    解析：
    序列中每一个数字都是前两个数字的和，最后的两个数是8和13，因此下一个数就是8与13的和。

  • 第7题：

    单选题
    Flashback is enabled for your multitenant container database (CDB), which contains two pluggable database (PDBs). A local user was accidently dropped from one of the PDBs. You want to flash back the PDB to the time before the local user was dropped. You connect to the CDB and execute the following commands: SQL > SHUTDOWN IMMEDIATE SQL > STARTUP MOUNT SQL > FLASHBACK DATABASE to TIME “TO_DATE (‘08/20/12’ , ‘MM/DD/YY’)”; Examine following commands: 1. ALTER PLUGGABLE DATABASE ALL OPEN; 2. ALTER DATABASE OPEN; 3. ALTER DATABASE OPEN RESETLOGS; Which command or commands should you execute next to allow updates to the flashback back schema?（）
    A

    Only 1

    B

    Only 2

    C

    Only 3

    D

    3 and 1

    E

    1 and 2


    正确答案： C
    解析： 暂无解析

  • 第8题：

    单选题
    Examine the following command: SQL> ALTER TABLE booking SHRINK SPACE COMPACT; Which activity is performed when the preceding command is executed?（）
    A

    The shrink operation touches every block in the BOOKING table

    B

    The high-water mark (HWM) for the BOOKING table is shifted from its original position

    C

    The progress of the shrink operation is saved in the bitmap blocks of the BOOKING table

    D

    The data manipulation language (DML) triggers on the BOOKING table are executed because the shrink operation is internally handled by the INSERT/DELETE operation


    正确答案： D
    解析： 暂无解析

  • 第9题：

    单选题
    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
    解析： 暂无解析

  • 第10题：

    单选题
    Examine the following command：   SQL> ALTER TABLE booking SHRINK SPACE COMPACT；   Which activity is performed when the preceding command is executed？（）
    A

     The shrink operation touches every block in the BOOKING table

    B

     The high-water mark （HWM） for the BOOKING table is shifted from its original position

    C

     The progress of the shrink operation is saved in the bitmap blocks of the BOOKING table

    D

     The data manipulation language （DML） triggers on the BOOKING table are executed because the shrink operation is internally handled by the INSERT/DELETE operation


    正确答案： B
    解析： 暂无解析

  • 第11题：

    单选题
    Which of the following commands cannot be executed when the database open？（）
    A

    RECOVER DATABASE

    B

    RECOVER TABLESPACE

    C

    RECOVER DATAFILE

    D

    ALTER DATABASE RECOVER DATAFILE


    正确答案： A
    解析： 暂无解析

  • 第12题：

    单选题
    All the database users are presently connected to the database instance and working. The HR user hasopened three database sessions and executed the following command in one of his sessions：SQL> UPDATE persons SET ccode=’U031’ WHERE ccode=’U029’； 123 rows updated.SQL> DELETE FROM persons WHERE exp=’Y’；3 rows deleted. The SYS user opens a new session after HR executed the above commands.  Which sessions can see theeffect of the UPDATE and DELETE commands（）
    A

    All sessions of the HR user only

    B

    All sessions of the HR user and the SYS user

    C

    The session of the HR user that executed the commands

    D

    All the sessions for which the database users have access privilege to the PERSONS table


    正确答案： B
    解析： 暂无解析

  • 第13题：

    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


    参考答案：B

  • 第14题：

    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

  • 第15题：

    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

  • 第16题：

    The following databases are registered in the base recovery catalog： PROD1， PROD2， and PROD3. The database user CATOWNER owns the base recovery catalog. You want a new user VPC1 to have access to only the PROD1 database and create a virtual private catalog. Given below are some of the commands required to achieve this：   1.SQL> GRANT recovery_catalog_owner TO vpc1； 2.RMAN> CONNECT CATALOG vpc1/password@catdb；  3.RMAN> GRANT CATALOG FOR DATABASE prod1 TO vpc1； 4.RMAN> CONNECT CATALOG catowner/password@catdb；  5.RMAN> CREATE VIRTUAL CATALOG；   What is the correct sequence in which the commands have to be executed？（）  

    • A、 1，4，5，2，3
    • B、 1，4，3，2，5
    • C、 4，5，2，3，1
    • D、 2，3，4，5，1
    • E、 1，4，2，3，5

    正确答案:B

  • 第17题：

    Examine the following commands executed in your database： SQL> ALTER SESSION RECYCLEBIN=ON； Session altered  SQL > CREATE TABLE emp TABLESPACE tbsfd AS SELECT * FROM hr.employees；  Table created.  Further， you executed the following command to drop the table：  SQL> DROP TABLE emp；Table dropped.  What happens in this scenario？（）

    • A、The table is moved to the SYSAUX tablespace.
    • B、The table is moved to the SYSTEM tablespace.
    • C、The table is removed from the database permanently.
    • D、The table is renamed and remains in the TBSFD tablespace.

    正确答案:D

  • 第18题：

    单选题
    The following databases are registered in the base recovery catalog: PROD1, PROD2, and PROD3. The database user CATOWNER owns the base recovery catalog. You want a new user VPC1 to have access to only the PROD1 database and create a virtual private catalog. Given below are some of the commands required to achieve this: 1.SQL> GRANT recovery_catalog_owner TO vpc1; 2.RMAN> CONNECT CATALOG vpc1/password@catdb; 3.RMAN> GRANT CATALOG FOR DATABASE prod1 TO vpc1; 4.RMAN> CONNECT CATALOG catowner/password@catdb; 5.RMAN> CREATE VIRTUAL CATALOG; What is the correct sequence in which the commands have to be executed?（）
    A

    1, 4, 5, 2, 3

    B

    1, 4, 3, 2, 5

    C

    4, 5, 2, 3, 1

    D

    2, 3, 4, 5, 1

    E

    1, 4, 2, 3, 5


    正确答案： C
    解析： 暂无解析

  • 第19题：

    单选题
    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.


    正确答案： F
    解析： 暂无解析

  • 第20题：

    单选题
    You want to perform in incomplete recovery of your database.  You plan to use these commands to recover your database：  SET UNTIL TIME = ’2000-12-09：11：44：00’；  RESTORE DATABASE； RECOVER DATABASE；  How should the commands be executed？ （）
    A

    Only the SET command must be within a RUN block.

    B

    All commands should be executed at the RMAN prompt.

    C

    All three commands must be within a single RUN block.

    D

    Only the RESTORE and RECOVER commands must be within a single RUN block.


    正确答案： C
    解析： 暂无解析

  • 第21题：

    单选题
    Examine the following commands executed in your database： SQL> ALTER SESSION RECYCLEBIN=ON； Session altered  SQL > CREATE TABLE emp TABLESPACE tbsfd AS SELECT * FROM hr.employees；  Table created.  Further， you executed the following command to drop the table：  SQL> DROP TABLE emp；Table dropped.  What happens in this scenario？（）
    A

    The table is moved to the SYSAUX tablespace.

    B

    The table is moved to the SYSTEM tablespace.

    C

    The table is removed from the database permanently.

    D

    The table is renamed and remains in the TBSFD tablespace.


    正确答案： C
    解析： 暂无解析

  • 第22题：

    单选题
    Your database operates in ARCHIVELOGmode. The redo log files are not multiplexed and one of the online redo logs is missing. The missing redo log sequence， 230， is not archived and it contained information from 10：35 a.m. onwards. The current time is 11：00 a.m. Because of a disk crash， you executed the following command to perform an incomplete recovery：  RMAN> RUN {  2> SET UNTIL SEQUENCE 230 THREAD 1； 3> ALTER DATABASE MOUNT；  4> RESTORE DATABASE；  5> RECOVER DATABASE；  6> ALTER DATABASE OPEN RESETLOGS；  7> }；  With reference to this scenario， which statement is true？（）
    A

     RMAN recovers up to log sequence 230， but not including 230.

    B

     RMAN returns an error because the log sequence number mentioned in the command should be 229.

    C

     RMAN returns an error because the log sequence number mentioned in the command may never be missing.

    D

     RMAN recovers up to and including log sequence 229 but then returns an error because log sequence 230 is missing.


    正确答案： D
    解析： 暂无解析

  • 第23题：

    单选题
    Examine the following command; ALTER SYSTEM SET enable_ddl_logging = TRUE; Which statement is true?（）
    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.


    正确答案： D
    解析： 暂无解析

  • 第24题：

    单选题
    What is the impact of the following backup if it exceeds the duration allowance？（） Backup as compressed backupset duration 2：00 partial minimize load database ；
    A

     The entire backup will fail.It will not be usable for recovery.

    B

     The entire backup will failbut any datafile successfully backed up will be usable for recovery.

    C

     If this backup fails，subsequent backups will prioritize datafiles not backed up.

    D

     If this backup fails，an error will be raised and any other commands will not be executed. 

    E

     If this backup fails，no error will be raised and any other commands will be executed.


    正确答案： A
    解析： 暂无解析

相关内容