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

The following statements: CREATE TABL


The following statements: CREATE TABLE t1 (col1 INT NOT NULL, PRIMARY KEY(col1)); CREATE TABLE t2 (col1 INT NOT NULL, col2 CHAR(1) NOT NULL, PRIMARY KEY (col1, col2), FOREIGN KEY (col1) REFERENCES t1 (col1) ON DELETE CASCADE ON UPDATE RESTRICT); CREATE TABLE t3 (col1 INT NOT NULL, col2 INT NOT NULL, PRIMARY KEY (col1, col2),FOREIGN KEY (col1) REFERENCES t1 (col1) ON DELETE NO ACTION ON UPDATE RESTRICT);INSERT INTO t1 VALUES (1), (2); INSERT INTO t2 VALUES (1, 'a'), (1, 'b'), (2,'c'); INSERT INTO t3 VALUES (1, 100), (2, 200), (2,300); How many rows will be deleted by the following DELETE statement? DELETE FROM t1 WHERE col1= 1;()

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

1、Which of the following statements can

Which of the following statements can best be inferred from the passage?A Fishes only "speak" to communicate with each other.B Researches are n...

2、Which of the following statements desc

Which of the following statements describes the functions of a reservoir used in a hydraulic system?()ADissipate heatBTrap foreign matterCSeparate air from the oilDAll of the above

3、Which of the following statements conc

Which of the following statements concerning fire-tube boilers is correct?()ACombustion gases flow through the tubesBFlames impinge on the tubesCCombustion occurs in the tubesDWater flows through the tube

4、Which of the following statement rela

Which of the following statement related to PMO is not correct?()AThe specific form, function, and structure of a PMO are dependent upon the...

5、Which of the following statements abou

Which of the following statements about authentication responses and conditions is true? ()(Choosetwo.)A When a router receives a failure respon...

6、Consider the following statement on a

Consider the following statement on a RANGE partitioned table: ALTER TABLE orders DROP PARTITION p1, p3;What is the outcome of executing the ab...