网友您好, 请在下方输入框内输入要搜索的题目:
题目内容
(请给出正确答案)
多选题
Which three are properties of the MyISAM storage engine?()
A
Transaction support
B
FULLTEXT indexing for text matching
C
Table and page level locking support
D
Foreign key support
E
Geospatial indexing
F
HASH index support
G
Table level locking only
参考答案
参考解析
解析:
暂无解析
更多 “多选题Which three are properties of the MyISAM storage engine?()ATransaction supportBFULLTEXT indexing for text matchingCTable and page level locking supportDForeign key supportEGeospatial indexingFHASH index supportGTable level locking only” 相关考题
考题
Which constraint can be defined only at the column level? ()
A. UNIQUEB. NOT NULLC. CHECKD. PRIMARY KEYE. FOREIGN KEY
考题
Which three are properties of the MyISAM storage engine?()
A.Transaction supportB.FULLTEXT indexing for text matchingC.Table and page level locking supportD.Foreign key supportE.Geospatial indexingF.HASH index supportG.Table level locking only
考题
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
考题
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
考题
The most commonly used locking level in implementing concurrency control is at which of the following levels?A.databaseB.tableC.recordD.field
考题
jayne has asked her domino server administrator to enable doc locking on the server. which one of the following must she do to enable it for her application?()A、 enable the “allow doc locking “ db property B、 create a view column for the locked doc view icon C、 add a profile doc to the db to manage the locked doc D、 enable doc locking at the view level for each view in the db
考题
Which two are valid locking levels that are used by transactions in an Oracle database?()A、row levelB、block levelC、object levelD、schema levelE、database level
考题
There are three IS-IS routers on a Gigabit Ethernet segment: Router A, Router B, and Router C. Each router is configured in the same area and each routers Gigabit Ethernet interface is configured for Level 1-only. Router A is the Designated Intermediate System (DIS). Each routers IP address on that segment is: Router A: 10.1.1.1/24 Router B: 10.1.1.2/24 Router C: 10.2.2.1/26 Which statement is true about all the adjacencies that exist on that LAN?()A、No routers are adjacent with each other.B、Only Router A and Router B are adjacent at Level 1.C、Only Router A and Router B are adjacent at Level 2.D、All three routers are adjacent with each other at Level 1.
考题
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 type of backup contains only the blocks that have changed since the last level 0 incremental backup?()A、a cumulative level 1 backupB、a differential level 1 backupC、a full backupD、a whole backup
考题
Which constraint can be defines only at the column level?()A、UNIQUEB、NOT NULLC、CHECKD、PRIMARY KEYE、FOREIGN KEY
考题
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
考题
Which three are properties of the MyISAM storage engine?()A、Transaction supportB、FULLTEXT indexing for text matchingC、Table and page level locking supportD、Foreign key supportE、Geospatial indexingF、HASH index supportG、Table level locking only
考题
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 two statements are true about InnoDB auto-increment locking?()AThe auto-increment lock can be a table-level lockBInnoDB never uses table-level locksCSome settings for innodb_autoinc_lock_mode can help reduce lockingDInnoDB always protects auto-increment updates with a table-level lock
考题
多选题Which three benefits are realized by implementing Wireless LAN Solution Engine (WLSE)?()Aimproved WLAN securityBsimplified AP deploymentCdynamic RF managementDon-demand location of rogue APsEsystem-wide control of status and alarm monitoringFautomatic channel and power level adjustment
考题
多选题All secure domain routers (SDRs) have shared attribute and resources. Which three resources are sharedall SDRs? ()Aprivilege-level configurationBfabric cardsCSNMP trapsDadmin- level configurationEexec- level configuration
考题
多选题All secure domain routers (SDRs) have shared attributes and resources. Which three resources areshared among all SDRs? ()ASNMP trapsBfabric cardsCexec-level configurationDprivilege-level configurationEadmin-level configuration
考题
单选题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
考题
单选题jayne has asked her domino server administrator to enable doc locking on the server. which one of the following must she do to enable it for her application?()A
enable the “allow doc locking “ db property B
create a view column for the locked doc view icon C
add a profile doc to the db to manage the locked doc D
enable doc locking at the view level for each view in the db
考题
多选题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
考题
多选题Which are the three levels at which the Segment Advisor generates advice?()Ablock levelBobject levelCschema levelDsegment levelEtablespace level
考题
多选题Which three statements correctly describe the functions and use of constraints? ()AConstraints provide data independence.BConstraints make complex queries easy.CConstraints enforce rules at the view level.DConstraints enforce rules at the table level.EConstraints prevent the deletion of a table if there are dependencies.FConstraints prevent the deletion of an index if there are dependencies.
考题
单选题Diesel engine automated control systems may utilize sensing devices of dual function, with sensing ranges providing both alarm and engine shut down capability.Which of the key points would only require an alarm sensor?()A
Lube oil pressure and temperatureB
jacket water pressure and temperatureC
Engine over-speedD
Lube oil sump level
考题
多选题Which two are valid locking levels that are used by transactions in an Oracle database?()Arow levelBblock levelCobject levelDschema levelEdatabase level
考题
多选题Which three methods will show the storage engine for the Country table?()AABBCCDDEE
热门标签
最新试卷