网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
名词解释题
DML
参考答案
参考解析
解析：
暂无解析
更多 “名词解释题DML” 相关考题
考题
View the Exhibit for some of the parameter settings. You start a session and issue the following command:SQLCREATE INDEX emp_ename ON emp(ename) TABLESPACE users INVISIBLE;What is the outcome of the above command?（）A. The index is not used by the optimizer but is maintained during DML operations.B. The index is not used by the optimizer and is not maintained during DML operations.C. The index is used by the optimizer only if a hint is specified in the query statement and is maintained during DML operations.D. The index is used by the optimizer only if a hint is specified in the query statement but is not maintained during DML operations.
考题
下列有关对视图执行DML操作的表述中哪个是正确的？（）A、可以对简单视图执行DML操作。B、不能对包含WITH CHECK OPTION子句的视图执行DML操作。C、可以对包含WITH READ ONLY选项的视图执行DML操作。D、可以对包含由表达式（如COST+1）定义的列的视图执行DML操作。
考题
Why does performance degrade when many UPDATE， INSERT， or DELETE statements are issued on a tablethat has an associated Bitmap index（）A、The DML operations re-create the Bitmap index blocks.B、The Bitmap index is rebuilt automatically after a DML operation.C、The smallest amount of a bitmap that can be locked is a bitmap segment.D、Additional time is taken to remove NULL values from the Bitmap index after a DML operation.
考题
You have altered a non-unique index to be invisible to determine if queries execute within an acceptable response time without using this index. Which two are possible if table updates are performed which affect the invisible index columns?（）A、The index remains invisible.B、The index is not updated by the DML statements on the indexed table.C、The index automatically becomes visible in order to have it updated by DML on the table.D、The index becomes unusable but the table is updated by the DML.E、The index is updated by the DML on the table.
考题
单选题Which statement about the enabling of table compression in Oracle Database 11g is true？（）A
Compression can be enabled at the table， tablespace， or partition level for direct loads only.B
Compression can be enabled only at the table level for both direct loads and conventional DML.C
Compression can be enabled at the table， tablespace， or partition level for conventional DML only.D
Compression can be enabled at the table， tablespace， or partition level for both direct loads and conventional DML.
考题
单选题Why does performance degrade when many UPDATE， INSERT， or DELETE statements are issued on a tablethat has an associated Bitmap index（）A
The DML operations re-create the Bitmap index blocks.B
The Bitmap index is rebuilt automatically after a DML operation.C
The smallest amount of a bitmap that can be locked is a bitmap segment.D
Additional time is taken to remove NULL values from the Bitmap index after a DML operation.
考题
多选题You have altered a non-unique index to be invisible to determine if queries execute within an acceptable response time without using this index. Which two are possible if table updates are performed which affect the invisible index columns?（）AThe index remains invisible.BThe index is not updated by the DML statements on the indexed table.CThe index automatically becomes visible in order to have it updated by DML on the table.DThe index becomes unusable but the table is updated by the DML.EThe index is updated by the DML on the table.
热门标签
最新试卷