37.You issued the following command to drop the PRODUCTS table:

最新推荐文章于 2024-04-18 17:42:53 发布

原创最新推荐文章于 2024-04-18 17:42:53 发布 · 1.4k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#1z0-051 #oracle

1z0-051 专栏收录该内容

175 篇文章

订阅专栏

本文详细解释了SQL中DROP TABLE命令的影响，包括数据及表结构的删除、事务的自动提交、索引与视图的失效等内容。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

37.You issued the following command to drop the PRODUCTS table:

SQL> DROP TABLE products;

What is the implication of this command? (Choose all that apply.)
A:All data along with the table structure is deleted.
B:The pending transaction in the session is committed.
C:All indexes on the table will remain but they are invalidated.
D:All views and synonyms will remain but they are invalidated.
E:All data in the table are deleted but the table structure will remain.
答案:ABD
解析:题目说的是删除语句有和影响
A:正确，数据和数据结构都会删除
B:正确，之前没有提交的事务都会提交，提交事务的语句ddl(比如：create,alter,drop,rename,truncate）
，dcl(grant,revoke)，tc(commit,rollback,savepoint除外）
C:错误，表上的索引将会被删除

SQL> create table test(t varchar2(10));

Table created.

SQL> create index i_test_t on test(t);

Index created.

SQL> select index_name,table_name,table_type from user_indexes where table_name ='TEST';

INDEX_NAME                     TABLE_NAME                     TABLE_TYPE
------------------------------ ------------------------------ -----------
I_TEST_T                       TEST                           TABLE

SQL> drop table test;

Table dropped.

SQL> select index_name,table_name,table_type from user_indexes where table_name ='TEST';

no rows selected

SQL>

D:正确，所有的视图和同义词将保持但是无效
E:错误，表中所有的数据被删除，表结构也会被删除