违法和不良信息举报 联系客服
免费注册 登录

What is true regarding InnoDB lo

题目

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
如果没有搜索结果或未解决您的问题，请直接 联系老师 获取答案。
相似问题和答案

第1题：

What is true regarding Cisco Network Registrar in Cable networks？（）

  • A、It provides comprehensive Domain Name system
  • B、It provides DHCP administrative functionality
  • C、It provides TFTP server functionality.
  • D、All of the above are true

正确答案:D

第2题：

Which of the following is true regarding Label Distribution Protocol （LDP）？（）

  • A、It is a label distribution protocol for MPLS
  • B、It is a set of procedures and messages by which LSRs establish Label Switch Paths （LSPs） through a network
  • C、Tag distribution Protocol （TDP） was the basis for LDP
  • D、All of the above are true

正确答案:D

第3题：

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

第4题：

Identify the true statement regarding Temporary Coherence cluster members（）

  • A、 it should have "localstorage" set to TRUE
  • B、 it should be configured so as to not trigger re-partitioning 
  • C、 both A and B are TRUE
  • D、 Neither A and B are TRUE

正确答案:B

第5题：

What statements are true regarding ICMP packets?（）

  • A、They acknowledge receipt of TCP segments.
  • B、They guarantee datagram delivery.
  • C、They can provide hosts with information about network problems.
  • D、They are encapsulated within IP datagrams.
  • E、They are encapsulated within UDP datagrams.

正确答案:C,D

第6题：

What is true regarding Autonomous Systems （AS ）？（）

  • A、AS numbers are assigned by the IANA
  • B、AS numbers are used by BGP （Border Gateway protocol ） to exchange IP routing information with neighboring AS
  • C、In the internet， an Autonomous System （AS） is a collection of IP networks and routers under the control
  • D、All of the Above

正确答案:D

第7题：

What is true regarding the OSPF Type 2 LSA?（）

  • A、The DR floods this to describe the local stub network segment.
  • B、The ABR floods this to describe the local stub network segment.
  • C、The DR floods this to describe the local transit network segment.
  • D、Each OSPF router floods this to describe its interfaces and metrics.
  • E、The DR and BDR flood this to describe the local transit network segment.

正确答案:C

第8题：

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

第9题：

What statement is true regarding processor allocation when implementing micro-partitions？ （）

  • A、 The minimum configurable capacity allocation is 1.0 core and the minimum increment is 0.1 core.
  • B、 The minimum configurable capacity allocation is 0.1 core and the minimum increment is 0.01 core.
  • C、 The minimum configurable capacity allocation is 1.0 core and the minimum increment is 0.01 core.
  • D、 The minimum configurable capacity allocation is 0.1 core and the minimum increment is 0.001

正确答案:B

第10题：

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

更多相关问题
相关内容