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
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
相关考题:
Statement是PreparedStatement的父接口。Statement对象用于执行不带参数的简单SQL语句;PreparedStatement对象用于执行预编译SQL语句。() 此题为判断题(对,错)。
下列选项中,关于Statement描述错误的是()A.Statement是用来执行SQL语句的B.Statement是PreparedStatement的子接口C.获取Statement实现需要使用Connection的createStatement()方法D.PreparedStatement能使用参数占位符,而Statement不行
下列选项中,关于Statement描述错误的是()A.Statement是用来执行SQL语句的B.Statement是PreparedStatement的子接口C.获取Statement实现需要使用Connection的createStatement()方法D.PreparedStatement能使用参数占位符,而Statement不行
3.下列选项中,关于Statement描述错误的是() A: Statement是用来执行SQL语句的 B: Statement是PreparedStatement的子接口 C: 获取Statement实现需要使用Connection的createStatement()方法 D: PreparedStatement能使用参数占位符,而Statement不行A.A B C DB.A B C DC.A B C DD.A B C D
1、写出Java程序中用Statement来执行sql查询与更新语句。