单选题Which of the following is true of an index used to support a UNIQUE constraint?（）AIt must have the UNIQUE attribute.BIt cannot be created explicitly by the user.CIt must have the UNIQUE and CLUSTER attributes.DIt must have the UNIQUE WHERE NOT NULL attribute.
单选题
Which of the following is true of an index used to support a UNIQUE constraint?（）
A
It must have the UNIQUE attribute.
B
It cannot be created explicitly by the user.
C
It must have the UNIQUE and CLUSTER attributes.
D
It must have the UNIQUE WHERE NOT NULL attribute.
参考解析
解析：
暂无解析
相关考题：
Consider the following:Which statement best describes the meaning of the value for the key_len column?() A.It shows the total size of the index rowB.It shows how many columns in the index are examinedC.It shows the number of characters indexed in the keyD.It shows how many bytes will be used from each index row
The InnoDB engine has a feature known as clustered indexes.Which three statements are true about clustered indexes as used in InnoDB?() A.A primary key must exist for creation of a clustered indexB.A clustered index allows fulltext searching within InnoDBC.The first unique index is always used as a clustered index and not a primary keyD.A clustered index provides direct access to a page containing row dataE.If no indexes exist, a hidden clustered index is generated based on row IDsF.A primary key is used as a clustered indexG.A clustered index is a grouping of indexes from different tables into a global index for faster searching
According to Paragraph 2, which of the following is true of colours?A Colors are encoded in girls' DNAB Blue used to be regarded as the color for girlsC Pink used to be a neutral color in symbolizing gendersD White is preferred by babies
Which of the following wireless standards was the FIRST standard to be ratified and is used to support legacy wireless devices?() A.802.11aB.802.11gC.802.11bD.802.11n
Which of the following is true of an index used to support a UNIQUE constraint?() A.It must have the UNIQUE attribute.B.It cannot be created explicitly by the user.C.It must have the UNIQUE and CLUSTER attributes.D.It must have the UNIQUE WHERE NOT NULL attribute.
The man page for command shows the following syntax: The man page for command shows the following syntax: command [ －a | －b ] Which of the following statements is true regarding this entry?() A. Either the -a or flag -b may be used, but not both.B. If the flag -a is used then the flag -b also must be used.C. One of the -a or -b flags must be used, but not both at the same time.D. Both the flags may be used together, but neither are mandatory.
The following configuration command was entered into a router:ip route 172.16.3.0 255.255.255.0 192.168.2.4 Which of the following statements are true regarding this configuration change?() A. The default administrative distance is used.B. The command is used to establish a static route.C. The command is used to configure the router interfaces.D. The command is used to establish a stub network.E. The subnet mask for the source address is 255.255.255.0
Which of the following is true of the squirrel bridge?__________A.It was replaced by a longer oneB.It was built from wood and metalC.it was rebuilt after years of useD.It was designed by Bill Hutch
Which of the following are true of both OSPFv2 and OSPFv3?（）A、The method of choosing an OSPF router IDB、Verification checks that must be validated before two routers can become OSPF neighborsC、Support for route tagsD、Support for multiple instances per inter face
Examine the following output： SQL SELECT index_name，status FROM dba_indexes WHERE status=’UNUSABLE’； INDEX_NAME STATUS------------------------------ ----------- EIND UNUSABLE Which two statements about the above index are true（）A、It is ignored by the query optimizer.B、It is not used while the index is being rebuilt.C、The index cannot be rebuilt， and has to be re-created.D、The index is automatically rebuilt when used the next time
An administrator needs a network that can support up to 800 hosts on the same subnet. Which of the following is the MINIMUM subnet mask that should be used？（）A、255.0.0.0B、255.255.0.0C、255.255.252.0D、255.255.255.0
The following configuration command was entered into a router:ip route 172.16.3.0 255.255.255.0 192.168.2.4 Which of the following statements are true regarding this configuration change?（）A、The default administrative distance is used.B、The command is used to establish a static route.C、The command is used to configure the router interfaces.D、The command is used to establish a stub network.E、The subnet mask for the source address is 255.255.255.0
Which of the following wireless standards was the FIRST standard to be ratified and is used to support legacy wireless devices?（）A、802.11aB、802.11gC、802.11bD、802.11n
The man page for command shows the following syntax: The man page for command shows the following syntax: command [ -a | -b ] Which of the following statements is true regarding this entry?（）A、Either the -a or flag -b may be used, but not both.B、If the flag -a is used then the flag -b also must be used.C、One of the -a or -b flags must be used, but not both at the same time.D、Both the flags may be used together, but neither are mandatory.
Which of the following architectures is used to support the agent or the application tier？（）A、SimpleB、Two-tierC、N-tierD、Client-server
Which of the following is true about job chains?（）A、They consist of one or more Scheduler programs.B、They are used to implement dependency scheduling.C、They are used to implement time-based scheduling.D、They are used to implement event-based scheduling.E、None of the above.
The InnoDB engine has a feature known as clustered indexes. Which three statements are true about clustered indexes as used in InnoDB?（）A、A primary key must exist for creation of a clustered indexB、A clustered index allows fulltext searching within InnoDBC、The first unique index is always used as a clustered index and not a primary keyD、A clustered index provides direct access to a page containing row dataE、If no indexes exist, a hidden clustered index is generated based on row IDsF、A primary key is used as a clustered indexG、A clustered index is a grouping of indexes from different tables into a global index for faster searching
Which of the following is true of an index used to support a UNIQUE constraint?（）A、It must have the UNIQUE attribute.B、It cannot be created explicitly by the user.C、It must have the UNIQUE and CLUSTER attributes.D、It must have the UNIQUE WHERE NOT NULL attribute.
单选题Which of the following is true of an index used to support a UNIQUE constraint?（）AIt must have the UNIQUE attribute.BIt cannot be created explicitly by the user.CIt must have the UNIQUE and CLUSTER attributes.DIt must have the UNIQUE WHERE NOT NULL attribute.
多选题The InnoDB engine has a feature known as clustered indexes. Which three statements are true about clustered indexes as used in InnoDB?（）AA primary key must exist for creation of a clustered indexBA clustered index allows fulltext searching within InnoDBCThe first unique index is always used as a clustered index and not a primary keyDA clustered index provides direct access to a page containing row dataEIf no indexes exist, a hidden clustered index is generated based on row IDsFA primary key is used as a clustered indexGA clustered index is a grouping of indexes from different tables into a global index for faster searching
多选题The following configuration command was entered into a router:ip route 172.16.3.0 255.255.255.0 192.168.2.4 Which of the following statements are true regarding this configuration change?（）AThe default administrative distance is used.BThe command is used to establish a static route.CThe command is used to configure the router interfaces.DThe command is used to establish a stub network.EThe subnet mask for the source address is 255.255.255.0
多选题On your Oracle Database, you issue the following commands to create indexes: SQL CREATE INDEX oe.ord_customer_ix1 ON oe.orders (customer_id, sales_rep_id) INVISIBLE; SQL CREATE BITMAP INDEX oe.ord_customer_ix2 ON oe.orders (customer_id, sales_rep_id); Which two statements are true?（）AOnly the ORD_CUSTOMER_IX1 index created.BBoth the indexes are updated when a row is inserted, updated, or deleted in the ORDERS table.CBoth the indexes are created: however, only ORD_CUSTOMERS_IX1 is used by the optimizer for queries on the ORDERS table.DThe ORD_CUSTOMER_IX1 index is not used by the optimizer even when the OPTIMIZER_USE_INVISIBLE_INDEXES parameters is set to true.EBoth the indexes are created and used by the optimizer for queries on the ORDERS table.FBoth the indexes are created: however, only ORD_CUSTOMERS_IX2 is used by the optimizer for queries on the ORDERS table.
单选题An administrator needs to update a router configuration for a router that does not support SSH.Which of the following can be used to securely update the router configuration?（）AFTPBSNMPv2CTFTPDKTTPS
单选题You have created an Oracle 10g database named SALES， which will be used by an application named SalesOrders. Users of the SalesOrders application complain that application response time is slow when they generate reports. The SalesOrders application accesses a table that contains 10 million rows. You decide to create an index on this table using the NOLOGGING option so that the index creation process is completed in the least amount of time. Which of the following is NOT true about an index created with the NOLOGGING option？（）A The index can be changed from NOLOGGING to LOGGINGB The index cannot be recovered even in the ARCHIVELOG mode.C The index can only be created if the base table is created with the NOLOGGING option.D The index can be recovered if you perform a backup after the CREATE INDEX statement.
单选题Which of the following architectures is used to support the agent or the application tier？（）ASimpleBTwo-tierCN-tierDClient-server
多选题Examine the following output： SQL SELECT index_name，status FROM dba_indexes WHERE status=’UNUSABLE’； INDEX_NAME STATUS------------------------------ ----------- EIND UNUSABLE Which two statements about the above index are true（）AIt is ignored by the query optimizer.BIt is not used while the index is being rebuilt.CThe index cannot be rebuilt， and has to be re-created.DThe index is automatically rebuilt when used the next time
多选题Examine the following output： SQL SELECT index_name，status FROM dba_indexes WHERE status=’UNUSABLE’； INDEX_NAME STATUS------------------------------ ----------- EIND UNUSABLE Which two statements about the above index are true（）AIt is ignored by the query optimizer.BIt is not used while the index is being rebuilt.CThe index cannot be rebuilt， and has to be re-created.DThe index is automatically rebuilt when used the next time
单选题In some modern large diesel engines, which of the following is used as the support for the main bearings?（）ABedplateBBlockCBaseDSump