关于Truncate table, 以下()描述是错误的。A、Truncate table 可跟Where从句,根据条件进行删除B、Truncate table 用来删除表中所有数据C、触发器对Truncate table无效D、delete 比Truncate table速度快
关于Truncate table, 以下()描述是错误的。
- A、Truncate table 可跟Where从句,根据条件进行删除
- B、Truncate table 用来删除表中所有数据
- C、触发器对Truncate table无效
- D、delete 比Truncate table速度快
相关考题:
数据表从数据库中删除(连表名也删除)的命令语句如下:() A. drop table 表名;B. insert into 表名(字段名列表) values(值列表);C. delete from 表名 where 条件;D. truncate table 表名。
如果要删除Student数据库中的Information表,可以使用下列哪个命令?一——A.ALTER TABLE InformationB.TRUNCATE TABLE InformationC.DROP。TABLE InformationD.DELETE TABLE Information
Evaluate the SQL statement: TRUNCATE TABLE DEPT; Which three are true about the SQL statement? () A. It releases the storage space used by the table.B. It does not release the storage space used by the table.C. You can roll back the deletion of rows after the statement executes.D. You can NOT roll back the deletion of rows after the statement executes.E. An attempt to use DESCRIBE on the DEPT table after the TRUNCATE statement executes will display an error.F. You must be the owner of the table or have DELETE ANY TABLE system privileges to truncate the DEPT table
若要删除book表中所有数据,以下语句错误的是哪两项?() A.delete all from bookB.delete from bookC.truncate table bookD.drop table book
请问oracle的整表删除操作()是正确的。A、truncate table tablenameB、delete from tablenameC、delete*from tablenameD、以上都不对
ORACLE数据库中如何删除表table中的所有记录,并回收所有空间()A、delete * from tableB、delete from tableC、truncate tableD、clear table
删除emp表中所有数据,且无法rollback,以下语句哪个命令可以实现()A、truncate table empB、drop table empC、delete * from empD、delete from emp
要求删除表test中的所有数据,但是不删除表,而且该删除操作不允许ROLLBACK,应该使用的语句为()。A、UPDATA testB、DROP TABLE testC、DELETE FROM testD、TRUNCATE TABLE test
删除emp表的全部数据,但不提交,以下正确的语句是()A、DELETE * FROM. EMPB、DELETE FROM EMPC、TRUNCATE TABLE EMPD、DELETE TABLE EMP"
如下能正确执行的语句是()A、select * from table_name where 1=2B、truncate table table_nameC、delete from table_name where null=nullD、alter table table_name add column idd int
关于Truncatetable,以下()描述是正确的。A、Truncate table 可跟Where从句,根据条件进行删除B、Truncate table 用来删除表中所有数据C、触发器对Truncate table无效D、delete 比Truncate table速度快
关于Truncatetable,以下()描述是错误的。A、Truncate table可跟Where从句,根据条件进行删除。B、Truncate table用来删除表中所有数据。C、触发器对Truncate table无效。D、delete比Truncate table速度快。
若要删除book表中所有数据,以下语句错误的是()A、truncate table bookB、delete * from bookC、drop table bookD、delete from book
下面哪一个SQL语句将删除DEPT表中的所有数据,并永久删除DEPT表的整个结构()A、DROP TABLE dept;B、DELETE TABLE dept;C、TRUNCATE TABLE dept;D、DELETE * . * FROM dept; [END CODE]"
数据表从数据库中删除(连表名也删除)的命令语句如下:()A、drop table 表名;B、insert into 表名(字段名列表) values(值列表);C、delete from 表名 where 条件;D、truncate table 表名。
Evaluate the SQL statement:TRUNCATE TABLE DEPT;Which three are true about the SQL statement? ()A、It releases the storage space used by the table.B、It does not release the storage space used by the table.C、You can roll back the deletion of rows after the statement executes.D、You can NOT roll back the deletion of rows after the statement executes.E、An attempt to use DESCRIBE on the DEPT table after the TRUNCATE statement executes will display an error.F、You must be the owner of the table or have DELETE ANY TABLE system privileges to truncate the DEPT table
Which three descriptions are correct about the effects of the TRUNCATE command on a table()A、The corresponding indexes for the table are also truncated.B、Delete triggers on the table are fired during the execution of the TRUNCATE command.C、The child table is truncated when the TRUNCATE command is applied on the parent table.D、The high-water mark (HWM) is set to point to the first usable data block in the table segment.E、No undo or very little undo data is generated during the execution of the TRUNCATE command
假定表A中有十万条记录,要删除表中的所有数据,但仍要保留表的结构,请问用以下哪个命令效率最高()A、delete from a;B、drop table a;C、trunc table a;D、truncate table a;E、以上所述都不正确
多选题关于Truncatetable,以下()描述是正确的。ATruncate table 可跟Where从句,根据条件进行删除BTruncate table 用来删除表中所有数据C触发器对Truncate table无效Ddelete 比Truncate table速度快
多选题关于Truncatetable,以下()描述是错误的。ATruncate table可跟Where从句,根据条件进行删除。BTruncate table用来删除表中所有数据。C触发器对Truncate table无效。Ddelete比Truncate table速度快。
多选题Which three descriptions are correct about the effects of the TRUNCATE command on a table()AThe corresponding indexes for the table are also truncated.BDelete triggers on the table are fired during the execution of the TRUNCATE command.CThe child table is truncated when the TRUNCATE command is applied on the parent table.DThe high-water mark (HWM) is set to point to the first usable data block in the table segment.ENo undo or very little undo data is generated during the execution of the TRUNCATE command
多选题关于Truncate table, 以下()描述是错误的。ATruncate table 可跟Where从句,根据条件进行删除BTruncate table 用来删除表中所有数据C触发器对Truncate table无效Ddelete 比Truncate table速度快