多选题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 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

相似考题

1.Which constraint can be defined only at the column level? ()A. UNIQUEB. NOT NULLC. CHECKD. PRIMARY KEYE. FOREIGN KEY

2.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

3.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

4.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

参考答案和解析
正确答案： F,D
解析： 暂无解析
更多“多选题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”相关问题

  • 第1题：

    Which two statements are true about InnoDB auto－increment locking?()

    A.The auto-increment lock can be a table-level lock

    B.InnoDB never uses table-level locks

    C.Some settings for innodb_autoinc_lock_mode can help reduce locking

    D.InnoDB always protects auto-increment updates with a table-level lock


    参考答案：A, C

  • 第2题：

    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

    正确答案:A

  • 第3题：

    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.

    正确答案:B

  • 第4题：

    Which type of backup contains only the blocks that have changed since the last level 0 incremental backup?（）

    • A、a cumulative level 1 backup
    • B、a differential level 1 backup
    • C、a full backup
    • D、a whole backup

    正确答案:A

  • 第5题：

    Which two statements are true about InnoDB auto-increment locking?（）

    • A、The auto-increment lock can be a table-level lock
    • B、InnoDB never uses table-level locks
    • C、Some settings for innodb_autoinc_lock_mode can help reduce locking
    • D、InnoDB always protects auto-increment updates with a table-level lock

    正确答案:A,C

  • 第6题：

    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

    正确答案:D,E,F

  • 第7题：

    多选题
    Which three benefits are realized by implementing Wireless LAN Solution Engine （WLSE）？（）
    A

    improved WLAN security

    B

    simplified AP deployment

    C

    dynamic RF management

    D

    on-demand location of rogue APs

    E

    system-wide control of status and alarm monitoring

    F

    automatic channel and power level adjustment


    正确答案： C,E
    解析： 暂无解析

  • 第8题：

    多选题
    All secure domain routers （SDRs） have shared attributes and resources. Which three resources areshared among all SDRs？ （）
    A

    SNMP traps

    B

    fabric cards

    C

    exec-level configuration

    D

    privilege-level configuration

    E

    admin-level configuration


    正确答案： E,C
    解析： 暂无解析

  • 第9题：

    单选题
    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


    正确答案： C
    解析： 暂无解析

  • 第10题：

    多选题
    Which are the three levels at which the Segment Advisor generates advice?（）
    A

    block level

    B

    object level

    C

    schema level

    D

    segment level

    E

    tablespace level


    正确答案： E,D
    解析： 暂无解析

  • 第11题：

    多选题
    Which three statements correctly describe the functions and use of constraints? （）
    A

    Constraints provide data independence.

    B

    Constraints make complex queries easy.

    C

    Constraints enforce rules at the view level.

    D

    Constraints enforce rules at the table level.

    E

    Constraints prevent the deletion of a table if there are dependencies.

    F

    Constraints prevent the deletion of an index if there are dependencies.


    正确答案： C,F
    解析： 暂无解析

  • 第12题：

    多选题
    Which two are valid locking levels that are used by transactions in an Oracle database？（）
    A

    row level

    B

    block level

    C

    object level

    D

    schema level

    E

    database level


    正确答案： D,E
    解析： 暂无解析

  • 第13题：

    The most commonly used locking level in implementing concurrency control is at which of the following levels?

    A．database

    B．table

    C．record

    D．field


    正确答案：C

  • 第14题：

    Which two are valid locking levels that are used by transactions in an Oracle database？（）

    • A、row level
    • B、block level
    • C、object level
    • D、schema level
    • E、database level

    正确答案:A,C

  • 第15题：

    What is true regarding InnoDB locking?（）

    • A、InnoDB uses row and table-level locks, but row locks are not escalates
    • B、InnoDB locks only those rows that are updated
    • C、InnoDB only uses row locks, not page or table-level locks
    • D、InnoDB row locks may be escalated to page or table-level locks
    • E、InnoDB uses row-level or table-level locks depending on the number of rows affected

    正确答案:B

  • 第16题：

    Which constraint can be defines only at the column level?（）

    • A、UNIQUE
    • B、NOT NULL
    • C、CHECK
    • D、PRIMARY KEY
    • E、FOREIGN KEY

    正确答案:B

  • 第17题：

    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

    正确答案:B,E,G

  • 第18题：

    多选题
    Which two statements are true about InnoDB auto-increment locking?（）
    A

    The auto-increment lock can be a table-level lock

    B

    InnoDB never uses table-level locks

    C

    Some settings for innodb_autoinc_lock_mode can help reduce locking

    D

    InnoDB always protects auto-increment updates with a table-level lock


    正确答案： C,D
    解析： 暂无解析

  • 第19题：

    多选题
    All secure domain routers （SDRs） have shared attribute and resources. Which three resources are sharedall SDRs？ （）
    A

    privilege-level configuration

    B

    fabric cards

    C

    SNMP traps

    D

    admin- level configuration

    E

    exec- level configuration


    正确答案： B,A
    解析： 暂无解析

  • 第20题：

    单选题
    What is true regarding InnoDB locking?（）
    A

    InnoDB uses row and table-level locks, but row locks are not escalates

    B

    InnoDB locks only those rows that are updated

    C

    InnoDB only uses row locks, not page or table-level locks

    D

    InnoDB row locks may be escalated to page or table-level locks

    E

    InnoDB uses row-level or table-level locks depending on the number of rows affected


    正确答案： B
    解析： 暂无解析

  • 第21题：

    多选题
    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


    正确答案： D,E,F
    解析： 暂无解析

  • 第22题：

    多选题
    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


    正确答案： D,C
    解析： 暂无解析

  • 第23题：

    单选题
    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 temperature

    B

    jacket water pressure and temperature

    C

    Engine over-speed

    D

    Lube oil sump level


    正确答案： C
    解析： 暂无解析

  • 第24题：

    多选题
    Which three methods will show the storage engine for the Country table?（）
    A

    A

    B

    B

    C

    C

    D

    D

    E

    E


    正确答案： E,D
    解析： 暂无解析

相关内容