多选题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-in

题目
多选题
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


相似考题
更多“多选题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-in”相关问题
  • 第1题:

    By default, which two statements are true about export routing policies?()

    • A、Export policies can evaluate only active routes
    • B、Export policies can evaluate all routes
    • C、Export policies can be applied to the forwarding table
    • D、Export policies can be applied directly to interfaces

    正确答案:A,C

  • 第2题:

    By default, which two statements are true about export routing polices?()

    • A、Export polices can evaluate only active routes
    • B、Export polices can evaluate all routes
    • C、Export polices can be applied to the forwarding table
    • D、Export polices can be applied to interfaces

    正确答案:A,C

  • 第3题:

    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

  • 第4题:

    多选题
    Which two statements regarding asymmetric key encryption are true?()
    A

    The same key is used for encryption and decryption.

    B

    It is commonly used to create digital certificate signatures.

    C

    It uses two keys: one for encryption and a different key for decryption.

    D

    An attacker can decrypt data if the attacker captures the key used for encryption


    正确答案: D,B
    解析: 暂无解析

  • 第5题:

    多选题
    By default, which two statements are true about export routing polices?()
    A

    Export polices can evaluate only active routes

    B

    Export polices can evaluate all routes

    C

    Export polices can be applied to the forwarding table

    D

    Export polices can be applied to interfaces


    正确答案: A,B
    解析: 暂无解析

  • 第6题:

    多选题
    By default, which two statements are true about export routing policies?()
    A

    Export policies can evaluate only active routes

    B

    Export policies can evaluate all routes

    C

    Export policies can be applied to the forwarding table

    D

    Export policies can be applied directly to interfaces


    正确答案: B,A
    解析: 暂无解析

  • 第7题:

    多选题
    Which two statements are true about WHERE and HAVING clauses? ()
    A

    A WHERE clause can be used to restrict both rows and groups.

    B

    A WHERE clause can be used to restrict rows only.

    C

    A HAVING clause can be used to restrict both rows and groups.

    D

    A HAVING clause can be used to restrict groups only.

    E

    A WHERE clause CANNOT be used in a query of the query uses a HAVING clause.

    F

    A HAVING clause CANNOT be used in subqueries.


    正确答案: B,D
    解析: 暂无解析

  • 第8题:

    多选题
    Which two statements are true about the Automatic Diagnostic Repository (ADR)?()
    A

    The ADR base keeps all diagnostic information in binary format

    B

    SQL*Plus provides the ADRI script, which can be used to work with ADR

    C

    The ADR can be used for problem diagnosis only when the database is open

    D

    The ADR can be disabled by settting the DIAGNOSTIC_DEST parameter to null

    E

    The ADR can be used for problem diagnosis even when the database instance is down

    F

    The ADR base is shared across multiple instances


    正确答案: E,F
    解析: 暂无解析

  • 第9题:

    多选题
    Which two statements about an IDS are true?()
    A

    The IDS is in the traffic path.

    B

    The IDS can send TCP resets to the source device.

    C

    The IDS can send TCP resets to the destination device.

    D

    The IDS listens promiscuously to all traffic on the network.

    E

    Default operation is for the IDS to discard malicious traffic.


    正确答案: E,A
    解析: 暂无解析

  • 第10题:

    多选题
    Which two statements are true regarding single row functions?()
    A

    They accept only a single argument

    B

    They can be nested only to two levels

    C

    Arguments can only be column values or constants

    D

    They always return a single result row for every row of a queried table

    E

    They can return a data type value different from the one that is referenced


    正确答案: E,B
    解析: 暂无解析

  • 第11题:

    多选题
    Which two statements are true about overflow pools?()
    A

    Overflow pools do not support PAT

    B

    Overflow pools can not use the egress interface IP address for NAT

    C

    Overflow pools must use PAT

    D

    Overflow pools can contain the egress interface IP address or separate IP addresses


    正确答案: D,C
    解析: 暂无解析

  • 第12题:

    多选题
    Which two statements are true about firewall filter configurations?()
    A

    Multiple action modifiers can be included in the same term.

    B

    Only a single action modifier can be included in the same term.

    C

    The default term within a firewall filter uses the discard action.

    D

    The default term within a firewall filter uses the reject action.


    正确答案: C,D
    解析: 暂无解析

  • 第13题:

    Which two statements about the Cisco Nexus 1000V VSM are true?()

    • A、It performs switching decisions and forwarding for the VEM
    • B、It can be run on a virtual machine
    • C、It can be used for remote VEM switching Iine cards

    正确答案:B,C

  • 第14题:

    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

  • 第15题:

    Which two statements are true regarding single row functions?()

    • A、They accept only a single argument 
    • B、They can be nested only to two levels 
    • C、Arguments can only be column values or constants 
    • D、They always return a single result row for every row of a queried table 
    • E、They can return a data type value different from the one that is referenced

    正确答案:D,E

  • 第16题:

    多选题
    By default, which two statements are true about export routing policies?()
    A

    Export policies can evaluate only active routes.

    B

    Export policies can evaluate all routes.

    C

    Export policies can be applied to the forwarding table.

    D

    Export policies can be applied directly to interfaces


    正确答案: A,D
    解析: 暂无解析

  • 第17题:

    多选题
    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


    正确答案: C,D
    解析: 暂无解析

  • 第18题:

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

  • 第19题:

    多选题
    Which two statements about creating constraints are true?()
    A

    Constraint names must start with SYS_C

    B

    All constraints must be defines at the column level

    C

    Constraints can be created after the table is created

    D

    Constraints can be created at the same time the table is created

    E

    Information about constraints is found in the VIEW_CONSTRAINTS dictionary view


    正确答案: C,D
    解析: 暂无解析

  • 第20题:

    多选题
    Which two statements are true about the Automatic Diagnostic Repository (ADR)?() (Choose two.)
    A

    The ADR base keeps all diagnostic information in binary format

    B

    SQL*Plus provides the ADRI script, which can be used to work with ADR

    C

    The ADR can be used for problem diagnosis only when the database is open

    D

    The ADR can be disabled by settting the DIAGNOSTIC_DEST parameter to null

    E

    The ADR can be used for problem diagnosis even when the database instance is down

    F

    The ADR base is shared across multiple instances


    正确答案: D,B
    解析: 暂无解析

  • 第21题:

    多选题
    Which two statements about bigfile tablespaces are true? ()
    A

    The bigfile tablespace have only one data file.

    B

    The segment space management is automatic.

    C

    The extent management is dictionary managed.

    D

    The database can have only one bigfile tablespace.

    E

    The bigfile tablespace can be converted to a smallfile tablespace.


    正确答案: D,B
    解析: 暂无解析

  • 第22题:

    多选题
    Which two statements regarding symmetric key encryption are true?() (Choose two.)
    A

    The same key is used for encryption and decryption.

    B

    It is commonly used to create digital certificate signatures.

    C

    It uses two keys: one for encryption and a different key for decryption.

    D

    An attacker can decrypt data if the attacker captures the key used for encryption.


    正确答案: D,B
    解析: 暂无解析

  • 第23题:

    多选题
    Which two statements about the Cisco Nexus 1000V VSM are true?()
    A

    It performs switching decisions and forwarding for the VEM

    B

    It can be run on a virtual machine

    C

    It can be used for remote VEM switching Iine cards


    正确答案: B,C
    解析: 暂无解析

  • 第24题:

    多选题
    Which two statements about static NAT translations are true?()
    A

    They are always present in the NAT table.

    B

    They allow connection to be initiated from the outside.

    C

    They can be configured with access lists,to allow two or more connections to be initiated from the outside.

    D

    They require no inside or outside interface markings because addresses are statically defined.


    正确答案: D,B
    解析: 暂无解析