niusouti.com

单选题You execute the following command toauditdatabase activities：  SQL>AUDITDROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL；  What is the effect of this command（）A Oneauditrecord is created for every successful DROP TABLE command executed in the ses

题目
单选题
You execute the following command toauditdatabase activities：  SQL>AUDITDROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL；  What is the effect of this command（）
A

Oneauditrecord is created for every successful DROP TABLE command executed in the session ofSCOTT.

B

Oneauditrecord is generated for the session when SCOTT grants the DROP ANY TABLE privilege toother users.

C

One audit record is created for the whole session if user SCOTT successfully drops one or more tablesin his session.

D

One audit record is created for every session of any other user in which a table owned by SCOTT isdropped successfully.

E

One audit record is created for every successful DROP TABLE command executed by any user to droptables owned by SCOTT.

相似考题

1.Examine the output of the query that you executed to list the objects in the recycle bin:You verified that no table named SALES_TAB exists in the schema. Then you executed the following command to purge the objects in the recycle bin:SQL> PURGE TABLE sales_tab;What would be the outcome of this command?（）A. All three tables in the recycle bin are purgedB. Only the table with the oldest DROPSCN is purgedC. The command returns an error because multiple entries with the same name exist in the recycle binD. Only the table with the latest DROPSCN is purged

2. You execute the following command to audit database activities： SQL> AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL； What is the effect of this command（）A、One audit record is created for every successful DROP TABLE command executed in the session of SCOTT.B、One audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to otherusers.C、One audit record is created for the whole session if user SCOTT successfully drops one or more tables inhis session.D、One audit record is created for every session of any other user in which a table owned by SCOTT isdropped successfully.E、One audit record is created for every successful DROP TABLE command executed by any user to drop Tables owned by SCOTT

3. You execute this command to drop the ITEM table， which has the primary key referred in the ORDERtable：  SQL> DROP TABLE scott.item CASCADE CONSTRAINTS PURGE；  Which two statements are true about the effect of the command（）A、No flashback is possible to bring back the ITEM table.B、The ORDER table is dropped along with the ITEM table.C、The dependent referential integrity constraints in the ORDER table are disabled.D、The dependent referential integrity constraints in the ORDER table are removed.E、The table definition of the ITEM table and associated indexes are placed in the recycle bin.

4.You just issued the following statement: ALTER TABLE SALES DROP COLUMN PROFIT. Which of the following choices identifies when the column will actually be removed from Oracle?（）A、Immediately following statement execution B、After the ALTER TABLE DROP UNUSED COLUMNS command is issued C、After the ALTER TABLE SET UNUSED COLUMN command is issued D、After the ALTER TABLE MODIFY command is issued

参考答案和解析
正确答案： A
解析： 暂无解析
更多“单选题You execute the following command toauditdatabase activities：  SQLAUDITDROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL；  What is the effect of this command（）A Oneauditrecord is created for every successful DROP TABLE command executed in the sess”相关问题

  • 第1题：

    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

  • 第2题：

    You execute the following command in your Certkiller .com production database to change the width of the CUST_NAME column of the CUSTOMERS table： ALTER TABLE customers  MODIFY （cust_nameVARCHAR2 （40）） /  When you execute the command， it displays the following error message：  ERROR at line 1：  ORA-00054： resource busy and acquire with NOWAIT specified  What could be the reason for the error message？（）

    • A、The database instance is not available.
    • B、The ALTER TABLE command does not have WAIT option
    • C、The table or a row in the table is currently locked by another user session.
    • D、The database instance is busy processing other user sessions commands.
    • E、The CUSTOMERS table has no long running query active at the time when this request is made.
    • F、The server process executing the ALTER TABLE command is busy with another command execution

    正确答案:C

  • 第3题：

    One of the users in the PROD database， Adams， complains that his update on the table， TRANS， is taking an unusually long time to complete. You find that the table gets locked by another database user before Adams starts his transactions， and you are unable to contact the user holding the table lock. As Adams is updating some crucial rows in the table， he should get the highest priority. Which method would you use to overcome this problem？（）

    • A、execute the command， ALTER SESSION KILL ..， to kill the blocking session
    • B、execute the DBMS_SESSION.KILL_SESSION procedure to kill the blocking session
    • C、execute the command， ALTER SYSTEM KILL SESSION ..， to kill the blocking session
    • D、execute the command， ALTER SESSION UNLOCK ..， to release the lock for the blocking session
    • E、execute the command， ALTER SYSTEM UNLOCK SESSION ..， to release the lock for the blocking session

    正确答案:C

  • 第4题：

    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.

    正确答案:B

  • 第5题：

    You execute this command to drop the ITEM table， which has the primary key referred in the ORDERS table：SQL> DROP TABLE scott.item CASCADE CONSTRAINTS PURGE；  Which two statements are true about theeffect of the command（）

    • A、No flashback is possible to bring back the ITEM table.
    • B、The ORDERS table is dropped along with the ITEM table.
    • C、The dependent referential integrity constraints in the ORDERS table are disabled.
    • D、The dependent referential integrity constraints in the ORDERS table are removed.
    • E、The table definition of the ITEM table and associated indexes are placed in the recycle bin

    正确答案:A,D

  • 第6题：

    Note the output of the following query；   SQL> SELECT flashback_archieve_name， status FROM dba_flashback_archieve； FLASHBACK_ARCHIEVE_NAME STATUS FLA1   You executed the following command to enable Flashback Data Archive on the EXCHANGB_PATE table：   ALTER TABLE exchange_rate FLASHBACK ARCHIEVE；   What is the outcome of this command？（）  

    • A、 The table uses the default Flashback Data Archive.
    • B、 The Flashback Data Archive Is created In the SYSAUX tablespace.
    • C、 The Flashback Data Archive is created in the same tablespace where the tables are stored.
    • D、 The command generates an error because no flashback Data Archive name is specified and there is no default Flashback Data Achieve.

    正确答案:A

  • 第7题：

    单选题
    You execute the following command to audit database activities： SQL> AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL； What is the effect of this command（）
    A

    One audit record is created for every successful DROP TABLE command executed in the session of SCOTT.

    B

    One audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to otherusers.

    C

    One audit record is created for the whole session if user SCOTT successfully drops one or more tables inhis session.

    D

    One audit record is created for every session of any other user in which a table owned by SCOTT isdropped successfully.

    E

    One audit record is created for every successful DROP TABLE command executed by any user to drop Tables owned by SCOTT


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

  • 第8题：

    多选题
    You execute this command to drop the ITEM table， which has the primary key referred in the ORDERtable：  SQL> DROP TABLE scott.item CASCADE CONSTRAINTS PURGE；  Which two statements are true about the effect of the command（）
    A

    No flashback is possible to bring back the ITEM table.

    B

    The ORDER table is dropped along with the ITEM table.

    C

    The dependent referential integrity constraints in the ORDER table are disabled.

    D

    The dependent referential integrity constraints in the ORDER table are removed.

    E

    The table definition of the ITEM table and associated indexes are placed in the recycle bin.


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

  • 第9题：

    单选题
    View the Exhibit and examine the structure of the EMP table. You executed the following command to add a primary key to the EMP table：   ALTER TABLE emp   ADD CONSTRAINT emp_id_pk  PRIMARY KEY （emp_id）   USING INDEX emp_id_idx；   Which statement is true regarding the effect of the command？（）
    A

     The PRIMARY KEY is created along with a new index.

    B

     The PRIMARY KEY is created and it would use an existing unique index.

    C

     The PRIMARY KEY would be created in a disabled state because it is using an existing index.

    D

     The statement produces an error because the USING clause is permitted only in the CREATE TABLE command.


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

  • 第10题：

    多选题
    You issued the following command to drop the PRODUCTS table: SQL> DROP TABLE products; What is the implication of this command?（）
    A

    All data along with the table structure is deleted

    B

    The pending transaction in the session is committed

    C

    All indexes on the table will remain but they are invalidated

    D

    All views and synonyms will remain but they are invalidated

    E

    All data in the table are deleted but the table structure will remain


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

  • 第11题：

    单选题
    You just issued the following statement: ALTER TABLE SALES DROP COLUMN PROFIT. Which of the following choices identifies when the column will actually be removed from Oracle?（）
    A

    Immediately following statement execution 

    B

    After the ALTER TABLE DROP UNUSED COLUMNS command is issued 

    C

    After the ALTER TABLE SET UNUSED COLUMN command is issued 

    D

    After the ALTER TABLE MODIFY command is issued


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

  • 第12题：

    多选题
    You execute this command to drop the ITEM table， which has the primary key referred in the ORDERS table：SQL> DROP TABLE scott.item CASCADE CONSTRAINTS PURGE；  Which two statements are true about theeffect of the command（）
    A

    No flashback is possible to bring back the ITEM table.

    B

    The ORDERS table is dropped along with the ITEM table.

    C

    The dependent referential integrity constraints in the ORDERS table are disabled.

    D

    The dependent referential integrity constraints in the ORDERS table are removed.

    E

    The table definition of the ITEM table and associated indexes are placed in the recycle bin


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

  • 第13题：

    You execute the following command to audit the database activities：   SQL> AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL；  What is the effect of this command？（）

    • A、One audit record is created for the whole session if user SCOTT successfully drops one or more tables in his session.
    • B、One audit record is created for every session when any user successfully drops a table owned by SCOTT.
    • C、One audit record is created for each successful DROP TABLE command executed by any user to drop tables owned by SCOTT.
    • D、One audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to other users in his session.
    • E、One audit record is created for each successful DROP TABLE command executed in the session of SCOTT.

    正确答案:A

  • 第14题：

    You issued the following command to drop the PRODUCTS table: SQL> DROP TABLE products; What is the implication of this command?（）

    • A、All data along with the table structure is deleted 
    • B、The pending transaction in the session is committed 
    • C、All indexes on the table will remain but they are invalidated 
    • D、All views and synonyms will remain but they are invalidated 
    • E、All data in the table are deleted but the table structure will remain

    正确答案:A,B,D

  • 第15题：

    You execute the following commands to audit database activities: SQL > ALTER SYSTEM SET AUDIT_TRIAL=DB, EXTENDED SCOPE=SPFILE; SQL > AUDIT SELECT TABLE, INSERT TABLE, DELETE TABLE BY JOHN By SESSION WHENEVER SUCCESSFUL; Which statement is true about the audit record that generated when auditing after instance restarts?（）

    • A、One audit record is created for every successful execution of a SELECT, INSERT OR DELETE command on a table, and contains the SQL text for the SQL Statements.
    • B、One audit record is created for every successful execution of a SELECT, INSERT OR DELETE command, and contains the execution plan for the SQL statements.
    • C、One audit record is created for the whole session if john successfully executes a SELECT, INSERT, or DELETE command, and contains the execution plan for the SQL statements.
    • D、One audit record is created for the whole session if JOHN successfully executes a select command, and contains the SQL text and bind variables used.
    • E、One audit record is created for the whole session if john successfully executes a SELECT, INSERT,or DELETE command on a table, and contains the execution plan, SQL text, and bind variables used.

    正确答案:A

  • 第16题：

    You executed the following command to drop a user: DROP USER scott CASCADE; Which two statements regarding the above command are correct?（）

    • A、All the objects of scott are moved to the Recycle Bin.
    • B、Any objects in the Recycle Bin belonging to scott are purged.
    • C、All the objects owned by scott are permanently dropped from the database.
    • D、All the objects of scott in the Recycle Bin must be purged before executing the DROP command.
    • E、Any objects in the Recycle Bin belonging to scott will not be affected by the above DROP command.

    正确答案:B,C

  • 第17题：

    You execute the following command toauditdatabase activities：  SQL>AUDITDROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL；  What is the effect of this command（）

    • A、Oneauditrecord is created for every successful DROP TABLE command executed in the session ofSCOTT.
    • B、Oneauditrecord is generated for the session when SCOTT grants the DROP ANY TABLE privilege toother users.
    • C、One audit record is created for the whole session if user SCOTT successfully drops one or more tablesin his session.
    • D、One audit record is created for every session of any other user in which a table owned by SCOTT isdropped successfully.
    • E、One audit record is created for every successful DROP TABLE command executed by any user to droptables owned by SCOTT.

    正确答案:C

  • 第18题：

    单选题
    You execute the following commands to audit database activities: SQL > ALTER SYSTEM SET AUDIT_TRIAL=DB, EXTENDED SCOPE=SPFILE; SQL > AUDIT SELECT TABLE, INSERT TABLE, DELETE TABLE BY JOHN By SESSION WHENEVER SUCCESSFUL; Which statement is true about the audit record that generated when auditing after instance restarts?（）
    A

    One audit record is created for every successful execution of a SELECT, INSERT OR DELETE command on a table, and contains the SQL text for the SQL Statements.

    B

    One audit record is created for every successful execution of a SELECT, INSERT OR DELETE command, and contains the execution plan for the SQL statements.

    C

    One audit record is created for the whole session if john successfully executes a SELECT, INSERT, or DELETE command, and contains the execution plan for the SQL statements.

    D

    One audit record is created for the whole session if JOHN successfully executes a select command, and contains the SQL text and bind variables used.

    E

    One audit record is created for the whole session if john successfully executes a SELECT, INSERT,or DELETE command on a table, and contains the execution plan, SQL text, and bind variables used.


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

  • 第19题：

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

  • 第20题：

    多选题
    You executed the following command to drop a user：   DROP USER scott CASCADE；   Which two statements regarding the above command are correct？（）
    A

    All the objects of scott are moved to the Recycle Bin.

    B

    Any objects in the Recycle Bin belonging to scott are purged.

    C

    All the objects owned by scott are permanently dropped from the database.

    D

    All the objects of scott in the Recycle Bin must be purged before executing the DROP command.

    E

    Any objects in the Recycle Bin belonging to scott will not be affected by the above DROP command.


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

  • 第21题：

    单选题
    Note the output of the following query；   SQL> SELECT flashback_archieve_name， status FROM dba_flashback_archieve； FLASHBACK_ARCHIEVE_NAME STATUS FLA1   You executed the following command to enable Flashback Data Archive on the EXCHANGB_PATE table：   ALTER TABLE exchange_rate FLASHBACK ARCHIEVE；   What is the outcome of this command？（）
    A

     The table uses the default Flashback Data Archive.

    B

     The Flashback Data Archive Is created In the SYSAUX tablespace.

    C

     The Flashback Data Archive is created in the same tablespace where the tables are stored.

    D

     The command generates an error because no flashback Data Archive name is specified and there is no default Flashback Data Achieve.


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

  • 第22题：

    单选题
    You execute the following command in your Certkiller .com production database to change the width of the CUST_NAME column of the CUSTOMERS table： ALTER TABLE customers  MODIFY （cust_nameVARCHAR2 （40）） /  When you execute the command， it displays the following error message：  ERROR at line 1：  ORA-00054： resource busy and acquire with NOWAIT specified  What could be the reason for the error message？（）
    A

    The database instance is not available.

    B

    The ALTER TABLE command does not have WAIT option

    C

    The table or a row in the table is currently locked by another user session.

    D

    The database instance is busy processing other user sessions commands.

    E

    The CUSTOMERS table has no long running query active at the time when this request is made.

    F

    The server process executing the ALTER TABLE command is busy with another command execution


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

  • 第23题：

    单选题
    You execute the following command to audit the database activities：  SQL> AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL；  What is the effect of this command？（）
    A

    One audit record is created for the whole session if user SCOTT successfully drops one or more tables in his session.

    B

    One audit record is created for every session when any user successfully drops a table owned by SCOTT.

    C

    One audit record is created for each successful DROP TABLE command executed by any user to drop tables owned by SCOTT.

    D

    One audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to other users in his session.

    E

    One audit record is created for each successful DROP TABLE command executed in the session of SCOTT.


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

相关内容