多选题Which two statements about sequences are true? ()AYou use a NEXTVAL pseudo column to look at the next possible value that would be generated from a sequence, without actually retrieving the value.BYou use a CURRVAL pseudo column to look at the current

题目
多选题
Which two statements about sequences are true? ()
A

You use a NEXTVAL pseudo column to look at the next possible value that would be generated from a sequence, without actually retrieving the value.

B

You use a CURRVAL pseudo column to look at the current value just generated from a sequence, without affecting the further values to be generated from the sequence.

C

You use a NEXTVAL pseudo column to obtain the next possible value from a sequence by actually retrieving the value from the sequence.

D

You use a CURRVAL pseudo column to generate a value from a sequence that would be used for a specified database column.

E

If a sequence starting from a value 100 and incremented by 1 is used by more then one application, then all of these applications could have a value of 105 assigned to their column whose value is being generated by the sequence.

F

You use REUSE clause when creating a sequence to restart the sequence once it generates the maximum value defined for the sequence.


相似考题
更多“Which two statements about sequences are true? ()”相关问题
  • 第1题:

    Which two statements about VACLs on Cisco Nexus 7000 Series Switches are true? ()

    • A、 A single VACL can be shared across two or more VDCs.
    • B、 Use of VACLs requires no special license to be installed.
    • C、 VACLs make use of IP or MAC ACLs.
    • D、 Only options drop and forward are permitted.

    正确答案:B,C

  • 第2题:

    Which two statements are true about traffic shaping?()

    • A、Out-of-profile packets are queued.
    • B、It causes TCP retransmits.
    • C、Marking/remarking is not supported.
    • D、It does not respond to BECN and ForeSight Messages.
    • E、It uses a single/two-bucket mechanism for metering.

    正确答案:A,C

  • 第3题:

    Which two statements about OSPF IPv6 routing are true?()

    • A、It requires OSPF version 3.
    • B、automatically detects neighbors over NHMA interfaces
    • C、It supports encryption using
    • D、It uses LSA type 9
    • E、It uses LSA type 8

    正确答案:A,E

  • 第4题:

    Which two statements are true about pool-based source NAT? ()(Choose two.)

    • A、PAT is not supported.
    • B、PAT is enabled by default.
    • C、It supports the address-persistent configuration option.
    • D、It supports the junos-global configuration option.

    正确答案:B,C

  • 第5题:

    Which two statements are true about standard database auditing()

    • A、DDL statements can be audited.
    • B、Statements that refer to stand-alone procedure can be audited.
    • C、Operations by the users logged on as SYSDBA cannot be audited.
    • D、Only one audit record is ever created for a session per audited statement even though it is executedmore than once.

    正确答案:A,B

  • 第6题:

    What is true about sequences?()

    • A、Once created, a sequence belongs to a specific schema.
    • B、Once created, a sequence is linked to a specific table.
    • C、Once created, a sequence is automatically available to all users.
    • D、Only the DBA can control which sequence is used by a certain table.
    • E、Once created, a sequence is automatically used in all INSERT and UPDATE statements.

    正确答案:A

  • 第7题:

    多选题
    Which two statements are true about L2TP tunnels?() (Choose two.)
    A

    Traffic is clear text

    B

    Traffic is encrypted 

    C

    They are initiated by the LNS

    D

    They are initiated by the LAC


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

  • 第8题:

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


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

  • 第9题:

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


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

  • 第10题:

    单选题
    What is true about sequences? ()
    A

    Once created, a sequence belongs to a specific schema.

    B

    Once created, a sequence is linked to a specific table.

    C

    Once created, a sequence is automatically available to all users.

    D

    Only the DBA can control which sequence is used by a certain table.

    E

    Once created, a sequence is automatically used in all INSERT and UPDATE statements.


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

  • 第11题:

    Which two statements are true about L2TP tunnels?() (Choose two.)

    • A、Traffic is clear text
    • B、Traffic is encrypted 
    • C、They are initiated by the LNS
    • D、They are initiated by the LAC

    正确答案:A,D

  • 第12题:

    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

  • 第13题:

    Which two statements about VPLS are true? ()

    • A、There is a full mesh of pseudowires.
    • B、There is a partial mesh of pseudowires.
    • C、Only L2TPv3 can be used for pseudowire establishment.
    • D、There is split-horizon to avoid loops.

    正确答案:A,D

  • 第14题:

    Which two statements are true about precedence values in policy?() (Choose two.)

    • A、1 is the default precedence.
    • B、A lower number is preferred.
    • C、A higher number is preferred.
    • D、100 is the default precedence.

    正确答案:B,D

  • 第15题:

    Which two statements are true about record groups?()

    • A、They are stored in the database. 
    • B、They are stored in local Forms memory. 
    • C、The type is specified explicitly at design time. 
    • D、The type is implied by when and how it is created.

    正确答案:B,D

  • 第16题:

    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

  • 第17题:

    多选题
    Which two statements are true regarding the default behavior of the ORDER BY clause? ()
    A

    Null values are left out of the sort.

    B

    Character values are displayed from Z to A

    C

    Date values are displayed with the earliest value first.

    D

    Null values are displayed last for descending sequences.

    E

    Numeric values are displayed with the lowest values first.


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

  • 第18题:

    多选题
    Which two statements are true about AH?() (Choose two.)
    A

    AH provides data integrity.

    B

    AH is identified by IP protocol 50.

    C

    AH is identified by IP protocol 51.

    D

    AH cannot work in conjunction with ESP


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

  • 第19题:

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

    The bus is limited to 32 devices

    B

    It is a full duplex serial standard

    C

    It is a half-duplex serial standard

    D

    It allows up to 320 MB/s of shared channel bandwidth


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

  • 第20题:

    多选题
    Which two statements are true about traffic shaping?()
    A

    Out-of-profile packets are queued.

    B

    It causes TCP retransmits.

    C

    Marking/remarking is not supported.

    D

    It does not respond to BECN and ForeSight Messages.

    E

    It uses a single/two-bucket mechanism for metering.


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