当前分类： IBM(000-730)
问题：单选题Which of the following are types of routine objects?（）A Package and functionB Function and userexitC Procedure and packageD Function and procedure...
查看答案
问题：单选题If DB2 detects a deadlock between application A and application B (each waiting for a lock held by the other one), what action will DB2 take?（）A Rollback the transaction in both applications.B Rollback the transaction in one of the two applications.C D...
问题：单选题Given the following two tables: TAB1 C1 C2 A 11 B 12 C 13 TAB2 CX CY A 21 C 22 D 23 The following results are desired: C1 C2 CX CY A 11 A 21 C 13 C 22 -- --D 23 Which of the following queries will yield the desired results?（）A SELECT * FROM tab1 INNER ...
问题：单选题Which of the following DB2 objects are publicly referenced names that require no special authority or privilege to use them?（）A ViewB AliasC TableD Package...
问题：单选题Which of the following database objects is considered executable using SQL?（）A ViewB TableC RoutineD Package...
问题：单选题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...
问题：单选题Assuming PUBLIC has been granted all privileges on table T1, which of the following statements would continue to permit any user to add rows to table T1, but not remove them?（）A REVOKE DROP ON t1 FROM PUBLICB REVOKE UPDATE ON t1 FROM PUBLICC REVOKE DEL...
问题：单选题Which of the following resources can be referenced in the LOCK statement?（）A RowB TableC ColumnD Table 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 ...
问题：单选题What type of constraint is used to ensure that each row inserted into the EMPLOYEE table with a value in the WORKDEPT column has a row with a corresponding value in the DEPTNO column of the DEPARTMENT table?（）A A check constraint on the EMPLOYEE tableB...
问题：单选题A stored procedure object is created into which DB2 object?（）A AliasB SchemaC PackageD Routine Space...
问题：单选题A view is created with the following statement:CREATE VIEW v1 AS SELECT col1, col2, col3, col4 FROM t1 WHERE col4 1000 WITH CHECK OPTIONWhat is the effect of the CHECK OPTION clause?（）A Any row inserted or updated through view V1 must meet the conditi...
问题：单选题Which of the following statements is used to revoke all DML privileges on table EMPLOYEE from user TOM?（）A REVOKE ALL PRIVILEGES FROM USER tomB REVOKE ALL ON EMPLOYEE FROM USER tomC REVOKE EXECUTE ON EMPLOYEE FROM USER tomD REVOKE PRIVILEGES ON EMPLOYE...
问题：单选题Which of the following best describes the lock protection provided by DB2 for the current row of a cursor?（）A The cursor is only protected from updates and deletes by concurrent applications.B The row is only protected from positioned updates and delet...
问题：单选题Which of the following statements is used to grant user TOM and Application team APPGRP the ability to add data to table TAB1?（）A GRANT ADD DATA ON TABLE tab1 TO GROUP tom appgrpB GRANT INSERT TO USER tom, GROUP appgrp ON TABLE tab1C GRANT INSERT ON TA...
问题：单选题Which of the following is the main feature of an OLTP application?（）A Summarized queriesB Granular transactionsC Voluminous historical dataD Heterogeneous data sources...
问题：单选题Which product must be installed on z/OS to allow a COBOL program running on that machine to access data on a remote DB2 for z/OS server?（）A DB2 for z/OSB DB2 Run-Time Client for z/OSC DB2 Connect Enterprise Edition for z/OSD z/OS Application Connectivi...
问题：单选题Given the following tables: CONTINENTS ID NAME COUNTRIES 1 Antarctica 0 2 Africa 53 3 Asia 47 4 Australia 14 5 Europe 43 6 North America 23 7 South America 12 REGION ID LOCATION 1 East 2 West How many rows would be returned using the following statemen...
问题：单选题When defining a referential constraint between the parent table T2 and the dependent table T1, which of the following is true?（）A The list of column names in the FOREIGN KEY clause can be a subset of the list of column names in the primary key of T2 or...
