Evaluate the SQL statement: TRUNCATE T

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

参考答案

参考解析：

分类：1Z0-007题库

相关推荐

1、Evaluate the SQL statement: What is

Evaluate the SQL statement:What is the result of the statement?（）A The statement produces an error at line 1.B The statement produces an erro...

2、Evaluate these two SQL statements: SE

Evaluate these two SQL statements:SELECT last_name, salary , hire_dateFROM EMPLOYEESORDER BY salary DESC;SELECT last_name, salary, hire_dateFROM EMPL...

3、Evaluate this SQL statement: In the

Evaluate this SQL statement:In the statement, which capabilities of a SELECT statement are performed?（）A Selection, projection, joinB Difference,...

4、Evaluate these two SQL statements: W

Evaluate these two SQL statements:What is true about them?（）A The two statements produce identical results.B The second statement returns a syn...

5、Evaluate the SQL statement DROP TABLE

Evaluate the SQL statement DROP TABLE DEPT: Which four statements are true of the SQL statement? （）A You cannot roll back this statement.B A...

6、Evaluate the SQL statement: What wil

Evaluate the SQL statement:What will be displayed?（）A 0B 1C 0.00D An error statement

编辑推荐

下列技术动作需要采用腹式呼吸的是（）。..

我国提高自主创新能力的必要性是（）。..

当公司股票增长到一定幅度，可转换债券持有人若不进行转股，.....

患者男，45岁，戴用可摘局部义齿1周后，与基托接触的黏膜出现.....

宋辽、宋夏、宋金和议的共同点不包括（）。..

我国主管部门对会计工作的管理体现了（）的原则。..