网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
多选题
Which are DML statements? （）
A
COMMIT
B
MERGE
C
UPDATE
D
DELETE
E
CREATE
F
DROP...
参考答案
参考解析
解析：
暂无解析
更多 “多选题Which are DML statements? （）ACOMMITBMERGECUPDATEDDELETEECREATEFDROP...” 相关考题
考题
Which two statements regarding the Flashback Table feature are correct?()
A. Flashback Table can be performed on system tables.B. Flashback Table operation does not shrink the segments.C. Flashback Table uses log mining to extract SQL_REDO and SQL_UNDO statements.D. Flashback Table operation acquires exclusive data manipulation language (DML) locks.
考题
Which statements are true regarding table compression? ()(Choose all that apply.)
A. It saves disk space and reduces memory usage.B. It saves disk space but has no effect on memory usage.C. It incurs extra CPU overhead during DML as well as direct loading operations.D. It incurs extra CPU overhead during DML but not direct loading operations.E. It requires uncompress operation during I/O.
考题
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 of the following statements is true regarding the VERSIONS BETWEEN clause？（） A、 The VERSIONS BETWEEN clause may be used in DML statements.B、 The VERSIONS BETWEEN clause may be used in DDL statements.C、 The VERSIONS BETWEEN clause may not be used to query past DDL changes to tables.D、 The VERSIONS BETWEEN clause may not be used to query past DML statements to tables.
考题
Which of the following statements is used to revoke all DML privileges on table EMPLOYEE from user TOM?（）A、REVOKE ALL PRIVILEGES FROM USER tomB、REVOKE ALL ON EMPLOYEE FROM USER tomC、REVOKE EXECUTE ON EMPLOYEE FROM USER tomD、REVOKE PRIVILEGES ON EMPLOYEE FROM USER tom
考题
Over the course of a day，a department performed multiple DML statements （inserts， updates， deletes） on multiple rows of data in multiple tables. The manager would like a report showing the time， table name，and DML type for all changes that were made. Which Flashback technology would be the best choice to produce the list？（）A、 Flashback DropB、 Flashback QueryC、 Flashback Transaction QueryD、 Flashback Versions QueryE、 Flashback Table
考题
Which statements are true regarding system-partitioned tables？（） A、 Only a single partitioning key column can be specified.B、 All DML statements must use partition-extended syntax.C、 The same physical attributes must be specified for each partition.D、 Unique local indexes cannot be created on a system-partitioned table.E、 Traditional partition pruning and partitionwise joins are not supported on these tables.
考题
Which two statements are true about simple views？（）A、Views can be created as read only.B、Views are data segments like tables.C、Views can be created on the basis of more than one table.D、Data manipulation language （DML） operations cannot be performed on views.
考题
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.
考题
多选题You configure your database Instance to support shared server connections.Which two memory areas that are part of PGA are stored in SGA instead, for shared server connection?（）AUser session dataBStack spaceCPrivate SQL areaDLocation of the runtime area for DML and DDL StatementsELocation of a part of the runtime area for SELECT statements
考题
多选题Which statements are true regarding table compression? （）(Choose all that apply.)AIt saves disk space and reduces memory usage.BIt saves disk space but has no effect on memory usage.CIt incurs extra CPU overhead during DML as well as direct loading operations.DIt incurs extra CPU overhead during DML but not direct loading operations.EIt requires uncompress operation during I/O.
考题
多选题You want to analyze a SQL Tuning Set (STS) using SQL Performance Analyzer in a test database. Which two statements are true regarding the activities performed during the test execution of SQLs in a SQL Tuning Set?（）AEvery SQL statement in the STS is considered only once for executionBThe SQL statements in the STS are executed concurrently to produce the execution plan and execution statisticsCThe execution plan and execution statistics are computed for each SQL statement in the STSDThe effects of DDL and DML are considered to produce the execution plan and execution statistics
考题
多选题Which statements are correct about temporary tables（）AIndexes and views can be created on temporary tables.BBoth the data and the structure of temporary tables can be exported.CTemporary tables are always created in a user’s temporary tablespace.DThe data inserted into a temporary table in a session is available to other sessions.EData manipulation language （DML） locks are never acquired on the data of temporary tables
考题
多选题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.
考题
多选题Which three statements are correct about temporary tables？（）AIndexes and views can be created on temporary tables.BBoth the data and the structure of temporary tables can be exported.CTemporary tables are always created in a user’s temporary tablespace.DThe data inserted into a temporary table in a session is available to other sessions.EData manipulation language （DML） locks are never acquired on the data of temporary tables.
考题
多选题Which two statements regarding the Flashback Table feature are correct?（）AFlashback Table can be performed on system tables.BFlashback Table operation does not shrink the segments.CFlashback Table uses log mining to extract SQL_REDO and SQL_UNDO statements.DFlashback Table operation acquires exclusive data manipulation language (DML) locks.
考题
多选题You execute the following PL/SQL:Which two statements are true?（）AFine-Grained Auditing (FGA) is enabled for the PRICE column in the PRODUCTS table for SELECT statements only when a row with PRICE 10000 is accessed.BFGA is enabled for the PRODUCTS.PRICE column and an audit record is written whenever a row with PRICE 10000 is accessed.CFGA is enabled for all DML operations by JIM on the PRODUCTS.PRICE column.DFGA is enabled for the PRICE column of the PRODUCTS table and the SQL statements is captured in the FGA audit trial.
考题
单选题Which of the following statements is true regarding the VERSIONS BETWEEN clause？（）A
The VERSIONS BETWEEN clause may be used in DML statements.B
The VERSIONS BETWEEN clause may be used in DDL statements.C
The VERSIONS BETWEEN clause may not be used to query past DDL changes to tables.D
The VERSIONS BETWEEN clause may not be used to query past DML statements to tables.
考题
单选题Over the course of a day，a department performed multiple DML statements （inserts， updates， deletes） on multiple rows of data in multiple tables. The manager would like a report showing the time， table name，and DML type for all changes that were made. Which Flashback technology would be the best choice to produce the list？（）A
Flashback DropB
Flashback QueryC
Flashback Transaction QueryD
Flashback Versions QueryE
Flashback Table
考题
多选题Which statements are true regarding table compression？（）AIt saves disk space and reduces memory usage.BIt saves disk space but has no effect on memory usage.CIt incurs extra CPU overhead during DML as well as direct loading operations.DIt incurs extra CPU overhead during DML but not direct loading operations.EIt requires uncompress operation during I/O.
考题
多选题Which two statements are true regarding views?（）AA subquery that defines a view cannot include the GROUP BY clauseBA view that is created with the subquery having the DISTINCT keyword can be updatedCA view that is created with the subquery having the pseudo column ROWNUM keyword cannot be updatedDA data manipulation language (DML) operation can be performed on a view that is created with the subquery having all the NOT NULL columns of a table
考题
多选题Which statements are true regarding system-partitioned tables?（）AOnly a single partitioning key column can be specified.BAll DML statements must use partition-extended syntax.CThe same physical attributes must be specified for each partition.DUnique local indexes cannot be created on a system-partitioned table.ETraditional partition pruning and partitionwise joins are not supported on these tables.
考题
多选题Which statements are correct regarding indexes？ （）AWhen a table is dropped， the corresponding indexes are automatically dropped.BFor each DML operation performed， the corresponding indexes are automatically updated.CIndexes should be created on columns that are frequently referenced as part of an expression.DA non-deferrable PRIMARY KEY or UNIQUE KEY constraint in a table automatically creates a uniqueindex.
热门标签
最新试卷