Sequence
Trigger
Schema
View
第1题:
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.
第2题:
A.Table
B.Columns
C.Table and Alias
D.Columns and Alias
第3题:
A. a schema object
B. a subquery that can contain an ORDER BY clause
C. another name for a view that contains group functions
D. a subquery that is part of the FROM clause of another query
第4题:
第5题:
A.Sequence
B.Trigger
C.Schema
D.View
第6题:
A.Sequence
B.Schema
C.Group
D.View
第7题:
A.Alias
B.Schema
C.Package
D.Routine Space
第8题:
A.Package
B.Trigger
C.Stored Procedure
D.Informational Constraint
第9题:
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.Sequence
B.Table Function
C.Identity Column
D.INSTEAD OF Trigger
第10题:
Which object may be used during query optimization to improve the performance for a subset of SELECT queries?()