167.Which three descriptions are correct about the effects of the TRUNCATE command on a table? (Choo
来源:互联网 发布:网络教学的定义 编辑:程序博客网 时间:2024/05/17 08:33
167.Which three descriptions are correct about the effects of the TRUNCATE command on a table?
(Choose three.)
A.The corresponding indexes for the table are also truncated.
B.Delete triggers on the table are fired during the execution of the TRUNCATE command.
C.The child table is truncated when the TRUNCATE command is applied on the parent table.
D.The high-water mark (HWM) is set to point to the first usable data block in the table segment.
E.No undo or very little undo data is generated during the execution of the TRUNCATE command.
答案:ADE
解析:truncate表后对应的索引也会删除掉,不会产生还原数据,不触发触发器,如果被一个外键所应用不能截断,并且会重置hwm
(Choose three.)
A.The corresponding indexes for the table are also truncated.
B.Delete triggers on the table are fired during the execution of the TRUNCATE command.
C.The child table is truncated when the TRUNCATE command is applied on the parent table.
D.The high-water mark (HWM) is set to point to the first usable data block in the table segment.
E.No undo or very little undo data is generated during the execution of the TRUNCATE command.
答案:ADE
解析:truncate表后对应的索引也会删除掉,不会产生还原数据,不触发触发器,如果被一个外键所应用不能截断,并且会重置hwm
0 0
- 167.Which three descriptions are correct about the effects of the TRUNCATE command on a table? (Choo
- The effects of the TRUNCATE command on a table
- 21.Which three statements are true about logical structures of the Oracle database? (Choose three.)
- 62.You are in the middle of a transaction updating a very important table. The machine on which a da
- Which three statements are correct about temporary tables? (Choose three.) A. Indexes and views can
- How to get the field descriptions of a table?
- How to get the field descriptions of a table
- 053-15 Which tasks are run automatically as part of the Automated Maintenance Task by default? (Choo
- 177.Which three statements are correct about temporary tables? (Choose three.)
- Question 36: Which of the following statements regarding functions' default arguments in C++ are correct?
- Which three statements are true regarding the functioning of the Autotask Background Process (ABP)?
- 12.Which is the correct description of a pinned buffer in the database buffer cache?
- 103.Which two statements are true regarding the Oracle Data Pump export and import operations? (Choo
- 19.Which two statements about the background process of the database writer are true? (Choose two.)
- 131 Which three functions are performed by the SQL Tuning Advisor? (Choose three.) A. Building the S
- INS-35354] The system on which you are attempting to install Oracle RAC is not part of a valid clust
- 134 Which three statements are true about persistent configuration? (Choose three.) A. A user cannot
- 154 Which three statements are true about persistent configuration? (Choose three.) A. A user cannot
- this指向 最简单的两种!
- Oauth认证-新浪微博开发(下)
- CNN(卷积神经网络)、RNN(循环神经网络)、DNN(深度神经网络)的内部网络结构区别
- RX操作符之结合操作(startWith、merge、mergeDelayError、zip、join、groupjoin、switchOnNext)
- OpenCV学习笔记(一)——软件配置详述
- 167.Which three descriptions are correct about the effects of the TRUNCATE command on a table? (Choo
- 块级元素与内联元素的区别
- 隐藏tabwidgt 用radiogroup来实现tab的切换
- JAVA Arrays.binarySearch
- CVS SVN Git
- TCP Socket
- LSTM代码初解析,Torch平台
- struts的logic标签库
- android 仿花椒直播中星星从底部往上移动