网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
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
参考答案
更多 “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” 相关考题
考题
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
考题
Which two statements are true about InnoDB auto－increment locking?()
A.The auto-increment lock can be a table-level lockB.InnoDB never uses table-level locksC.Some settings for innodb_autoinc_lock_mode can help reduce lockingD.InnoDB always protects auto-increment updates with a table-level lock
考题
What is true regarding Cisco Network Registrar in Cable networks？（）A、It provides comprehensive Domain Name systemB、It provides DHCP administrative functionalityC、It provides TFTP server functionality.D、All of the above are true
考题
What is true regarding Autonomous Systems （AS ）？（）A、AS numbers are assigned by the IANAB、AS numbers are used by BGP （Border Gateway protocol ） to exchange IP routing information with neighboring ASC、In the internet， an Autonomous System （AS） is a collection of IP networks and routers under the controlD、All of the Above
考题
Which of the following is true regarding Label Distribution Protocol （LDP）？（）A、It is a label distribution protocol for MPLSB、It is a set of procedures and messages by which LSRs establish Label Switch Paths （LSPs） through a networkC、Tag distribution Protocol （TDP） was the basis for LDPD、All of the above are true
考题
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.
考题
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.
考题
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
考题
Identify the true statement regarding Temporary Coherence cluster members（）A、 it should have "localstorage" set to TRUEB、 it should be configured so as to not trigger re-partitioning C、 both A and B are TRUED、 Neither A and B are TRUE
考题
Which two statements are true about InnoDB auto-increment locking?（）A、The auto-increment lock can be a table-level lockB、InnoDB never uses table-level locksC、Some settings for innodb_autoinc_lock_mode can help reduce lockingD、InnoDB always protects auto-increment updates with a table-level lock
考题
What is true regarding subqueries?（）A、The inner query always sorts the results of the outer query.B、The outer query always sorts the results of the inner query.C、The outer query must return a value to the inner query.D、The inner query returns a value to the outer query.E、The inner query must always return a value or the outer query will give an error.
考题
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
考题
单选题Following a server crash, the automatic recovery of InnoDB fails. How would you begin to manually repair the InnoDB tables?（）A
Start the server with the – innodb_recover_options option set to FORCEB
Start the server with the – innodb_force_recovery option set to a non-zero valueC
Start the server as usual, and then execute the REPAIR TABLE commandD
Start the server as usual, and then execute the CHECK TABLE command
考题
多选题Full Atomicity, Consistency, Isolation, Durability (ACID) compliance is a necessity for a new application, which heavily reads and writes data. This requires the following config file options: Sync_binlog=1 Innodb_flush_log_at_trx_commit=1 Innodb_doublewrite=1 However, this configuration is expected to introduce disk I/O overhead. What three changes will reduce disk I/O overheads?（）AUse of soft links for database directories on the same physical diskBUse of delay_key_write=ON for batch index updateCAllocation of RAM to the buffer pool such that more of the data can fit in RAMDPlacement of InnoDB log files and datadir on separate physical disksEUse of separate directories on the same physical disk for log files and data files
考题
单选题What is true regarding subqueries?（）A
The inner query always sorts the results of the outer queryB
The outer query always sorts the results of the inner queryC
The outer query must return a value to the outer queryD
The inner query returns a value to the outer queryE
The inner query must always return a value or the outer query will give an error
考题
单选题______ you said is true, there are still other factors to be considered .A
Supposed that whatB
Supposing what thatC
Granted that whatD
Considered what that
考题
多选题What statements are true regarding ICMP packets?（）AThey acknowledge receipt of TCP segments.BThey guarantee datagram delivery.CThey can provide hosts with information about network problems.DThey are encapsulated within IP datagrams.EThey are encapsulated within UDP datagrams.
考题
多选题Which two statements are true about InnoDB auto-increment locking?（）AThe auto-increment lock can be a table-level lockBInnoDB never uses table-level locksCSome settings for innodb_autoinc_lock_mode can help reduce lockingDInnoDB always protects auto-increment updates with a table-level lock
考题
单选题What is true regarding Autonomous Systems （AS ）？（）A
AS numbers are assigned by the IANAB
AS numbers are used by BGP （Border Gateway protocol ） to exchange IP routing information with neighboring ASC
In the internet， an Autonomous System （AS） is a collection of IP networks and routers under the controlD
All of the Above
考题
单选题What is true regarding Cisco Network Registrar in Cable networks？（）A
It provides comprehensive Domain Name systemB
It provides DHCP administrative functionalityC
It provides TFTP server functionality.D
All of the above are true
考题
多选题On a Cisco Unified Computing System （UCS）， which two statements regarding Ethanalyzer are true？（）AInterface inbound-low handles Rx and Tx of low-priority control packetBInterface inbound-lo handles Rx and Tx of high-priority control packetCInterface inbound-low maps to internal interface eth3DInterface inbound-low maps to internal interface eth4
考题
多选题What are two methods of taking a binary backup of a Mysql Server using InnoDB storage engine?（）AFile system snapshotsBMysqldumpslowCMysqlhotcopyDMysqldump with – binary-data optionEMysql Enterprise Backup
考题
单选题Which of the following is true regarding Label Distribution Protocol （LDP）？（）A
It is a label distribution protocol for MPLSB
It is a set of procedures and messages by which LSRs establish Label Switch Paths （LSPs） through a networkC
Tag distribution Protocol （TDP） was the basis for LDPD
All of the above are true
考题
单选题Identify the true statement regarding Temporary Coherence cluster members（）A
it should have localstorage set to TRUEB
it should be configured so as to not trigger re-partitioning C
both A and B are TRUED
Neither A and B are TRUE
考题
单选题What is true regarding subqueries?（）A
The inner query always sorts the results of the outer query.B
The outer query always sorts the results of the inner query.C
The outer query must return a value to the inner query.D
The inner query returns a value to the outer query.E
The inner query must always return a value or the outer query will give an error.
考题
单选题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
考题
单选题What is true regarding a transaction executed in Automatic Undo Management mode？（）A
AB
BC
CD
D
热门标签
最新试卷
