IBM(000-730)單項選擇題每日一練(2019.01.19)

A.Sequence
B.Table Function
C.Identity Column
D.INSTEAD OF Trigger

A.The cursor is only protected from updates and deletes by concurrent applications.
B.The row is only protected from positioned updates and deletes that reference another cursor of the same application.
C.The cursor is protected from positioned updates and deletes that reference another cursor of a different application.
D.The row is protected from updates and deletes by the current application and from positioned updates and deletes that reference another cursor of the same application.

A.CALL getratews11('USA','CANADA')
B.CALL expenses.getratews11('USA','CANADA')
C.SELECT getratews11('USA','CANADA') FROM expenses
D.SELECT * FROM TABLE(getratews11('USA','CANADA')) AS convert_currency

A.The CONNECT statement
B.The first FETCH of a cursor
C.The BEGIN TRANSACTION statement
D.The first executable SQL statement

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