当前分类： IBM(000-730)
问题：单选题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 is the main feature of an OLTP application?（）A Summarized queriesB Granular transactionsC Voluminous historical dataD Heterogeneous data sources...
问题：单选题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...
问题：单选题A stored procedure object is created into which DB2 object?（）A AliasB SchemaC PackageD Routine Space...
问题：单选题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 ...
问题：单选题Which of the following resources can be referenced in the LOCK statement?（）A RowB TableC ColumnD Table space...
问题：单选题Which of the following statements allows BOB to revoke access to the SAMPLE database from user TOM?（）A REVOKE ACCESS ON DATABASE FROM USER bobB REVOKE CONNECT ON DATABASE FROM USER tomC REVOKE tom FROM ACCESS ON DATABASE BY USER bobD REVOKE tom FROM CO...
问题：单选题Which of the following resources can be explicitly locked?（）A RowB PageC TableD Column...
问题：单选题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 is a typical data warehouse query?（）A What is this customers address?B Does this customer have any unpaid bills?C What is the balance in this customers account?D What are the total sales for each of the last 6 months?...
问题：单选题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 executed...
问题：单选题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...
问题：单选题A table was created using the following DDL: CREATE TABLE employee (id SMALLINT NOT NULL, name VARCHAR(9), dept SMALLINT CHECK (dept BETWEEN 10 AND 100), job CHAR(10) CHECK (job IN ('Sales','Mgr','Clerk')), hiredate DATE, salary DECIMAL(7,2), comm DECI...
问题：单选题Given the following DDL for the PARTS table:CREATE TABLE parts (part_no INT(9) NOT NULL, part_name VARCHAR(24), part_remain INT(9));All part numbers entered will be different and all rows should be displayed in order of increasing part numbers whenever...
问题：单选题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 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...
问题：单选题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 is a characteristic of a schema?（）A Foreign key references cannot cross schema boundaries.B A DB2 user must be created before a schema with the same name can be created.C If no schema is specified when an object is created, the 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 describes the objects of a DB2 database and their relationships?（）A InstanceB Table spaceC System catalogD Schema repository...
