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

题目
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.He had a cottage which consists _____ three rooms, a bathroom and kitchen.A:ofB:withC:inD:by

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 methods will show the storage engine for the Country table?()A.AB.BC.CD.DE.E

更多“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 ind”相关问题

  • 第1题：

    Which three statements are characteristic of the MEMORY storage engine?()

    A.It can support transactions

    B.Table contents are not saved if the server is restarted

    C.It cannot contain text or BLOB columns

    D.It can support foreign keys

    E.Each table is represented on disk as an.frm file

    F.Each table has a corresponding.MYI and .MYD file


    参考答案：B, C, E

  • 第2题：

    Which three are distinctions between asymmetric and symmetric algorithms？ （）

    • A、Only symmetric algorithms have a key exchange technology built in
    • B、Asymmetric algorithms are used quite often as key exchange protocols for symmetricalgorithms
    • C、Only asymmetric algorithms have a key exchange technology built in
    • D、Asymmetric algorithms are based on more complex mathematical computations

    正确答案:B,C,D

  • 第3题：

    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

  • 第4题：

    When monitoring a system using vmstat with an interval， which of the following conclusions should be drawn about the metrics under page pi and page po？（）

    • A、 The values do not include working storage.
    • B、 The values do not include persistent storage.
    • C、 The values include both persistent and working storage.
    • D、 The values are not working or persistent storage.

    正确答案:B

  • 第5题：

    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

  • 第6题：

    Which three statements are characteristic of the MEMORY storage engine?（）

    • A、It can support transactions
    • B、Table contents are not saved if the server is restarted
    • C、It cannot contain text or BLOB columns
    • D、It can support foreign keys
    • E、Each table is represented on disk as an.frm file
    • F、Each table has a corresponding.MYI and .MYD file

    正确答案:B,C,E

  • 第7题：

    You are testing an existing ASP.NET page. The page includes a text box. You are able to execute malicious JavaScript code by typing it in the text box and submitting. You need to configure the page to prevent JavaScript code from being submitted by the text box. In the @ Page directive， which attribute should you set to true？（）

    • A、the EnableEventValidation attribute
    • B、the ResponseEncoding attribute
    • C、the ValidateRequest attribute
    • D、the Strict attribute

    正确答案:C

  • 第8题：

    单选题
    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
    解析： 暂无解析

  • 第9题：

    多选题
    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
    解析： 暂无解析

  • 第10题：

    单选题
    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
    解析： 暂无解析

  • 第11题：

    多选题
    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
    解析： 暂无解析

  • 第12题：

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

    A

    B

    B

    C

    C

    D

    D

    E

    E


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

  • 第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 ensures that a JSP response is of type "text/plain"？（）

    • A、<%@ page mimeType="text/plain" %>
    • B、<%@ page contentType="text/plain" %>
    • C、<%@ page pageEncoding="text/plain" %>
    • D、<%@ page contentEncoding="text/plain" %>
    • E、<% response.setEncoding（"text/plain"）； %>

    正确答案:B

  • 第15题：

    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

    正确答案:A,B,C

  • 第16题：

    Which statements are true regarding the concept of problems and incidents in the fault diagnosability infrastructure for Oracle Database 11g？（）  

    • A、 Only the incident metadata and dumps are stored in the Automatic Diagnostic Repository （ADR）.
    • B、 The problem key is the same as the incident number.
    • C、 The database sends an incident alert to the Oracle Enterprise Manager Database Home page.
    • D、 Every problem has a problem key， which is a text string that describes the problem.
    • E、 The database makes an entry into the alert log file when problems and incidents occur.

    正确答案:C,D,E

  • 第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题：

    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

  • 第19题：

    多选题
    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
    解析： 暂无解析

  • 第20题：

    多选题
    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
    解析： 暂无解析

  • 第21题：

    多选题
    Which three statements are characteristic of the MEMORY storage engine?（）
    A

    It can support transactions

    B

    Table contents are not saved if the server is restarted

    C

    It cannot contain text or BLOB columns

    D

    It can support foreign keys

    E

    Each table is represented on disk as an.frm file

    F

    Each table has a corresponding.MYI and .MYD file


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

  • 第22题：

    单选题
    You are testing an existing ASP.NET page. The page includes a text box. You are able to execute malicious JavaScript code by typing it in the text box and submitting. You need to configure the page to prevent JavaScript code from being submitted by the text box. In the @ Page directive， which attribute should you set to true？（）
    A

    the EnableEventValidation attribute

    B

    the ResponseEncoding attribute

    C

    the ValidateRequest attribute

    D

    the Strict attribute


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

  • 第23题：

    单选题
    Which ensures that a JSP response is of type "text/plain"？（）
    A

    <%@ page mimeType=text/plain %>

    B

    <%@ page contentType=text/plain %>

    C

    <%@ page pageEncoding=text/plain %>

    D

    <%@ page contentEncoding=text/plain %>

    E

    <% response.setEncoding（text/plain）； %>


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

相关内容