违法和不良信息举报 联系客服
免费注册 登录

Evaluate the SQL statement:TRUNC

题目

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
如果没有搜索结果或未解决您的问题，请直接 联系老师 获取答案。
相似问题和答案

第1题：

Evaluate the SQL statement DROP TABLE DEPT: Which four statements are true of the SQL statement? ()

A. You cannot roll back this statement.

B. All pending transactions are committed.

C. All views based on the DEPT table are deleted.

D. All indexes based on the DEPT table are dropped.

E. All data in the table is deleted, and the table structure is also deleted.

F. All data in the table is deleted, but the structure of the table is retained.

G. All synonyms based on the DEPT table are deleted.


参考答案：A, B, D, E

第2题：

Evaluate this SQL statement:In the statement, which capabilities of a SELECT statement are performed?()

A. Selection, projection, join

B. Difference, projection, join

C. Selection, intersection, join

D. Intersection, projection, join

E. Difference, projection, product


参考答案：A

第3题：

The PRODUCTS table has these columns:PRODUCT_ID NUMBER(4)PRODUCT_NAME VARCHAR2(45)PRICE NUMBER(8,2)Evaluate this SQL statement:SELECT *FROM PRODUCTSORDER BY price, product _ name;What is true about the SQL statement? （）

A. The results are not sorted.

B. The results are sorted numerically.

C. The results are sorted alphabetically.

D. The results are sorted numerically and then alphabetically.


参考答案：D

第4题：

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.


参考答案：A

第5题：

Evaluate the SQL statement:What will be displayed?()

A. 0

B. 1

C. 0.00

D. An error statement


参考答案：A

第6题：

Evaluate the SQL statement:SELECT LPAD (salary,10,*)FROM EMPWHERE EMP _ ID = 1001;If the employee with the EMP_ID 1001 has a salary of 17000, what is displayed?()

A. 17000.00

B. 17000*****

C. ****170.00

D. **17000.00

E. an error statement


参考答案：D

第7题：

Evaluate these two SQL statements:What is true about them?()

A. The two statements produce identical results.

B. The second statement returns a syntax error.

C. There is no need to specify DESC because the results are sorted in descending order by default.

D. The two statements can be made to produce identical results by adding a column alias for the salary column in the second SQL statement.


参考答案：A

第8题：

Evaluate the SQL statement:SELECT ROUND(45.953, －1), TRUNC(45.936, 2)FROM dual;Which values are displayed? ()

A. 46 and 45

B. 46 and 45.93

C. 50 and 45.93

D. 50 and 45.9

E. 45 and 45.93

F. 45.95 and 45.93


参考答案：C

第9题：

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.


参考答案：C

第10题：

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.00
  • B、17000*****
  • C、****170.00
  • D、**17000.00
  • E、an error statement

正确答案:E

更多相关问题
相关内容