多选题Which are DML statements? （）ACOMMITBMERGECUPDATEDDELETEECREATEFDROP
多选题
Which are DML statements? （）
A
COMMIT
B
MERGE
C
UPDATE
D
DELETE
E
CREATE
F
DROP
参考解析
解析：
暂无解析
相关考题：
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?（）A.Every SQL statement in the STS is considered only once for executionB.The SQL statements in the STS are executed concurrently to produce the execution plan and execution statisticsC.The execution plan and execution statistics are computed for each SQL statement in the STSD.The effects of DDL and DML are considered to produce the execution plan and execution statistics
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?() A. User session dataB. Stack spaceC. Private SQL areaD. Location of the runtime area for DML and DDL StatementsE. Location of a part of the runtime area for SELECT statements
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
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 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 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.
多选题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 four actions are possible during an Online Data file Move operation?（）ACreating and dropping tables in the data file being movedBPerforming file shrink of the data file being movedCQuerying tables in the data file being movedDPerforming Block Media Recovery for a data block in the data file being movedEFlashing back the databaseFExecuting DML statements on objects stored in the data file being moved
多选题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
多选题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.
多选题Which two statements are true about simple views？（）AViews can be created as read only.BViews are data segments like tables.CViews can be created on the basis of more than one table.DData manipulation language （DML） operations cannot be performed on views.
多选题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.
单选题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.
多选题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 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.