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

多选题Evaluate the SQL statement:TRUNCATE TABLE DEPT;Which three are true about the SQL statement? （）AIt releases the storage space used by the table.BIt does not release the storage space used by the table.CYou 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

如果没有搜索结果或未解决您的问题，请直接 联系老师 获取答案。
相似问题和答案

第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题：

Which two statements about subqueries are true? （）

  • A、A subquery should retrieve only one row.
  • B、A subquery can retrieve zero or more rows.
  • C、A subquery can be used only in SQL query statements.
  • D、Subqueries CANNOT be nested by more than two levels.
  • E、A subquery CANNOT be used in an SQL query statement that uses group functions.
  • F、When a subquery is used with an inequality comparison operator in the outer SQL statement, the column list in the SELECT clause of the subquery should contain only one column.

正确答案:B,F

第3题：

View the exhibit and examine the TRANS table‘s storage information.After a massive delete operation, you executed the following statement to shrink the TRANS table:SQL> ALTER TABLE trans SHRINK SPACE CASCADE;Which statement describes the outcome of the command?（）

A. An error is produced.

B. The table and all related objects are compacted and the position of the high-water mark (HWM) for the table is adjusted

C. The table and related indexes are compacted but the position of the high-water mark (HWM) for the table remains unchanged

D. The unused space in the table is reclaimed and returned to the tablespace and the data manipulation language (DML) triggers on the table are fired during the shrinking process


参考答案：B

第4题：

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

第5题：

Evaluate the set of SQL statements: CREATE TABLE dept (deptno NUMBER(2), dname VARCHAR2(14), loc VARCHAR2(13)); ROLLBACK; DESCRIBE DEPT 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 occupied 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

第6题：

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

第7题：

Which three are true?（）

  • A、A MERGE statement is used to merge the data of one table with data from another.
  • B、A MERGE statement replaces the data of one table with that of another.
  • C、A MERGE statement can be used to insert new rows into a table.
  • D、A MERGE statement can be used to update existing rows in a table.

正确答案:A,C,D

第8题：

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


参考答案：B, D, F

第9题：

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

正确答案:A,D,F

第10题：

Which two statements about subqueries are true?（）

  • A、A single row subquery can retrieve data from only one table.
  • B、A SQL query statement cannot display data from table B that is referred to in its subquery, unless table B is included in the main query's FROM clause.
  • C、A SQL query statement can display data from table B that is referred to in its subquery, without including table B in its own FROM clause.
  • D、A single row subquery can retrieve data from more than one table.
  • E、A single row subquery cannot be used in a condition where the LIKE operator is used for comparison.
  • F、A multiple-row subquery cannot be used in a condition where the LIKE operator is used for comparison.

正确答案:B,D

更多相关问题
相关内容