单选题Within the application MY_APP the following PREVIOUS VALUE expression references the sequence MY_SEQ: PREVIOUS VALUE FOR my_seq After which of the following events will the most recently generated value of MY_SEQ persist so that it can be returned to t

题目
单选题
Within the application MY_APP the following PREVIOUS VALUE expression references the sequence MY_SEQ: PREVIOUS VALUE FOR my_seq After which of the following events will the most recently generated value of MY_SEQ persist so that it can be returned to the active MY_APP application?（）
A

After a ROLLBACK is issued

B

After the sequence is altered

C

After the sequence is dropped

D

After the current session ends

相似考题

1.Which of the following is "报盘"?A、bidB、estimateC、offerD、value

2.Within the application MY_APP the following PREVIOUS VALUE expression references the sequence MY_SEQ: PREVIOUS VALUE FOR my_seq After which of the following events will the most recently generated value of MY_SEQ persist so that it can be returned to the active MY_APP application?（）A.After a ROLLBACK is issuedB.After the sequence is alteredC.After the sequence is droppedD.After the current session ends

3.Which of the following is a feature of a unit of work?()A.It applies to a single data server.B.It is a recoverable sequence of operations.C.Its value can be queried from the system catalog tables.D.It begins when the application connects to the data server.

4.Which of the following constraint types can be used to ensure the value of an INTEGER column references only positive values?()A.UniqueB.CheckC.ReferentialD.Informational

更多“单选题Within the application MY_APP the following PREVIOUS VALUE expression references the sequence MY_SEQ: PREVIOUS VALUE FOR my_seq After which of the following events will the most recently generated value of MY_SEQ persist so that it can be returned to t”相关问题

  • 第1题：

    Which of the following is a characteristic of a sequence?()

    A.A sequence will never generate duplicate values

    B.The MAXVALUE of a sequence can be equal to the MINVALUE

    C.It is not possible to create a sequence that generates a constant since the INCREMENT value must be greater than zero

    D.When a sequence cycles back to either the MAXVALUE or MINVALUE, it will always be equal to the specified value of either of these two boundaries


    参考答案：B

  • 第2题：

    Which of the following constraint types can be used to ensure the value of an INTEGER column references only positive values?（）

    • A、Unique
    • B、Check
    • C、Referential
    • D、Informational

    正确答案:B

  • 第3题：

    lisa is writing a formula to determine the number of elements in a list. she wants to ensure that a value is returned, even if the value her function is evaluating turns out to be a null string . which one of the following can she so to accomplish this ?（）

    • A、use a defaule formula of 1 
    • B、use @elements and add 1 to the total 
    • C、use the @count function instead of @elements 
    • D、use @texttotime to ensure that all strings arte converted to date-time values 

    正确答案:C

  • 第4题：

    After running the vmstat command， which of the following would most likely cause the value in the blocked column to be unusually high？（）

    • A、 Kernel thread
    • B、 Too many users
    • C、 Memory shortage
    • D、 Network contention

    正确答案:A

  • 第5题：

    Which of the following is a feature of a unit of work?（）

    • A、It applies to a single data server.
    • B、It is a recoverable sequence of operations.
    • C、Its value can be queried from the system catalog tables.
    • D、It begins when the application connects to the data server.

    正确答案:B

  • 第6题：

    For which three events can web application event listeners be registered？（）

    • A、When a session is created
    • B、After a servlet is destroyed
    • C、When a session has timed out
    • D、When a cookie has been created
    • E、When a servlet has forwarded a request
    • F、When a session attribute value is changed

    正确答案:A,C,F

  • 第7题：

    A table was just created on your Oracle database with six extents allocated to it. Which of the following factors most likely caused the table to have so many extents allocated?（）

    • A、The value for MINEXTENTS setting 
    • B、The value for PCTINCREASE setting 
    • C、The value for MAXEXTENTS setting 
    • D、By default, Oracle allocates six extents to all database objects

    正确答案:A

  • 第8题：

    单选题
    After running the vmstat command， which of the following would most likely cause the value in the blocked column to be unusually high？（）
    A

     Kernel thread

    B

     Too many users

    C

     Memory shortage

    D

     Network contention


    正确答案： C
    解析： 暂无解析

  • 第9题：

    单选题
    Within the application MY_APP the following PREVIOUS VALUE expression references the sequence MY_SEQ: PREVIOUS VALUE FOR my_seq After which of the following events will the most recently generated value of MY_SEQ persist so that it can be returned to the active MY_APP application?（）
    A

    After a ROLLBACK is issued

    B

    After the sequence is altered

    C

    After the sequence is dropped

    D

    After the current session ends


    正确答案： B
    解析： 暂无解析

  • 第10题：

    单选题
    Given the following ALTER SEQUENCE statement: ALTER SEQUENCE myseq RESTART WITH 0 INCREMENT BY 1 NO MAXVALUE CACHE 5 ORDER Assuming that the sequence had reached a value of 100 prior to the RESTART, which of the following is true?（）
    A

    The next value will be 0 and the sequence will never use the values 101 to 105.

    B

    The next value will be 101 to ensure uniqueness between existing and newly generated sequence values.

    C

    Previously cached values are retained by DB2, and after the restart, will be used for values 101 to 105.

    D

    The next value will be 0 and DB2 will not ensure uniqueness between existing and newly generated values.


    正确答案： B
    解析： 暂无解析

  • 第11题：

    单选题
    Which of the following is a feature of a unit of work?（）
    A

    It applies to a single data server.

    B

    It is a recoverable sequence of operations.

    C

    Its value can be queried from the system catalog tables.

    D

    It begins when the application connects to the data server.


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

  • 第12题：

    单选题
    lisa is writing a formula to determine the number of elements in a list. she wants to ensure that a value is returned, even if the value her function is evaluating turns out to be a null string . which one of the following can she so to accomplish this ?（）
    A

    use a defaule formula of 1 

    B

    use @elements and add 1 to the total 

    C

    use the @count function instead of @elements 

    D

    use @texttotime to ensure that all strings arte converted to date-time values 


    正确答案： C
    解析： 暂无解析

  • 第13题：

    Given the following ALTER SEQUENCE statement: ALTER SEQUENCE myseq RESTART WITH 0 INCREMENT BY 1 NO MAXVALUE CACHE 5 ORDER Assuming that the sequence had reached a value of 100 prior to the RESTART, which of the following is true?（）

    • A、The next value will be 0 and the sequence will never use the values 101 to 105.
    • B、The next value will be 101 to ensure uniqueness between existing and newly generated sequence values.
    • C、Previously cached values are retained by DB2, and after the restart, will be used for values 101 to 105.
    • D、The next value will be 0 and DB2 will not ensure uniqueness between existing and newly generated values.

    正确答案:D

  • 第14题：

    which one of the following is an @fuction that Lonnie can use to return the value from a specific field?（）

    • A、 @value 
    • B、 @getfield 
    • C、 @GetItemVale 
    • D、 @getfieldvalue

    正确答案:B

  • 第15题：

    Which of the following is a characteristic of a sequence?（）

    • A、A sequence will never generate duplicate values
    • B、The MAXVALUE of a sequence can be equal to the MINVALUE
    • C、It is not possible to create a sequence that generates a constant since the INCREMENT value must be greater than zero
    • D、When a sequence cycles back to either the MAXVALUE or MINVALUE, it will always be equal to the specified value of either of these two boundaries

    正确答案:B

  • 第16题：

    Within the application MY_APP the following PREVIOUS VALUE expression references the sequence MY_SEQ: PREVIOUS VALUE FOR my_seq After which of the following events will the most recently generated value of MY_SEQ persist so that it can be returned to the active MY_APP application?（）

    • A、After a ROLLBACK is issued
    • B、After the sequence is altered
    • C、After the sequence is dropped
    • D、After the current session ends

    正确答案:A

  • 第17题：

    A sequence was created with the DDL statement shown below:CREATE SEQUENCE my_seq START WITH 5 INCREMENT BY 5 CACHE 5 User1 successfully executes the following statements in Connection1: VALUES NEXT VALUE FOR my_seq INTO :con1hvar VALUES NEXT VALUE FOR my_seq INTO :con1hvar User2 successfully executes the following statement in Connection2: VALUES NEXT VALUE FOR my_seq INTO :con2hvar After User1 & User2 are finished, User3 executes the following statement in Connection3: SELECT NEXT VALUE FOR my_seq FROM sysibm.sysdummy1Which value will be returned by the query?（）

    • A、20
    • B、25
    • C、50
    • D、55

    正确答案:D

  • 第18题：

    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.

    正确答案:B,C

  • 第19题：

    单选题
    Which of the following constraint types can be used to ensure the value of an INTEGER column references only positive values?（）
    A

    Unique

    B

    Check

    C

    Referential

    D

    Informational


    正确答案： C
    解析： 暂无解析

  • 第20题：

    单选题
    which one of the following is an @fuction that Lonnie can use to return the value from a specific field?（）
    A

     @value 

    B

     @getfield 

    C

     @GetItemVale 

    D

     @getfieldvalue


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

  • 第21题：

    单选题
    A table was just created on your Oracle database with six extents allocated to it. Which of the following factors most likely caused the table to have so many extents allocated?（）
    A

    The value for MINEXTENTS setting 

    B

    The value for PCTINCREASE setting 

    C

    The value for MAXEXTENTS setting 

    D

    By default, Oracle allocates six extents to all database objects


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

  • 第22题：

    单选题
    A sequence was created with the DDL statement shown below:CREATE SEQUENCE my_seq START WITH 5 INCREMENT BY 5 CACHE 5 User1 successfully executes the following statements in Connection1: VALUES NEXT VALUE FOR my_seq INTO :con1hvar VALUES NEXT VALUE FOR my_seq INTO :con1hvar User2 successfully executes the following statement in Connection2: VALUES NEXT VALUE FOR my_seq INTO :con2hvar After User1 & User2 are finished, User3 executes the following statement in Connection3: SELECT NEXT VALUE FOR my_seq FROM sysibm.sysdummy1Which value will be returned by the query?（）
    A

    20

    B

    25

    C

    50

    D

    55


    正确答案： B
    解析： 暂无解析

  • 第23题：

    单选题
    Which of the following is a characteristic of a sequence?（）
    A

    A sequence will never generate duplicate values

    B

    The MAXVALUE of a sequence can be equal to the MINVALUE

    C

    It is not possible to create a sequence that generates a constant since the INCREMENT value must be greater than zero

    D

    When a sequence cycles back to either the MAXVALUE or MINVALUE, it will always be equal to the specified value of either of these two boundaries


    正确答案： B
    解析： 暂无解析

  • 第24题：

    单选题
    Given the following code：    public class Test {  void printValue（int m）{  do {  System.out.println（"The value is"+m）；     }  while（ --m > 10 ）     }  public static void main（String arg[]） {     int i=10；  Test t= new Test（）；     t.printValue（i）；     }     }  Which will be output？（）
    A

     The value is 8

    B

     The value is 9

    C

     The value is 10

    D

     The value is 11


    正确答案： B
    解析： 此题考察的是do… while循环和 -- 操作符的知识，do…while最少被执行一次，在执行完do中的内容后判断while中的条件是否为true，如果为true的话就再执行do中的内容，然后再进行判断，以此类推直到while的判断为false时退出循环执行循环后面的内容，而—操作符的规则是在变量右边的-- 将先进行运算，然后才是使变量的值减一，而在变量左边的是先将变量的值减一再运算。

相关内容