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 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
相关考题：
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.compositionsB.ingredientsC.compoundsD.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（）Athe engine to run after the fuel has been securedBthe engine to over-speedCa fireDall of the above
单选题Following a server crash, the automatic recovery of InnoDB fails. How would you begin to manually repair the InnoDB tables?（）AStart the server with the – innodb_recover_options option set to FORCEBStart the server with the – innodb_force_recovery option set to a non-zero valueCStart the server as usual, and then execute the REPAIR TABLE commandDStart the server as usual, and then execute the CHECK TABLE command
单选题Why the cooling water of the diesel engine should be treated? Because the（）ACooling water is alkalescenceBcooling water is acidityCcooling water has salinityDcooling water has impurity
单选题Before starting a diesel engine that has an engine driven lube oil pump, the engineer should （）.Aopen the bypass lineBcut in the lube oil coolerCpressurize the lube oil systemDtop 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?（）AExhaust temperaturesBRaw water pressureCLube oil pressureDAir box pressure
单选题The engine has one or two group of fuel pumps, depending upon （）.Athe number of fuel valvesBthe number of cylindersCthe speed of engineDthe power of engine
单选题A diesel engine is similar to a gasoline engine except that the former has no （）.Across-headBcylinderCconnecting rodDspark 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?（）ACollecting information requires large numbers of locks on various INFORMATION_SCHEMA tablesBAggregating details from various storage engine caches for the final output is time consumingCCollecting information requires various disk-level operations and is time consumingDCounting 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（）.Areverse port engine, apply right rudderBreverse port engine,rudder amidshipsCreverse starboard engine, apply right rudderDrevers starboard engine, rudder amidships
单选题After an engine is started you should（）.Aincrease engine speed to insure adequate flow of oil to all parts of the engineBpay no attention unless there are unusual noises from the engineCcheck operating pressures and temperatures，and check for leaksDrun 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?（）AThe Web Session Affinity feature of Active GridLink for RACBWebLogic ClusteringCThe Transaction Affinity feature of Active GridLink for RACDCoherence*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？（）AOSPFBLDPCBGPDIS-ISERSVP
单选题In heavy marine engine the practice is to drive the engine on（）which has previously been stored in starting air reservoirs.Aelectric motorBhydraulic motorCcompressed airDturning 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?（）AIt exports tables with the most indexes first to assist with import speedsBIt ensures that unique indexes have no conflicts when the data is dumpedCIt orders by primary key to assist in speeding up importing to InnoDB tablesDIt 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 （）.Aacidity has increasedBviscosity has decreasedCdemulsibility has improvedDfoaming is guaranteed to occur
单选题About the jacket water, that of the auxiliary engines usually（） is circulated by pumps, and the main engine usually （）Aan engine-driven；as wellBan engine-driven；has an independent pumpCan independent；as wellDan independent；has an engine-driven pump