网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
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 index
- B、A clustered index allows fulltext searching within InnoDB
- C、The first unique index is always used as a clustered index and not a primary key
- D、A clustered index provides direct access to a page containing row data
- E、If no indexes exist, a hidden clustered index is generated based on row IDs
- F、A primary key is used as a clustered index
- G、A clustered index is a grouping of indexes from different tables into a global index for faster searching
参考答案
更多 “ 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” 相关考题
考题
What is true regarding InnoDB locking?()
A.InnoDB uses row and table-level locks, but row locks are not escalatesB.InnoDB locks only those rows that are updatedC.InnoDB only uses row locks, not page or table-level locksD.InnoDB row locks may be escalated to page or table-level locksE.InnoDB uses row-level or table-level locks depending on the number of rows affected
考题
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
考题
The engine has more than 300（ ）,made of a number of different materials.A.compositions
B.ingredients
C.compounds
D.components
考题
What is true regarding InnoDB locking?（）A、InnoDB uses row and table-level locks, but row locks are not escalatesB、InnoDB locks only those rows that are updatedC、InnoDB only uses row locks, not page or table-level locksD、InnoDB row locks may be escalated to page or table-level locksE、InnoDB uses row-level or table-level locks depending on the number of rows affected
考题
Which two statements are true about InnoDB auto-increment locking?（）A、The auto-increment lock can be a table-level lockB、InnoDB never uses table-level locksC、Some settings for innodb_autoinc_lock_mode can help reduce lockingD、InnoDB always protects auto-increment updates with a table-level lock
考题
A customer has a critical, performance-sensitive web application that connects to a multimode Oracle RAC database. Which feature of WebLogic can provide signification benefit?（）A、The Web Session Affinity feature of Active GridLink for RACB、WebLogic ClusteringC、The Transaction Affinity feature of Active GridLink for RACD、Coherence*Web Session Replication
考题
单选题Leaking oil seals on a diesel engine turbocharger can cause（）A
the engine to run after the fuel has been securedB
the engine to over-speedC
a fireD
all of the above
考题
单选题Following a server crash, the automatic recovery of InnoDB fails. How would you begin to manually repair the InnoDB tables?（）A
Start the server with the – innodb_recover_options option set to FORCEB
Start the server with the – innodb_force_recovery option set to a non-zero valueC
Start the server as usual, and then execute the REPAIR TABLE commandD
Start the server as usual, and then execute the CHECK TABLE command
考题
单选题Why the cooling water of the diesel engine should be treated? Because the（）A
Cooling water is alkalescenceB
cooling water is acidityC
cooling water has salinityD
cooling water has impurity
考题
单选题Before starting a diesel engine that has an engine driven lube oil pump, the engineer should （）.A
open the bypass lineB
cut in the lube oil coolerC
pressurize the lube oil systemD
top off the expansion tank
考题
多选题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
考题
单选题As soon as a diesel engine has started, which of the listed engine operating parameters should be checked FIRST?（）A
Exhaust temperaturesB
Raw water pressureC
Lube oil pressureD
Air box pressure
考题
单选题The engine has one or two group of fuel pumps, depending upon （）.A
the number of fuel valvesB
the number of cylindersC
the speed of engineD
the power of engine
考题
单选题A diesel engine is similar to a gasoline engine except that the former has no （）.A
cross-headB
cylinderC
connecting rodD
spark plug
考题
单选题You want to start monitoring statistics on the distribution of storage engines that are being used and the average sizes of tables in the various databases. Some details are as follows: The Mysql instance has 400 databases. Each database on an average consists of 25-50 tables. You use the query: SELECT TABLE_SCHEMA, 'ENGINE', COUNT (*), SUM(data_length) total_size FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE= 'BASE TABLE' GROUP BY TABLE_SCHEMA, 'ENGINE' ; Why is this query slow to execute?（）A
Collecting information requires large numbers of locks on various INFORMATION_SCHEMA tablesB
Aggregating details from various storage engine caches for the final output is time consumingC
Collecting information requires various disk-level operations and is time consumingD
Counting and summarizing all table pages in the InnoDB shared tablespace is time consuming
考题
单选题A twin screw craft being used to pick up a person who has fallen overboard from a vessel should approach if you（）.A
reverse port engine, apply right rudderB
reverse port engine,rudder amidshipsC
reverse starboard engine, apply right rudderD
revers starboard engine, rudder amidships
考题
单选题After an engine is started you should（）.A
increase engine speed to insure adequate flow of oil to all parts of the engineB
pay no attention unless there are unusual noises from the engineC
check operating pressures and temperatures，and check for leaksD
run the engine at idle until the temperature has increased
考题
单选题A customer has a critical, performance-sensitive web application that connects to a multimode Oracle RAC database. Which feature of WebLogic can provide signification benefit?（）A
The Web Session Affinity feature of Active GridLink for RACB
WebLogic ClusteringC
The Transaction Affinity feature of Active GridLink for RACD
Coherence*Web Session Replication
考题
多选题What are two methods of taking a binary backup of a Mysql Server using InnoDB storage engine?（）AFile system snapshotsBMysqldumpslowCMysqlhotcopyDMysqldump with – binary-data optionEMysql Enterprise Backup
考题
单选题Cisco IOS XR has implemented a nonstop routing feature so that when RP failover occurs， the routinginformation can be recovered locally. Which protocol does not support the NSR feature？（）A
OSPFB
LDPC
BGPD
IS-ISE
RSVP
考题
单选题In heavy marine engine the practice is to drive the engine on（）which has previously been stored in starting air reservoirs.A
electric motorB
hydraulic motorC
compressed airD
turning gear
考题
单选题You have table 'apps','userdata' on server that uses MyISAM storage engine. You want to transfer this data to server but use InnoDB engine instead. You execute the following commands: ServerB commands: Shell＞ mysqldump –u root –h server –no-data apps userdata | mysql –u root –p apps Shell＞ mysql –u root –p –h server –e 'ALTER TABLE 'apps','userdata' ENGINE=InnoDB;' Shell＞ mysqldump –u root –p –h server –no-create-info –order-by-primary apps userdata | mysql –u root –p apps What effect does the – order-by-primary argument have on the mysqldump command?（）A
It exports tables with the most indexes first to assist with import speedsB
It ensures that unique indexes have no conflicts when the data is dumpedC
It orders by primary key to assist in speeding up importing to InnoDB tablesD
It must be specified so index data is dumped correctly when –on-create-info is used
考题
单选题If the chemical analysis of a lube oil sample taken from a diesel engine indicates an increased neutralization number, the （）.A
acidity has increasedB
viscosity has decreasedC
demulsibility has improvedD
foaming is guaranteed to occur
考题
单选题About the jacket water, that of the auxiliary engines usually（） is circulated by pumps, and the main engine usually （）A
an engine-driven；as wellB
an engine-driven；has an independent pumpC
an independent；as wellD
an independent；has an engine-driven pump
热门标签
最新试卷