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

单选题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题：

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

第2题：

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

第3题：

Which of the following is "报盘"?

A、bid

B、estimate

C、offer

D、value


正确答案:C

第4题：

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

第5题：

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

第6题：

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

第7题：

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

第8题：

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

第9题：

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

第10题：

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

更多相关问题
相关内容