问题：单选题Which of the following are all valid DB2 data types?（）A LONG VARCHAR, SMALLINT, NUMBER, BLOBB DECIMAL, DATE, DBCLOB, INTERVALC NUMERIC, TIMESTAMP, BYTE, FLOATD NUM, TIME, XML, DOUBLE...
查看答案
问题：单选题To which of the following resources can a lock be applied?（）A RowB AliasC BitmapD Column...
问题：单选题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 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 resources can be referenced in the LOCK statement?（）A RowB TableC ColumnD Table space...
问题：单选题Given the following two tables: TAB1 C1 C2 1 Antarctica 2 Africa 3 Asia 4 Australia TAB2 CX CY 5 Europe 6 North America 7 South America Which of the following SQL statements will insert all rows found in table TAB2 into table TAB1?（）A INSERT INTO tab1 ...
问题：单选题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 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 are types of routine objects?（）A Package and functionB Function and userexitC Procedure and packageD Function and procedure...
问题：单选题Which kind of non-sourced UDF can be created so that it only returns a single value?（）A RowB TableC ScalarD Column...
问题：单选题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 ...
问题：单选题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 commands is used to retrieve database names from the local catalog for DRDA host databases on System i and System z?（）A LIST DB DIRECTORYB LIST DCS DIRECTORYC LIST NODE DIRECTORYD LIST ACTIVE DATABASES...
问题：单选题Which of the following objects contains control structures that are considered the bound form of SQL statements?（）A UDTB TriggerC PackageD Access plan...
问题：单选题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 TableB ColumnsC Table and AliasD Columns and Alias...
问题：单选题Which of the following statements allows USER1 to take away read access on the table ORG.TAB1 from USER2?（）A REVOKE SELECT FROM user2 ON TABLE org.tab1B REVOKE SELECT ON TABLE org.tab1 FROM user2C REVOKE READ ACCESS FROM user2 ON TABLE org.tab1D REVOKE...
问题：单选题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 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...
问题：单选题What is the maximum size that can be specified when creating an XML column in a DB2 table?（）A No size is specifiedB The buffer pool sizeC The page size for the table spaceD The extent size for the table space...
