网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
Whatarethreebenefitsofperformingdatadefinitionlanguage(DDL)statementsagainstapartitionedtablewiththeUPDATEGLOBALINDEXESclause?()
A.GlobalindexesarerebuiltautomaticallyattheendoftheDDLoperationtherebyavoidingproblemswiththeUNUSABLEstatus.
B.YoudonothavetosearchforinvalidglobalindexesaftertheDDLcommandcompletesandrebuildthemindividually.
C.GlobalindexesaremaintainedduringtheoperationoftheDDLcommandandthereforecanbeusedbyanyconcurrentquery.
D.Globalindexesremainintactandavailableforusebydatamanipulationlanguage（DML）statementsevenforsessionsthathavenotenabledtheskippingofunusableindexes.
参考答案
更多 “ Whatarethreebenefitsofperformingdatadefinitionlanguage(DDL)statementsagainstapartitionedtablewiththeUPDATEGLOBALINDEXESclause?() A.GlobalindexesarerebuiltautomaticallyattheendoftheDDLoperationtherebyavoidingproblemswiththeUNUSABLEstatus.B.YoudonothavetosearchforinvalidglobalindexesaftertheDDLcommandcompletesandrebuildthemindividually.C.GlobalindexesaremaintainedduringtheoperationoftheDDLcommandandthereforecanbeusedbyanyconcurrentquery.D.Globalindexesremainintactandavailableforusebydatamanipulationlanguage（DML）statementsevenforsessionsthathavenotenabledtheskippingofunusableindexes. ” 相关考题
考题
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.
考题
关于DDL与事务控制，下列说法错误的是（）。A、COMMIT和ROLLBACK语句只应用于DMLB、无法回滚DDL语句C、DDL语句一旦被执行就会立即具有持久状态D、如果没有在CREATETABLE命令内嵌入COMMIT命令，不会出现未完成的
考题
（）表示事务中只能包含数据处理语句，事务中的数据定义语句将引起事务立即提交。A、SQL_TC_NONEB、SQL_TC_DMLC、SQL_DDL_COMMITD、SQL_DDL_IGNORE
考题
单选题（）表示事务中只能包含数据处理语句，事务中的数据定义语句将引起事务立即提交。A
SQL_TC_NONEB
SQL_TC_DMLC
SQL_DDL_COMMITD
SQL_DDL_IGNORE
考题
多选题What are three benefits of performing data definition language （DDL） statements against a partitioned table with the UPDATE GLOBAL INDEXES clause？（）AGlobal indexes are rebuilt automatically at the end of the DDL operation thereby avoiding problems with the UNUSABLE status.BYou do not have to search for invalid global indexes after the DDL command completes and rebuild them individually.CGlobal indexes are maintained during the operation of the DDL command and therefore can be used by any concurrent query.DGlobal 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.
考题
单选题You want to create a temporary table while executing a procedure in a form. Which statement is true?（）A
You cannot create a table form within Forms. B
You must use the FORMS_DDL built-in to create the table. C
You must use the DBMS_DYNAMIC_DDL package to create the table. D
You can write the CREATE TABLE statement directly into the trigger.
考题
单选题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.
考题
单选题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.
考题
单选题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.
热门标签
最新试卷