可学答题网 > 问答 > IBM(000-730)题库
目录: 标题| 题干| 答案| 搜索| 相关
问题

Given the following statements: CREAT


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); What is the result of the following query? SELECT count(*) FROM tab2;()

  • A3
  • B2
  • C1
  • D0
参考答案
参考解析:
分类:IBM(000-730)题库
相关推荐

1、Given the following 

Given the following output what course of action should be undertaken for a long ...

2、Given the following requirements: Cre

Given the following requirements:Create a table to contain employee data, with a unique numeric identifier automatically assigned when a row is ...

3、Given the following table definitions

Given the following table definitions:EMPLOYEEID NAME DEPTID01Smith 1002Bossy 2003 20Peterson04Goss 3005Pape 4006Avery 5007O'Neal 6008Carter 50DEPA...

4、Given the following steps, which woul

Given the following steps, which would be the correct order to create a backup of an Oracle database in NOARCHIVELOG mode?()1.shutdown immedia...

5、Given the following 

Given the following six method names:(1)addListener(2)addMouseListener (3)setMouseListener(4)deleteMouseListener(5)rem...

6、Given the following ALTER SEQUENCE sta

Given the following ALTER SEQUENCE statement: ALTER SEQUENCE myseq RESTART WITH 0 INCREMENT BY 1 NO MAXVALUE CACHE 5 ORDER Assuming that the s...