<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

    主站蜘蛛池模板: 国产精品无码免费专区午夜| 亚洲AV无码久久精品狠狠爱浪潮| 亚洲国产精品国产自在在线| 精品一区二区三区中文字幕| 在线观看国产精品普通话对白精品 | 国产亚洲综合成人91精品| 久久亚洲精品无码播放| 国产精品自产拍在线观看| 亚洲色精品aⅴ一区区三区| 精品99又大又爽又硬少妇毛片| 精品免费视在线观看| 国产麻豆精品久久一二三| 天天爽夜夜爽夜夜爽精品视频 | japanese乱人伦精品| 正在播放国产精品每日更新| 精品亚洲一区二区三区在线播放| 亚洲精品一二区| 精品国产第1页| 91精品国产高清久久久久久io| 午夜精品久久久久久毛片| 久久久久人妻精品一区三寸蜜桃| 人精品影院| 先锋影音国产精品| 国产精品影音先锋| 国产成人精品日本亚洲直接| 精品亚洲国产成AV人片传媒| 无码国产69精品久久久久网站 | 国产精品污WWW一区二区三区| 久久99精品国产| 国产精品美女久久久m| 久久精品无码专区免费青青| 亚洲国产成人精品无码区在线观看| 亚洲精品国产高清不卡在线| 日韩精品免费一线在线观看| 久久久久这里只有精品 | 99国产精品久久| 国产综合色在线精品| 乱色精品无码一区二区国产盗| 亚洲精品无码Av人在线观看国产| 亚洲精品国产福利一二区| 一级做a爰黑人又硬又粗免费看51社区国产精品视 |