当前分类： IBM(000-730)
问题：单选题Which of the following resources can be referenced in the LOCK statement?（）A RowB TableC ColumnD Table space...
查看答案
问题：单选题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...
问题：单选题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...
问题：单选题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...
问题：单选题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...
问题：单选题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 ...
问题：单选题How should the following UDF be invoked in order to convert US currency values stored in the EXPENSES table into Canadian currency?CREATE FUNCTION getratews11 ( country1 VARCHAR(100), country2 VARCHAR(100) ) RETURNS DOUBLE LANGUAGE SQL CONTAINS SQL EXT...
问题：单选题On which of the following database objects may the SELECT privilege be controlled?（）A SequenceB SchemaC GroupD View...
问题：单选题Which of the following will begin a new unit of work?（）A The CONNECT statementB The first FETCH of a cursorC The BEGIN TRANSACTION statementD The first executable SQL statement...
问题：单选题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 se...
问题：单选题Which of the following is a characteristic of a sequence?（）A A sequence will never generate duplicate valuesB The MAXVALUE of a sequence can be equal to the MINVALUEC It is not possible to create a sequence that generates a constant since the INCREMENT...
问题：单选题Which of the following are types of routine objects?（）A Package and functionB Function and userexitC Procedure and packageD Function and procedure...
问题：单选题Which of the following privileges permits a user to update the comment on a sequence?（）A CONTROLB UPDATEC USAGED ALTER...
问题：单选题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 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 is the main feature of an OLTP application?（）A Summarized queriesB Granular transactionsC Voluminous historical dataD Heterogeneous data sources...
问题：单选题An application needs a table for each connection that tracks the ID and Name of all items previously ordered and committed within the connection. The table also needs to be cleaned up and automatically removed each time a connection is ended. Assuming ...
问题：单选题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 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...
