Sequence
Trigger
Schema
View
A programmer wants to generate values for a numeric ID column in their EXPENSE table. The ID column values need to be incremented by 1000 for each new expense report added to the EXPENSE table. Which DB2 object can be referenced by an INSERT statement to meet thisrequirement?()A.SequenceB.Table FunctionC.Identity ColumnD.INSTEAD OF Trigger
点击查看答案
Because objects( ) data and implementation, the user of an object can view the object as a black box that provides services.A.encapsulate B.inherit C.connect D.refer
Which object may be used during query optimization to improve the performance for a subset of SELECT queries?()A、MQTB、TriggerC、Read Only CursorD、Stored Procedure
An Alias can be an alternate name for which DB2 object?()A、SequenceB、TriggerC、SchemaD、View
On which of the following database objects may the SELECT privilege be controlled?()A、SequenceB、SchemaC、GroupD、View
A stored procedure object is created into which DB2 object?()A、AliasB、SchemaC、PackageD、Routine Space
A programmer wants to generate values for a numeric ID column in their EXPENSE table. The ID column values need to be incremented by 1000 for each new expense report added to the EXPENSE table. Which DB2 object can be referenced by an INSERT statement to meet thisrequirement?()A、SequenceB、Table FunctionC、Identity ColumnD、INSTEAD OF Trigger