167.Evaluate the following DELETE statement:
来源:互联网 发布:男士休闲包 知乎 编辑:程序博客网 时间:2024/05/15 02:06
167.Evaluate the following DELETE statement:
DELETE FROM sales;
There are no other uncommitted transactions on the SALES table.
Which statement is true about the DELETE statement?
A.It would not remove the rows if the table has a primary key.
B.It removes all the rows as well as the structure of the table.
C.It removes all the rows in the table and deleted rows can be rolled back.
D.It removes all the rows in the table and deleted rows cannot be rolled back.
答案:C
解析:
A:错误,删除与主键没有关系
B:错误,只是会移除行,并不会将结构也移除,这里说的应该是drop
C:正确,删除,如果没有提交事务的话,可以通过rollback回来
D:错误
DELETE FROM sales;
There are no other uncommitted transactions on the SALES table.
Which statement is true about the DELETE statement?
A.It would not remove the rows if the table has a primary key.
B.It removes all the rows as well as the structure of the table.
C.It removes all the rows in the table and deleted rows can be rolled back.
D.It removes all the rows in the table and deleted rows cannot be rolled back.
答案:C
解析:
A:错误,删除与主键没有关系
B:错误,只是会移除行,并不会将结构也移除,这里说的应该是drop
C:正确,删除,如果没有提交事务的话,可以通过rollback回来
D:错误
0 0
- 167.Evaluate the following DELETE statement:
- 43.Evaluate the following CREATE SEQUENCE statement:
- 146.Evaluate the following SQL statement:
- 155.Evaluate the following SQL statement
- 156.Evaluate the following SQL statement:
- ocp 047-141 Evaluate the following SQL statement:SELECT product_name || 'it's not available for orde
- 19.Evaluate the following query:
- 78.Evaluate the following query:
- 30.Evaluate the following CREATE TABLE commands:
- 31.Evaluate the following SQL commands:
- 55.Evaluate the following two queries:
- 55.Evaluate the following two queries:
- 10.Examine the following statement that is used to modify the constraint on the SALES table:
- ocp 047-92 Evaluate the following expression using meta. character for regular expression:'[^Ale|ax
- 16.Evaluate the following query: SQL> SELECT promo_name||q'{'s start date was }'||promo_begin_date A
- 39.Evaluate the following command:CREATE TABLE employees(employee_id NUMBER(2) PRIMARY KEY
- Which of the following statement(s) equal(s) value 1 in C programming language?
- Examine the following statement that is used to modify the primary key constraint on the SALES tabl
- java 中关于I/O操作一些相关类的使用
- split表达式使用注意特殊符号需要转义
- php的password hashing(密码加密详解)
- cameraEdit_getCameraLimt
- iOS如何查看崩溃信息
- 167.Evaluate the following DELETE statement:
- 据称谷歌为移动应用,网站开发者推出新设计的门户网站
- 基于 lua 的热更新系统设计要点
- Android View onDraw 不执行
- 数据结构实验1-2
- 第2章 Building Apps with Contents Sharing
- pthread简单封装 线程退出
- 主成分分析和因子分析
- windows下搭建爬虫框架scrapy