IBM(000-730)

单选题An Alias can be an alternate name for which DB2 object?()A SequenceB TriggerC SchemaD View

题目
单选题
An Alias can be an alternate name for which DB2 object?()
A

Sequence

B

Trigger

C

Schema

D

View

参考答案和解析
正确答案: D
解析: 暂无解析
如果没有搜索结果,请直接 联系老师 获取答案。
相似问题和答案

第1题:

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.


参考答案:D

第2题:

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.Table

B.Columns

C.Table and Alias

D.Columns and Alias


参考答案:A

第3题:

Which best describes an inline view? ()

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


参考答案:D

第4题:

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

答案:A
解析:

第5题:

An Alias can be an alternate name for which DB2 object?()

A.Sequence

B.Trigger

C.Schema

D.View


参考答案:D

第6题:

On which of the following database objects may the SELECT privilege be controlled?()

A.Sequence

B.Schema

C.Group

D.View


参考答案:D

第7题:

A stored procedure object is created into which DB2 object?()

A.Alias

B.Schema

C.Package

D.Routine Space


参考答案:B

第8题:

Which of the following database objects can be used to raise an error if a table is updated?()

A.Package

B.Trigger

C.Stored Procedure

D.Informational Constraint


参考答案:B

第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


参考答案:A

第10题:

Which object may be used during query optimization to improve the performance for a subset of SELECT queries?()

  • A、MQT
  • B、Trigger
  • C、Read Only Cursor
  • D、Stored Procedure

正确答案:A

更多相关问题