<dfn id="w48us"></dfn><ul id="w48us"></ul>
  • <ul id="w48us"></ul>
  • <del id="w48us"></del>
    <ul id="w48us"></ul>
  • 十一個高級MySql筆試題

    時間:2020-11-25 18:25:35 筆試題目 我要投稿

    十一個高級MySql筆試題

      1. Explain MySQL architecture. – The front layer takes care of network connections and security authentications, the middle layer does the SQL query parsing, and then the query is handled off to the storage engine. A storage engine could be either a default one supplied with MySQL (MyISAM) or a commercial one supplied by a third-party vendor (ScaleDB, InnoDB, etc.)

    十一個高級MySql筆試題

      2. Explain MySQL locks. – Table-level locks allow the user to lock the entire table, page-level locks allow locking of certain portions of the tables (those portions are referred to as tables), row-level locks are the most granular and allow locking of specific rows.

      3. Explain multi-version concurrency control in MySQL. – Each row has two additional columns associated with it – creation time and deletion time, but instead of storing timestamps, MySQL stores version numbers.

      4. What are MySQL transactions? – A set of instructions/queries that should be executed or rolled back as a single atomic unit.

      5. What’s ACID? – Automicity – transactions are atomic and should be treated as one in case of rollback. Consistency – the database should be in consistent state between multiple states in transaction. Isolation – no other queries can access the data modified by a running transaction. Durability – system crashes should not lose the data.

      6. Which storage engines support transactions in MySQL? – Berkeley DB and InnoDB.

      7. How do you convert to a different table type? – ALTER TABLE customers TYPE = InnoDB

      8. How do you index just the first four bytes of the column? – ALTER TABLE customers ADD INDEX (business_name(4))

      9. What’s the difference between PRIMARY KEY and UNIQUE in MyISAM? – PRIMARY KEY cannot be null, so essentially PRIMARY KEY is equivalent to UNIQUE NOT NULL.

      10. How do you prevent MySQL from caching a query? – SELECT SQL_NO_CACHE …

      11. What’s the difference between query_cache_type 1 and 2? – The second one is on-demand and can be retrieved via SELECT SQL_CACHE … If you’re worried about the SQL portability to other servers, you can use SELECT /* SQL_CACHE */ id FROM … – MySQL will interpret the code inside comments, while other servers will ignore it.

    【十一個高級MySql筆試題】相關文章:

    MYSQL基礎筆試題01-06

    MySQL筆試題目集錦01-06

    幾個MySql的筆試題01-06

    遇到的Mysql的筆試題01-06

    360筆試題目07-11

    華為2017筆試題08-16

    華為2017筆試試題08-10

    桂林銀行筆試題筆經07-20

    高級Java筆試題集合12-03

    主站蜘蛛池模板: 亚洲精品老司机在线观看| 日韩一区二区三区在线精品| 欧美日韩国产精品系列| 精品人妻中文字幕有码在线| 黑人无码精品又粗又大又长| 国产精品视频久久久| 亚洲精品成人片在线观看| 91大神精品全国在线观看| 蜜芽亚洲av无码精品色午夜 | 国内精品视频在线观看| 国产精品色内内在线播放| 热久久国产欧美一区二区精品| 久久精品www| 国产精品久久久久国产A级| 亚洲一区精品伊人久久伊人| 国产精品秘入口福利姬网站| 国产精品你懂的| 精品人伦一区二区三区潘金莲| 亚洲国产一成久久精品国产成人综合| 国产精品亚洲αv天堂无码| 久久国产成人精品麻豆| AAA级久久久精品无码片| 无码精品国产一区二区三区免费| 久久久久久久亚洲精品| 国产99久久久国产精品~~牛 | 国产精品99无码一区二区| 国产精品高清视亚洲精品| 精品无码人妻夜人多侵犯18| 亚洲综合精品香蕉久久网| 欧美精品一区二区久久| 国产精品亚洲欧美大片在线看 | 亚洲中文字幕无码久久精品1| 国产色婷婷精品综合在线| 北岛玲日韩精品一区二区三区| 国产亚洲精品国产| 99国产精品一区二区| 国产精品网站在线观看免费传媒| 精品蜜臀久久久久99网站| 精品成在人线AV无码免费看| 日韩av无码久久精品免费| 日韩精品系列产品|