网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
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?（）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 one
B.It was built from wood and metal
C.it was rebuilt after years of use
D.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.
考题
多选题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?（）A
FTPB
SNMPv2C
TFTPD
KTTPS
考题
单选题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？（）A
SimpleB
Two-tierC
N-tierD
Client-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?（）A
BedplateB
BlockC
BaseD
Sump
热门标签
最新试卷