网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
多选题
Which two statements are TRUE regarding Coherence Indexes ？ （）
A
indexes are maintained by cache entry ownes
B
an application should not suggest an index that another aplication had suggested
C
indexes cannot be sorted
D
each application using Coherence may suggest the same set of indexes when it starts
参考答案
参考解析
解析：
暂无解析
更多 “多选题Which two statements are TRUE regarding Coherence Indexes ？ （）Aindexes are maintained by cache entry ownesBan application should not suggest an index that another aplication had suggestedCindexes cannot be sortedDeach application using Coherence may suggest the same set of indexes when it starts” 相关考题
考题
The RECYCLEBIN parameter is set to ON for your database. You drop a table, PRODUCTS, from the SCOTT schema.Which two statements are true regarding the outcome of this action?()
A. All the related indexes and views are automatically droppedB. The flashback drop feature can recover only the table structureC. Only the related indexes are dropped whereas views are invalidatedD. The flashback drop feature can recover both the table structure and its data
考题
You issued the following command:An index is then created on the ADMIN_WORK_AREA temporary table. Which two statements are true regarding the TBS_T1 tablespace in the above command? ()
A. It stores only the temporary table but not its indexes.B. It stores both the temporary table as well as its indexes.C. It must be a nondefault temporary tablespace for the database.D. It can be a default or nondefault temporary tablespace for the database.E. It must be the default temporary tablespace of the user who issues the command.
考题
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
考题
The RECYCLEBIN parameter is set to ON for your database. You drop a table, PRODUCTS, from the SCOTT schema.Which two statements are true regarding the outcome of this action? ()(Choose two)
A. All the related indexes and views are automatically droppedB. The flashback drop feature can recover only the table structureC. Only the related indexes are dropped whereas views are invalidatedD. The flashback drop feature can recover both the table structure and its data
考题
Which two statements regarding symmetric key encryption are true?() (Choose two.)
A. The same key is used for encryption and decryption.B. It is commonly used to create digital certificate signatures.C. It uses two keys: one for encryption and a different key for decryption.D. An attacker can decrypt data if the attacker captures the key used for encryption.
考题
Which two statements are true regarding L2TP? ()(Choose two.)
A. Tunnels are initiated by the LACB. Tunnels are initiated by the LNSC. By default, subscriber authentication occurs on the LNSD. By default, subscriber authentication occurs on the LAC
考题
Which two statements are true regarding the role of the Routing Engine (RE)?（）A、The RE controls and monitors the chassis.B、The RE manages the Packet Forwarding Engine (PFE).C、The RE receives a copy of the forwarding table from the forwarding plane.D、The RE implements class of service (COS).
考题
Which two statements are true regarding high-availability chassis clustering？（）A、A chassis cluster consists of two devices.B、A chassis cluster consists of two or more devices.C、Devices participating in a chassis cluster can be different models.D、Devices participating in a chassis cluster must be the same models
考题
Which two statements are true regarding L2TP? （）(Choose two.)A、Tunnels are initiated by the LACB、Tunnels are initiated by the LNSC、By default, subscriber authentication occurs on the LNSD、By default, subscriber authentication occurs on the LAC
考题
Which two statements regarding asymmetric key encryption are true？（）A、The same key is used for encryption and decryption.B、It is commonly used to create digital certificate signatures.C、It uses two keys： one for encryption and a different key for decryption.D、An attacker can decrypt data if the attacker captures the key used for encryption
考题
The RECYCLEBIN parameter is set to ON for your database. You drop a table, PRODUCTS, from the SCOTT schema. Which two statements are true regarding the outcome of this action? （）(Choose two)A、All the related indexes and views are automatically droppedB、The flashback drop feature can recover only the table structureC、Only the related indexes are dropped whereas views are invalidatedD、The flashback drop feature can recover both the table structure and its data
考题
Select three true statements regarding Coherence（）A、 Coherence provides stronger data management than an Application ServerB、 Coherence provides better scale-out performance than a Application ServerC、 Coherence provides better scale-out performance than a Database ServerD、 Coherence provides better througput than a JMS messaging server Coherence provides stronger configuration management than Grid Control
考题
Which two statements regarding a SQL profile are true？（）A、 It is built by Automatic Tuning Optimizer.B、 It cannot be stored persistently in the data dictionary.C、 It can be used by the query optimizer automatically.D、 It can be created manually by using the CREATE PROFILE command.
考题
Which two statements are TRUE regarding Coherence Indexes ？ （）A、 indexes are maintained by cache entry ownesB、 an application should not suggest an index that another aplication had suggestedC、 indexes cannot be sortedD、 each application using Coherence may suggest the same set of indexes when it starts
考题
Which two statements are true regarding subqueries? （）A、A subquery can retrieve zero or more rows B、Only two subqueries can be placed atone level C、A subquery can be used only in SQL query statements D、A subquery can appear on either side of a comparison operator E、There is no limit on the number of subquery levels in the WHERE clause of a SELECT statement
考题
Which statements are correct regarding indexes？ （）A、 When a table is dropped， the corresponding indexes are automatically dropped.B、 For each DML operation performed， the corresponding indexes are automatically updated.C、 Indexes should be created on columns that are frequently referenced as part of an expression.D、 A non-deferrable PRIMARY KEY or UNIQUE KEY constraint in a table automatically creates a uniqueindex.
考题
The RECYCLEBIN parameter is set to ON for your database. You drop a table，PRODUCTS，from the SCOTT schema. Which two statements are true regarding the outcome of this action？（）A、 All the related indexes and views are automatically droppedB、 The flashback drop feature can recover only the table structureC、 Only the related indexes are dropped whereas views are invalidatedD、 The flashback drop feature can recover both the table structure and its data
考题
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.
考题
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 statements are true regarding the USING and ON clauses in table joins?（）ABoth USING and ON clauses can be used for equijoins and nonequijoinsBAmaximum of one pair of columns can be joined between two tables using the ON clauseCThe ON clause can be used to join tables on columns that have different names but compatible data typesDThe WHERE clause can be used to apply additional conditions in SELECT statements containing the ON or the USING clause
考题
多选题The RECYCLEBIN parameter is set to ON for your database. You drop a table，PRODUCTS，from the SCOTT schema. Which two statements are true regarding the outcome of this action？（）AAll the related indexes and views are automatically droppedBThe flashback drop feature can recover only the table structureCOnly the related indexes are dropped whereas views are invalidatedDThe flashback drop feature can recover both the table structure and its data
考题
多选题Regarding an IPsec security association （SA）， which two statements are true？（）AIKE SA is bidirectional.BIPsec SA is bidirectional.CIKE SA is established during phase 2 negotiations.DIPsec SA is established during phase 2 negotiations.
考题
多选题Which two statements are true when when a Coherence cluster member is lost ？ （）ARemaining members recover by repartitioning the data across the remainig cluster members in parallel with normal request processingBSome latencies may be experienced due to higher priority of recoveryCIn flight operations may be lostDA system administrator must manually assist recovery of the lost data
考题
多选题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 two statements are TRUE regarding Coherence Indexes ？ （）Aindexes are maintained by cache entry ownesBan application should not suggest an index that another aplication had suggestedCindexes cannot be sortedDeach application using Coherence may suggest the same set of indexes when it starts
考题
多选题Which two statements are true regarding L2TP? （）(Choose two.)ATunnels are initiated by the LACBTunnels are initiated by the LNSCBy default, subscriber authentication occurs on the LNSDBy default, subscriber authentication occurs on the LAC
考题
多选题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
考题
多选题Which two statements are true regarding high-availability chassis clustering？（）AA chassis cluster consists of two devices.BA chassis cluster consists of two or more devices.CDevices participating in a chassis cluster can be different models.DDevices participating in a chassis cluster must be the same models
热门标签
最新试卷
