170.Which two statements are true regarding the DELETE and TRUNCATE commands? (Choose two.)
来源:互联网 发布:加索尔生涯数据 编辑:程序博客网 时间:2024/05/18 03:07
170.Which two statements are true regarding the DELETE and TRUNCATE commands? (Choose two.)
A.DELETE can be used to remove only rows from only one table at a time.
B.DELETE can be used to remove only rows from multiple tables at a time.
C.DELETE can be used only on a table that is a parent of a referential integrity constraint.
D.DELETE can be used to remove data from specific columns as well as complete rows.
E.DELETE and TRUNCATE can be used on a table that is a parent of a referential integrity constraint having ON DELETE rule .
答案:AE
解析:delete一次一个表,排除B,C错误,是因为only的原因,delete只能整行删除,排除D
A.DELETE can be used to remove only rows from only one table at a time.
B.DELETE can be used to remove only rows from multiple tables at a time.
C.DELETE can be used only on a table that is a parent of a referential integrity constraint.
D.DELETE can be used to remove data from specific columns as well as complete rows.
E.DELETE and TRUNCATE can be used on a table that is a parent of a referential integrity constraint having ON DELETE rule .
答案:AE
解析:delete一次一个表,排除B,C错误,是因为only的原因,delete只能整行删除,排除D
0 0
- 170.Which two statements are true regarding the DELETE and TRUNCATE commands? (Choose two.)
- 35.Which two statements are true regarding constraints? (Choose two.)
- 38.Which two statements are true regarding views? (Choose two.)
- 41.Which two statements are true regarding views? (Choose two.)
- 48.Which two statements are true regarding indexes? (Choose two.)
- 133.Which two statements are true regarding subqueries? (Choose two.)
- 175.Which two statements are true regarding savepoints? (Choose two.)
- 130.Which two statements are true regarding listeners? (Choose two.)
- 98.Which two statements are true regarding the usage of the SQL*Loader utility? (Choose two.)
- 7.Which two statements are true regarding the USING and ON clauses in table joins? (Choose two.)
- 67.Which two statements are true regarding the ORDER BY clause? (Choose two.)
- 108.Which two statements are true regarding the COUNT function? (Choose two.)
- 121.Which two statements are true regarding the USING clause in table joins? (Choose two .)
- 103.Which two statements are true regarding the Oracle Data Pump export and import operations? (Choo
- 4.Which two statements are true regarding single row functions? (Choose two.)
- 80.Which two statements are true regarding working with dates? (Choose two.)
- 26.Which two statements are true regarding undo tablespaces? (Choose two.)
- 27.Which two statements are true regarding transactions in an Oracle database? (Choose two.)
- 移植minicom到嵌入式linux系统
- 网络七层协议
- java 实现FTP sftp
- ToolStripMenuItem
- 【版本发布】Jeecg-P3 1.0 发布,J2EE微服务框架(插件开发)
- 170.Which two statements are true regarding the DELETE and TRUNCATE commands? (Choose two.)
- hdu3746(kmp)
- 对沙盒的理解
- Html.Action用法
- Intent同时传递传递类对象和其他数据
- 荣耀6刷机问题
- window下php.ini文件配置详解
- 仪表盘 hostmap 新玩法让运维工作越玩越 high
- view的位置参数: