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
点击查看答案
单选题Which object privileges can be granted on a view? ()A noneB DELETE, INSERT,SELECTC ALTER, DELETE, INSERT, SELECTD DELETE, INSERT, SELECT, UPDATE
单选题A stored procedure object is created into which DB2 object?()A AliasB SchemaC PackageD Routine Space
单选题An Alias can be an alternate name for which DB2 object?()A SequenceB TriggerC SchemaD View
单选题Which of the following is a characteristic of a schema?()A Foreign key references cannot cross schema boundaries.B A DB2 user must be created before a schema with the same name can be created.C If no schema is specified when an object is created, the default schema PUBLIC is used.D A schema enables the creation of multiple objects in a database without encountering namespace collisions.
单选题Which HttpSession method stores an object in a session?()Aput(String name. Object value)Bset(String name. Object value)CsetAttribute(String name. Object value)DputAttribute(String name. Object value)EaddAttribute(String name. Object value)
单选题A user utilizing an alias to update a subset of columns in a table must have UPDATE privileges on which of the following DB2 objects?()A TableB ColumnsC Table and AliasD Columns and Alias