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 s

题目

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:TRUNC”相关问题

第1题

Examine the structure of the EMPLOYEES and DEPARTMENTS tables:Evaluate this SQL statement:Which SQL statement is equivalent to the above SQL statement?()A.B.C.D.

点击查看答案
第2题

Evaluate the set of SQL statements:What is true about the set?()A. The DESCRIBE DEPT statement displays the structure of the DEPT table.B. The ROLLBACK statement frees the storage space occupies by the DEPT table.C. The DESCRIBE DEPT statement returns an error ORA-04043: object DEPT does not exist.D. The DESCRIBE DEPT statement displays the structure of the DEPT table only if there is a COMMIT statement introduced before the ROLLBACK statement.

点击查看答案
第3题

Evaluate the SQL statement: SELECT LPAD(salary,10,*) FROM EMP WHERE EMP_ID = 1001; If the employee with the EMP_ID 1001 has a salary of 17000, what is displayed?（）A、17000.00B、17000*****C、****170.00D、**17000.00E、an error statement

点击查看答案
第4题

Evaluate the SQL statement: SELECT ROUND(TRUNC(MOD(1600,10),-1),2) FROM dual; What will be displayed?（）A、0B、1C、0.00D、An error statement

点击查看答案
第5题

Evaluate the following query: SQL> SELECT TRUNC(ROUND(156.00,-1),-1)FROM DUAL; What would be the outcome?（）A、16 B、100 C、160 D、200 E、150

点击查看答案
第6题

Evaluate the SQL statement: SELECT LPAD (salary,10,*) FROM EMP WHERE EMP _ ID = 1001; If the employee with the EMP_ID 1001 has a salary of 17000, what is displayed?（）A、17000.00B、17000*****C、****170.00D、**17000.00E、an error statement

点击查看答案
第7题

Evaluate the SQL statement: SELECT ROUND(45.953, -1), TRUNC(45.936, 2) FROM dual; Which values are displayed? （）A、46 and 45B、46 and 45.93C、50 and 45.93D、50 and 45.9E、45 and 45.93F、45.95 and 45.93

点击查看答案

Evaluate the SQL statement:TRUNC

题目

更多“Evaluate the SQL statement:TRUNC”相关问题

第1题

第2题

第3题

第4题

第5题

第6题

第7题

相关内容