问题:单选题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...
查看答案
问题:单选题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...
问题:单选题Application A is designed to execute the following SQL statements within a single Unit of Work (UOW). UPDATE employee SET salary = salary * 1.1 WHERE empno='000010' UPDATE department SET deptname = 'NEW dept' WHERE deptno='A00'Application B is designed...
问题:单选题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...
问题:单选题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...
问题:单选题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 resources can be referenced in the LOCK statement?()A RowB TableC ColumnD Table space...
问题:单选题Which of the following resources can be explicitly locked?()A RowB PageC TableD Column...
问题:单选题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 ...
问题:Consider the following table called EMPLOYEES: ID FIRSTNAME...
问题:单选题Which of the following is the lowest cost DB2 product that can be legally installed on an AIX server?()A DB2 Express EditionB DB2 Personal EditionC DB2 Workgroup Server EditionD DB2 Enterprise Server Edition...
问题:单选题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...
问题:单选题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 eliminates all but one of...
问题:单选题Which of the following are types of routine objects?()A Package and functionB Function and userexitC Procedure and packageD Function and procedure...
问题:单选题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 best describes the age of the data in an OLTP system?()A CurrentB ProjectedC HistoricalD Current and projected...
问题:单选题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 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...