DDL
DDL
相关考题:
Whendoesatransactioncomplete?() A.whenaDELETEstatementisexecutedB.whenaROLLBACKcommandisexecutedC.whenaPL/SQLanonymousblockisexecutedD.whenadatadefinitionlanguage(DDL)statementisexecutedE.whenaTRUNCATEstatementisexecutedafterthependingtransaction
关于DDL与事务控制,下列说法错误的是()。A、COMMIT和ROLLBACK语句只应用于DMLB、无法回滚DDL语句C、DDL语句一旦被执行就会立即具有持久状态D、如果没有在CREATETABLE命令内嵌入COMMIT命令,不会出现未完成的
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.
()表示事务中只能包含数据处理语句,事务中的数据定义语句将引起事务立即提交。A、SQL_TC_NONEB、SQL_TC_DMLC、SQL_DDL_COMMITD、SQL_DDL_IGNORE
Examine the following command:ALTER SYSTEM SET enable_ddl_logging=FALSE;Which statement is true?()A、None of the data definition language (DDL) statements are logged in the trace file.B、Only DDL commands that resulted in errors are logged in the alert log file.C、A new log.xml file that contains the DDL statements is created, and the DDL command details are removed from the alert log file.D、Only DDL commands that resulted in the creation of new database files are logged.
Examine the following command; ALTER SYSTEM SET enable_ddl_logging = TRUE; Which statement is true?()A、Only the data definition language (DDL) commands that resulted in errors are logged in the alert log file.B、All DDL commands are logged in the alert log file.C、All DDL commands are logged in a different log file that contains DDL statements and their execution dates.D、Only DDL commands that resulted in the creation of new segments are logged.E、All DDL commands are logged in XML format in the alert directory under the Automatic Diagnostic Repository (ADR) home.
What are three benefits of performing data definition language (DDL) statements against a partitioned table with the UPDATE GLOBAL INDEXES clause?()A、Global indexes are rebuilt automatically at the end of the DDL operation thereby avoiding problems with the UNUSABLE status. B、You do not have to search for invalid global indexes after the DDL command completes and rebuild them individually. C、Global indexes are maintained during the operation of the DDL command and therefore can be used by any concurrent query. D、Global indexes remain intact and available for use by data manipulation language (DML) statements even for sessions that have not enabled the skipping of unusable indexes.
单选题Examine the following command; ALTER SYSTEM SET enable_ddl_logging = TRUE; Which statement is true?()AOnly the data definition language (DDL) commands that resulted in errors are logged in the alert log file.BAll DDL commands are logged in the alert log file.CAll DDL commands are logged in a different log file that contains DDL statements and their execution dates.DOnly DDL commands that resulted in the creation of new segments are logged.EAll DDL commands are logged in XML format in the alert directory under the Automatic Diagnostic Repository (ADR) home.
单选题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.
单选题()表示事务中只能包含数据处理语句,事务中的数据定义语句将引起事务立即提交。ASQL_TC_NONEBSQL_TC_DMLCSQL_DDL_COMMITDSQL_DDL_IGNORE