多选题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 DEPT

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

相似考题

1.Evaluate this SQL statement:SELECT e.emp_name, d.dept_nameFROM employees eJOIN departments dUSING (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 clauseB. remove the table alias prefix from the WHERE clauseC. remove the table alias from the SELECT clauseD. prefix the column in the USING clause with the table aliasE. prefix the column in the ORDER BY clause with the table aliasF. replace the condition "d.department_id NOT IN (10,40)" in the WHERE clause with "d.department_id <> 10 AND d.department_id <> 40"

2.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_USERSD. GRANT select ON dept TO PUBLIC;

3.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;

4.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
解析： 暂无解析
更多“多选题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 DEPT”相关问题

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

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

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

    正确答案:A

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

    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

  • 第5题：

    You created the DEPT table by using the following command：   CREATE TABLE scott.dept   （deptno NUMBER（3），   dname VARCHAR2（15），   loc VARCHAR2（15） ）   STORAGE （INITIAL 100K NEXT 50K  MAXEXTENTS 10 PCTINCREASE 5  FREELIST GROUPS 6 FREELISTS 4）；You are required to shrink the DEPT table. While performing the shrink operation， you want to ensure that the recovered space is returned to the tablespace in which the DEPT table is stored. You do not want to shrink the indexes created on the DEPT table. What will you do to shrink the SCOTT.EMP table？（）

    • A、 Issue the ALTER TABLE SCOTT.DEPT SHRINK SPACE COMPACT； statement.
    • B、 Issue the ALTER TABLE SCOTT.DEPT SHRINK SPACE； statement.
    • C、 Issue the ALTER TABLE SCOTT.DEPT SHRINK SPACE CASCADE； statement.
    • D、 You cannot shrink the SCOTT.EMP table.

    正确答案:D

  • 第6题：

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

    Scott issues the SQL statements: CREATE TABLE dept (deptno NUMBER(2), dname VARCHAR2(14), loc VARCHAR2(13)}; GRANT SELECT ON DEPT T0 SUE; If Sue needs to select from Scott's DEPT table, which command should she use?（）

    • A、SELECT*FROMDEPT；
    • B、SELECT*FROMSCOTT.DEPT；
    • C、SELECT*FROMDBASCOTTDEPT；
    • D、SELECT*FROMALL_USERSWHEREUSER_NAME='；SCOTT'；ANDTABLENAME='；DEPT'；；

    正确答案:B

  • 第8题：

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


    正确答案： F,A
    解析： 暂无解析

  • 第9题：

    单选题
    Scott issues the SQL statements: CREATE TABLE dept (deptno NUMBER(2), dname VARCHAR2(14), loc VARCHAR2(13)}; GRANT SELECT ON DEPT T0 SUE; If Sue needs to select from Scott's DEPT table, which command should she use?（）
    A

    SELECT*FROMDEPT；

    B

    SELECT*FROMSCOTT.DEPT；

    C

    SELECT*FROMDBASCOTTDEPT；

    D

    SELECT*FROMALL_USERSWHEREUSER_NAME='；SCOTT'；ANDTABLENAME='；DEPT'；；


    正确答案： C
    解析： 暂无解析

  • 第10题：

    单选题
    You created the DEPT table by using the following command：   CREATE TABLE scott.dept   （deptno NUMBER（3），   dname VARCHAR2（15），   loc VARCHAR2（15） ）   STORAGE （INITIAL 100K NEXT 50K  MAXEXTENTS 10 PCTINCREASE 5  FREELIST GROUPS 6 FREELISTS 4）；You are required to shrink the DEPT table. While performing the shrink operation， you want to ensure that the recovered space is returned to the tablespace in which the DEPT table is stored. You do not want to shrink the indexes created on the DEPT table. What will you do to shrink the SCOTT.EMP table？（）
    A

     Issue the ALTER TABLE SCOTT.DEPT SHRINK SPACE COMPACT； statement.

    B

     Issue the ALTER TABLE SCOTT.DEPT SHRINK SPACE； statement.

    C

     Issue the ALTER TABLE SCOTT.DEPT SHRINK SPACE CASCADE； statement.

    D

     You cannot shrink the SCOTT.EMP table.


    正确答案： B
    解析： 暂无解析

  • 第11题：

    单选题
    On Monday， you dropped the DEPT table from your schema and then you re/x7fcreated the DEPT table in your schema. On Wednesday， you have a requirement to restore the DEPT table from the recycle bin. Which statement is correct？（）
    A

    You can restore the DEPT table by using the Oracle Flashback Drop feature， provided you use the RENAME TO clause.

    B

    You can restore the DEPT table by using the Oracle Flashback Drop feature and a system­generated name will be assigned to the restored table.

    C

    You cannot restore the DEPT table by using the Oracle Flashback Drop feature because a table withthe name DEPT already exists in your schema.

    D

    You cannot restore the DEPT table by using the Oracle Flashback Drop feature because the contents of the recycle bin are purged every 12 hours by default.


    正确答案： B
    解析： 暂无解析

  • 第12题：

    单选题
    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


    正确答案： E
    解析： 暂无解析

  • 第13题：

    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

  • 第14题：

    On Monday， you dropped the DEPT table from your schema and then you re-created the DEPT table in your schema. On Wednesday， you have a requirement to restore the DEPT table from the recycle bin. Which statement is correct？（）

    • A、 You cannot restore the DEPT table by using the Oracle Flashback Drop feature because a table with the name DEPT already exists in your schema.
    • B、 You can restore the DEPT table by using the Oracle Flashback Drop feature， provided you use the RENAME TO clause.
    • C、 You cannot restore the DEPT table by using the Oracle Flashback Drop feature because the contents of the recycle bin are purged every 12 hours by default.
    • D、 You can restore the DEPT table by using the Oracle Flashback Drop feature and a system-generated name will be assigned to the restored table.

    正确答案:B

  • 第15题：

    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

  • 第16题：

    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

  • 第17题：

    Evaluate the set of SQL statements: CREATE TABLE dept (deptno NUMBER(2), dname VARCNAR2(14), 1oc VARCNAR2 (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 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

  • 第18题：

    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

  • 第19题：

    单选题
    CREATE TABLE dept (deptno NUMBER(2), dname VARCNAR2(14), 1oc VARCNAR2 (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 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
    解析： 暂无解析

  • 第20题：

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

    DROP TABLE dept;

    B

    DELETE TABLE dept;

    C

    TRUNCATE TABLE dept;

    D

    DELETE * . * FROM dept; [END CODE]


    正确答案： D
    解析： 暂无解析

  • 第21题：

    单选题
    Evaluate the set of SQL statements: CREATE TABLE dept (deptno NUMBER(2), dname VARCNAR2(14), 1oc VARCNAR2 (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 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
    解析： 暂无解析

  • 第22题：

    多选题
    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
    解析： 暂无解析

  • 第23题：

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


    正确答案： D,F
    解析： 暂无解析

  • 第24题：

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


    正确答案： C,E
    解析： 暂无解析

相关内容