网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
Delete form. tablename与TRUNCATE table tablename的区别
参考答案
更多 “ Delete form. tablename与TRUNCATE table tablename的区别 ” 相关考题
考题
如果要删除Student数据库中的Information表，可以使用下列哪个命令?一——A．ALTER TABLE InformationB．TRUNCATE TABLE InformationC．DROP。TABLE InformationD．DELETE TABLE Information
考题
Overthecourseofaday，adepartmentperformedmultipleDMLstatements（inserts，updates，deletes）onmultiplerowsofdatainmultipletables.Themanagerwouldlikeareportshowingthetime，tablename，andDMLtypeforallchangesthatweremade.WhichFlashbacktechnologywouldbethebestchoicetoproducethelist？（）A.FlashbackDropB.FlashbackQueryC.FlashbackTransactionQueryD.FlashbackVersionsQueryE.FlashbackTable
考题
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
考题
如果要删除A数据库中的B表，可以使用下列哪个命令?______A．ALTER TABLE BB．TRUNCATE TABLE BC．DROP TABLE BD．DELETE TABLE B
考题
请问oracle的整表删除操作（）是正确的。A、truncate table tablenameB、delete from tablenameC、delete*from tablenameD、以上都不对
考题
ORACLE数据库中如何删除表table中的所有记录，并回收所有空间（）A、delete * from tableB、delete from tableC、truncate tableD、clear table
考题
您需要删除“计划”表中的所有数据、该表的结构以及与该表关联的索引,应使用哪条语句？（）A、DROP TABLEB、TRUNCATE TABLEC、ALTER TABLED、DELETE TABLE
考题
删除emp表中所有数据，且无法rollback，以下语句哪个命令可以实现（）A、truncate table empB、drop table empC、delete * from empD、delete from emp
考题
关于Truncate table, 以下（）描述是错误的。A、Truncate table 可跟Where从句，根据条件进行删除B、Truncate table 用来删除表中所有数据C、触发器对Truncate table无效D、delete 比Truncate table速度快
考题
MySQL中修改数据表的名字的命令是（）。A、Alter table tablename rename to new_nameB、Alter table tablename rename new_nameC、Rename tablename to newnameD、Rename tablename newname
考题
删除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速度快
考题
若要删除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]"
考题
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
考题
ExcelUtil的params参数中必须要传的是（）A、tableName、columnCaptionsB、tableName、columnNamesC、columnCaptions、columnNamesD、tableName、filter
考题
问答题数据库命令delete和truncate区别是什么？
热门标签
最新试卷
