多选题Which statements are correct regarding indexes？ （）AWhen a table is dropped， the corresponding indexes are automatically dropped.BFor each DML operation performed， the corresponding indexes are automatically updated.CIndexes should be created on columns that are frequently referenced as part of an expression.DA non-deferrable PRIMARY KEY or UNIQUE KEY constraint in a table automatically creates a uniqueindex.
多选题
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
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.
Which two statements regarding JUNOS architecture are correct?() A.The Routing Engine handles all exception traffic.B.The Routing Engine synchronizes the route table with the PFEC.The Routing Engine is hot-pluggable.D.The Routing Engine controls the PFE
Which of the following statements is TRUE regarding crane operations ________．A.Radio communications allow the crane operator to disregard the use of hand signalsB.The crane operators and signalman must be familiar with the correct hand signalsC.The forward cranes can be operated from the bridgeD.The aft cranes can be operated from the aft steering station
Which of the following statements is correct regarding a hybridcrypto system？（）A、 uses symmetric crypto for keys distributionB、 uses symmetric crypto for proof of originC、 uses symmetric crypto for fast encrypted/decryptionD、 uses asymmetric crypto for message confidentialityE、 uses symmetric crypto to transmit the asymmetric keys that is thenused to encrypt a session
Which two of these statements regarding RSTP are correct? （）A、RSTP cannot operate with PVST+.B、RSTP defines new port roles.C、RSTP defines no new port states.D、RSTP is a proprietary implementation of IEEE 802.1D STP.E、RSTP is compatible with the original IEEE 802.1D STP.
Which two statements regarding SNMP monitoring of a UCS system are correct?（）A、SNMP v3 is supportedB、includes same MIBs as the Cisco Nexus7000C、does not provides MIBs downstream of the fabric interconnectD、includes same MIBs as the Cisco Nexus2000
Which two statements regarding JUNOS architecture are correct？（）A、The Routing Engine handles all exception traffic.B、The Routing Engine synchronizes the route table with the PFEC、The Routing Engine is hot-pluggable.D、The Routing Engine controls the PFE
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 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
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.
多选题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
多选题Which statements are correct regarding indexes？ （）AWhen a table is dropped， the corresponding indexes are automatically dropped.BFor each DML operation performed， the corresponding indexes are automatically updated.CIndexes should be created on columns that are frequently referenced as part of an expression.DA non-deferrable PRIMARY KEY or UNIQUE KEY constraint in a table automatically creates a uniqueindex.
多选题Which two statements are correct regarding MPLS LSP establishment methods?（） (Choose two.)ALDP uses Down Stream On Demand.BRSVP uses Down Stream On Demand.CLDP uses Down Stream Unsolicited.DRSVP uses Down Stream Unsolicited.
多选题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 regarding the Flashback Table feature are correct?（）AFlashback Table can be performed on system tables.BFlashback Table operation does not shrink the segments.CFlashback Table uses log mining to extract SQL_REDO and SQL_UNDO statements.DFlashback Table operation acquires exclusive data manipulation language (DML) locks.
多选题Which two statements regarding traceroute on JUNOS devices are correct?（）ATraceroute transmits ICMP echo-request packets.BTraceroute transmits UDP packets.CTraceroute receives ICMP echo-reply packets.DTraceroute receives ICMP port-unreachable packets.
单选题Which of the following statements is correct regarding an oil with a high viscosity index?（）AA large change of viscosity occurs with a minor change in temperatureBNo change in viscosity occurs with any change in temperatureCVery little change in viscosity occurs with a significant change in temperatureDThe viscosity of the oil increases with an increase in temperature