CMS专题

多选题Evaluate the SQL statement DROP TABLE DEPT: Which four statements are true of the SQL statement? （）AYou cannot roll back this statement.BAll pending transactions are committed.CAll views based on the DEPT table are deleted.DAll indexes based on the DEP

题目
多选题
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.

参考答案和解析
正确答案： B,E
解析： 暂无解析
如果没有搜索结果，请直接 联系老师 获取答案。
相似问题和答案

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

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

第3题：

The user Alice wants to grant all users query privileges on her DEPT table. Which SQL statement accomplishes this? ()

A. GRANT select ON dept TO ALL_ USER;

B. GRANT select ON dept TO ALL;

C. GRANT QUERY ON dept TO ALL_USERS

D. GRANT select ON dept TO PUBLIC;


参考答案：D

第4题：

Which SQL statement would you use to remove a view called EMP_DEPT_VU from your schema?（）

  • A、DROP emp_dept_uv;
  • B、DELETE emp_dept_uv;
  • C、REMOVE emp_dept_uv;
  • D、DROP VIEW emp_dept_uv;
  • E、DELETE VIEW emp_dept_uv;
  • F、REMOVE VIEW emp_dept_uv;

正确答案:D

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

CREATE TABLE dept(deptno NUMBER(2),dname VARCNAR2(14),1oc VARCNAR2 (13));ROLLBACK;DESCRIBE DEPTWhat 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题：

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

第8题：

Which SQL statement would you use to remove a view called EMP_DEPT_VU from your schema?()

A. DROP emp_dept_uv;

B. DELETE emp_dept_uv;

C. REMOVE emp_dept_uv;

D. DROP VIEW emp_dept_uv;

E. DELETE VIEW emp_dept_uv;

F. REMOVE VIEW emp_dept_uv;


参考答案：D

第9题：

Evaluate this SQL statement: SELECT e.emp_name, d.dept_name FROM employees e JOIN departments d USING (department_id) WHERE d.department_id NOT IN (10,40) ORSER BY dept_name; The statement fails when executed. Which change fixes the error? （）

  • A、remove the ORDER BY clause
  • B、remove the table alias prefix from the WHERE clause
  • C、remove the table alias from the SELECT clause
  • D、prefix the column in the USING clause with the table alias
  • E、prefix the column in the ORDER BY clause with the table alias
  • F、replace the condition "d.department_id NOT IN (10,40)" in the WHERE clause with "d.department_id <> 10 AND d.department_id <> 40"

正确答案:C

第10题：

下面哪一个SQL语句将删除DEPT表中的所有数据，并永久删除DEPT表的整个结构（）

  • A、DROP TABLE dept;
  • B、DELETE TABLE dept;
  • C、TRUNCATE TABLE dept;
  • D、DELETE * . * FROM dept; [END CODE]"

正确答案:A

更多相关问题
相关内容