多选题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 lo

题目

多选题

Which statements are true regarding system-partitioned tables？（）

Only a single partitioning key column can be specified.

All DML statements must use partition-extended syntax.

The same physical attributes must be specified for each partition.

Unique local indexes cannot be created on a system-partitioned table.

Traditional partition pruning and partitionwise joins are not supported on these tables.

更多“多选题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 lo”相关问题

第1题

Which three statements are true regarding the use of the Database Migration Assistant for Unicode(DMU)?（）A、A DBA can check specific tables with the DMUB、The database to be migrated must be opened read-only.C、The release of the database to be converted can be any release since 9.2.0.8.D、The DMU can report columns that are too long in the converted characterset.E、The DMU can report columns that are not represented in the converted characterset.

点击查看答案
第2题

Which statements are true regarding the Query Result Cache？（） A、 It can be set at the system， session， or table level.B、 It is used only across statements in the same session.C、 It can store the results from normal as well as flashback queries.D、 It can store the results of queries based on normal，temporary，and dictionary tables.

点击查看答案
第3题

Which three statements describe the functionality of the DO_KEY built-in?（）A、It accepts both a built-in and a key name as argument. B、If no key trigger is defined, the specified built-in executes. C、Its parameter must be specified in upper case, enclosed in single quotation marks. D、It performs the same task as if you pressed the function key associated with the specified argument. E、It executes the key trigger that corresponds to the built-in specified as its parameter.

点击查看答案
第4题

Which two statements are true regarding the ORDER BY clause? （）A、It is executed first in the query execution B、It must be the last clause in the SELECT statement C、It cannot be used in a SELECT statement containing a HAVING clauseD、You cannot specify a column name followed by an expression in this clause E、You can specify a combination of numeric positions and column names in this clause

点击查看答案
第5题

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.

点击查看答案
第6题

Which two statements about creating constraints are true? （）A、Constraint names must start with SYS_CB、All constraints must be defines at the column levelC、Constraints can be created after the table is createdD、Constraints can be created at the same time the table is createdE、Information about constraints is found in the VIEW_CONSTRAINTS dictionary view

点击查看答案
第7题

Which two statements about creating constraints are true?（）A、Constraint names must start with SYS_CB、All constraints must be defines at the column level.C、Constraints can be created after the table is created.D、Constraints can be created at the same time the table is created.E、Information about constraints is found in the VIEW_CONSTRAINTS dictionary view.

点击查看答案

1Z0-053

多选题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 lo

题目

更多“多选题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 lo”相关问题

第1题

第2题

第3题

第4题

第5题

第6题

第7题

相关内容