CREATE，DROP，ALTER等命令属于下列哪类命令（）

（单选题）

要审计用户执行的create，drop，和alter等ddl语句，应创建（）触发器。

答案解析

（单选题）

How can you reverse the effects of an ALTER DISKGROUP ... DROP DISK command if it has alreadycompleted?（）

答案解析

（单选题）

How can you reverse the effects of an ALTER DISKGROUP ... DROP DISK command if it has not yetcompleted?（）

答案解析

（单选题）

You are managing an ASM instance. You previously issued the following statements: ALTER DISKGROUP dg1 DROP DISK disk2; ALTER DISKGROUP dg1 DROP DISK disk3; ALTER DISKGROUP dg1 DROP DISK disk5; You want to cancel the disk drops that are pending for the DG1 disk group. Which statement should you issue?（）

答案解析

（单选题）

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？（）

答案解析

（单选题）

Consider the following statement on a RANGE partitioned table: ALTER TABLE orders DROP PARTITION p1, p3; What is the outcome of executing the above statement?（）

答案解析

（单选题）

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？ （）

答案解析

（单选题）

What is the net effect of the following command？（）   alter diskgroup dgroup1 drop disk abc；

答案解析

（单选题）

Which are SRW package procedure or function could you use to create and then drop a temporary table in the sales report?（）

答案解析