Which two are true regarding external tables？ （）A、External tables can be updated. B、External tables are read-only tables. C、Indexes can be created on external tables. D、Indexes cannot be created on external tables.
Which two are true regarding external tables？ （）
- A、External tables can be updated.
- B、External tables are read-only tables.
- C、Indexes can be created on external tables.
- D、Indexes cannot be created on external tables.
相关考题：
On which two database objects can the VERSIONS clause of the Flashback Versions Query be used?() A. fixed tablesB. heap tablesC. external tablesD. temporary tablesE. Index-Organized Tables (IOTs)
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.
For which two database objects can the VERSIONS clause of the Flashback Versions Query be used?()(Choose two.) A. viewsB. fixed tablesC. heap tablesD. external tablesE. temporary tablesF. index-organized tables (IOT)
In one of your online transaction processing （OLTP） applications， most users frequently modify the values， including the key values， of the application tables. Some users generate application reports by using multiple application tables. What is the best table structure that you can use to gain optimal performance？（）A、heap tableB、object tableC、external tableD、clustered tableE、global temporary tableF、indexorganized table （IOT）
Which two statements regarding external authentication servers for firewall userauthentication are true？（）A、Up to three external authentication server types can be used simultaneously.B、Only one external authentication server type can be used simultaneously.C、If the local password database is not configured in the authentication order， and the configured authentication server is unreachable， authentication is not performed.D、If the local password database is not configured in the authentication order， and the configured authentication server rejects the authentication request， authentication is not performed
Which two statements regarding external authentication servers for firewall user authentication are true?（） (Choose two.)A、Up to three external authentication server types can be used simultaneously.B、Only one external authentication server type can be used simultaneously.C、If the local password database is not configured in the authentication order, and the configured authentication server bypassed.D、If the local password database is not configured in the authentication order, and the configured authentication server authentication is rejected.
On which two database objects can the VERSIONS clause of the Flashback Versions Query be used?（）A、fixed tablesB、heap tablesC、external tablesD、temporary tablesE、Index-Organized Tables (IOTs)
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.
Which two statements are correct regarding the Flashback Versions Query feature？（）A、 You can use this feature to identify the committed versions of the rows， but not the uncommitted versions.B、 You can use this feature to identify the versions of V$ views.C、 You can use this feature to identify the inserts， deletes， and updates performed on a particular row but not the data definition language （DDL） operations performed on the table.D、 You can use this feature for a table only if row movement is enabled for the table.E、 You can use this feature to identify the versions of external and fixed tables.
In one of your online transaction processing （OLTP） applications， most users frequently modify the values， including the key values， of the application tables. Some users generate application reports by using multiple application tables. What is the best table structure that you can use to gain optimal performance？（）A、heap tableB、object tableC、external tableD、clustered tableE、global temporary tableF、index-organized table （IOT）
What two statements are true regarding the recommendations received from the SQL Access Advisor?（）(Choose two.)A、It cannot generate recommendations that support multiple workload queries.B、It can recommend partitioning on tables provided that the workloads have some predicates and joins on the columns of the NUMBER or DATE type.C、It can recommend partitioning only on tables that have at least 10,000 rows.D、It can recommend only B-tree indexes and not bitmap or function-based indexes
Which statements are correct about temporary tables（）A、Indexes and views can be created on temporary tables.B、Both the data and the structure of temporary tables can be exported.C、Temporary tables are always created in a user’s temporary tablespace.D、The data inserted into a temporary table in a session is available to other sessions.E、Data manipulation language （DML） locks are never acquired on the data of temporary tables
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.
For which two database objects can the VERSIONS clause of the Flashback Versions Query be used?（）(Choose two.)A、viewsB、fixed tablesC、heap tablesD、external tablesE、temporary tablesF、index-organized tables (IOT)
Which three statements are correct about temporary tables？（）A、Indexes and views can be created on temporary tables.B、Both the data and the structure of temporary tables can be exported.C、Temporary tables are always created in a user’s temporary tablespace.D、The data inserted into a temporary table in a session is available to other sessions.E、Data manipulation language （DML） locks are never acquired on the data of temporary tables.
What two statements are true regarding the recommendations received from the SQL Access Advisor？（）A、 It cannot generate recommendations that support multiple workload queries.B、 It can recommend partitioning on tables provided that the workloads have some predicates and joins on the columns of the NUMBER or DATE type.C、 It can recommend partitioning only on tables that have at least 10，000 rows.D、 It can recommend only B-tree indexes and not bitmap or function-based indexes.
A bitmap join index is defined as（）.A、An index used to join two bitmap indexes on a table.B、A bitmap index created for the join of two or more tables.C、A bitmap index created on the join of two or more indexes.D、A bitmap index created on the join of two or more indexed-organized tables.
多选题What two statements are true regarding the recommendations received from the SQL Access Advisor?（）(Choose two.)AIt cannot generate recommendations that support multiple workload queries.BIt can recommend partitioning on tables provided that the workloads have some predicates and joins on the columns of the NUMBER or DATE type.CIt can recommend partitioning only on tables that have at least 10,000 rows.DIt can recommend only B-tree indexes and not bitmap or function-based indexes
多选题What two statements are true regarding the recommendations received from the SQL Access Advisor？（）AIt cannot generate recommendations that support multiple workload queries.BIt can recommend partitioning on tables provided that the workloads have some predicates and joins on the columns of the NUMBER or DATE type.CIt can recommend partitioning only on tables that have at least 10，000 rows.DIt can recommend only B-tree indexes and not bitmap or function-based indexes.
多选题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.
单选题In one of your online transaction processing （OLTP） applications， most users frequently modify the values， including the key values， of the application tables. Some users generate application reports by using multiple application tables. What is the best table structure that you can use to gain optimal performance？（）A Heap tableB Object tableC External tableD Clustered tableE Global temporary tableF Index-organized table （IOT）
多选题Which two statements regarding external authentication servers for firewall userauthentication are true？（）AUp to three external authentication server types can be used simultaneously.BOnly one external authentication server type can be used simultaneously.CIf the local password database is not configured in the authentication order， and the configured authentication server is unreachable， authentication is not performed.DIf the local password database is not configured in the authentication order， and the configured authentication server rejects the authentication request， authentication is not performed
多选题Which two statements regarding external authentication servers for firewall user authentication are true?（） (Choose two.)AUp to three external authentication server types can be used simultaneously.BOnly one external authentication server type can be used simultaneously.CIf the local password database is not configured in the authentication order, and the configured authentication server bypassed.DIf the local password database is not configured in the authentication order, and the configured authentication server authentication is rejected.
单选题A bitmap join index is defined as（）.AAn index used to join two bitmap indexes on a table.BA bitmap index created for the join of two or more tables.CA bitmap index created on the join of two or more indexes.DA bitmap index created on the join of two or more indexed-organized tables.
多选题Which two statements are correct regarding the Flashback Versions Query feature？（）AYou can use this feature to identify the committed versions of the rows， but not the uncommitted versions.BYou can use this feature to identify the versions of V$ views.CYou can use this feature to identify the inserts， deletes， and updates performed on a particular row but not the data definition language （DDL） operations performed on the table.DYou can use this feature for a table only if row movement is enabled for the table.EYou can use this feature to identify the versions of external and fixed tables.
多选题Which two are true regarding external tables？ （）AExternal tables can be updated.BExternal tables are read-only tables.CIndexes can be created on external tables.DIndexes cannot be created on external 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 local indexes cannot be created on a system-partitioned table.ETraditional partition pruning and partitionwise joins are not supported on these tables.