站内搜索
IBM(000-730) 问题列表
问题
单选题A view is created with the following statement:CREATE VIEW v1 AS SELECT col1, col2, col3 FROM t1 WHERE col4 1000 ; When will DB2 access the data from table T1 for view V1?（）A
When view V1 is createdB
Each time the REFRESH VIEW v1 statement is executedC
Each time an SQL statement is executed against view V1D
Only the first time an SQL statement is executed against view V1
问题
单选题Which of the following tools for DB2 V9 allows a user to create and debug a SQL stored procedure?（）A
Control CenterB
Development CenterC
Developer WorkbenchD
Stored Procedure Builder
问题
单选题Which of the following resources can be referenced in the LOCK statement?（）A
RowB
TableC
ColumnD
Table space
问题
单选题Consider the following table called EMPLOYEES: ID FIRSTNAME LASTNAME JOB LEVEL CLERK 3 If the following SQL statement is executed, how many rows will be deleted? DELETE FROM employees WHERE 1 = 1（）A
0B
1C
3D
6
问题
单选题Given the following function: CREATE FUNCTION emplist （ ） RETURNS TABLE ( id CHAR(6) , firstname VARCHAR(12) , lastname VARCHAR(15) ) LANGUAGE SQL BEGIN ATOMIC RETURN SELECT EMPNO, FIRSTNME, LASTNAME FROM EMPLOYEE WHERE WORKDEPT IN ('A00', 'B00'); END How can this function be used in an SQL statement?A
SELECT TABLE(EMPLIST()) FROM EMPLOYEEB
SELECT TABLE(EMPLIST()) AS t FROM EMPLOYEEC
SELECT EMPLIST(id, firstname, lastname) FROM EMPLOYEED
SELECT id, firstname, lastname FROM TABLE(EMPLIST()) AS t
问题
单选题Which of the following objects contains control structures that are considered the bound form of SQL statements?（）A
UDTB
TriggerC
PackageD
Access plan
问题
单选题Which kind of non-sourced UDF can be created so that it only returns a single value?（）A
RowB
TableC
ScalarD
Column
问题
单选题Which of the following is a feature of a unit of work?（）A
It applies to a single data server.B
It is a recoverable sequence of operations.C
Its value can be queried from the system catalog tables.D
It begins when the application connects to the data server.
问题
单选题A sequence was created with the DDL statement shown below:CREATE SEQUENCE my_seq START WITH 5 INCREMENT BY 5 CACHE 5 User1 successfully executes the following statements in Connection1: VALUES NEXT VALUE FOR my_seq INTO :con1hvar VALUES NEXT VALUE FOR my_seq INTO :con1hvar User2 successfully executes the following statement in Connection2: VALUES NEXT VALUE FOR my_seq INTO :con2hvar After User1 User2 are finished, User3 executes the following statement in Connection3: SELECT NEXT VALUE FOR my_seq FROM sysibm.sysdummy1Which value will be returned by the query?（）A
20B
25C
50D
55
问题
单选题Which of the following is TRUE for the DB2 isolation level Cursor Stability (CS)?（）A
An application process acquires at least a share lock on the current row of every cursor.B
Any row that is read during a unit of work cannot be changed by other application processes until the unit of work is complete.C
Any row changed by another application process can be read, even if the change has not been committed by that application process.D
An application process that issues the same query more than once in a unit of work will not see additional rows caused by other application processes appending new information to the database.
问题
单选题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
问题
单选题When a client using the SERVER_ENCRYPT authentication type connects to a server using the SERVER authentication type, what happens?（）A
An error will occur.B
Data passed between the client and the server is encrypted.C
User IDs and passwords are passed to the server unencrypted.D
User IDs and passwords are encrypted before they are passed to the server.
问题
单选题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
问题
单选题A UDT is a data type which:（）A
must contain unique values.B
cannot be CAST to other data types.C
is created using the CREATE DISTINCT command.D
contains a value that was automatically calculated from values in other columns.
问题
单选题Which of the following privileges permits a user to update the comment on a sequence?（）A
CONTROLB
UPDATEC
USAGED
ALTER