当前分类： IBM(000-730)
问题：单选题Which of the following describes the objects of a DB2 database and their relationships?（）A InstanceB Table spaceC System catalogD Schema repository...
查看答案
问题：单选题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 are types of routine objects?（）A Package and functionB Function and userexitC Procedure and packageD Function and procedure...
问题：单选题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...
问题：单选题The following triggers were defined for table TAB1 in the order shown:CREATE TRIGGER trig_a AFTER UPDATE ON tab1 FOR EACH ROW UPDATE sale_tab SET sale_date = CURRENT DATE; CREATE TRIGGER trig_b AFTER UPDATE ON tab1 FOR EACH STATEMENT UPDATE invoice_tab...
问题：单选题Given the following statements: CREATE TABLE tab1 (col1 INT); CREATE TABLE tab2 (col1 INT); CREATE TRIGGER trig1 AFTER UPDATE ON tab1 REFERENCING NEW AS new1 FOR EACH ROW MODE DB2SQL INSERT INTO tab2 VALUES(new1.col1); INSERT INTO tab1 VALUES(2),(3); W...
问题：单选题Which of the following tools is used to view historical information about tasks, database changes, messages, and notifications?（）A JournalB Task CenterC Control CenterD Activity Monitor...
问题：单选题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 DB2 tools allows a user to execute an SQL statement and view a graphical representation of the access plan?（）A Task CenterB Command EditorC Developer WorkbenchD Command Line Processor...
问题：单选题Given the following table definition: STOCK: item VARCHAR(30) status CHAR(1) quantity INT price DEC(7,2) If items are indicated to be out of stock by setting STATUS to NULL and QUANTITY and PRICE to zero, which of the following statements would be used...
问题：单选题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 ...
问题：单选题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...
问题：单选题Which of the following is the main feature of an OLTP application?（）A Summarized queriesB Granular transactionsC Voluminous historical dataD Heterogeneous data sources...
问题：单选题Which of the following resources can be referenced in the LOCK statement?（）A RowB TableC ColumnD Table space...
问题：单选题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 statements is used to prevent user TOM from adding and deleting data in table TAB1?（）A REVOKE ADD, DELETE FROM USER tom ON TABLE tab1B REVOKE ADD, DELETE ON TABLE tab1 FROM USER tomC REVOKE INSERT, DELETE FROM USER tom ON TABLE t...
问题：单选题A user needs to create a trigger that will update table T2 whenever a row is added to table T1. Assuming the user has all appropriate privileges for table T2, which privilege is required on table T1 to create the trigger?（）A REFERENCESB SELECTC UPDATED...
问题：单选题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...
