IBM认证考试
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 T
题目
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;（）
- A、4
- B、3
- C、1
- D、0
相似问题和答案
第1题：
19 Which of the following statements about intangible assets in company financial statements are correct according
to international accounting standards?
1 Internally generated goodwill should not be capitalised.
2 Purchased goodwill should normally be amortised through the income statement.
3 Development expenditure must be capitalised if certain conditions are met.
A 1 and 3 only
B 1 and 2 only
C 2 and 3 only
D All three statements are correct
第2题：
SQL命令中建立表的命令是______。
A．CREAT VIEW
B．CREAT LABEL
C．CREAT DABATE
D．CREAT TABLE
第3题：
All of the following statements define the role of a meeting chairperson except:
A Initiates and concludes discussion
B Controls irrelevant discussion
C Resolves strong disagreements
D Produces meeting agenda
E Consolidates agreements.
第4题：
Which of the following statements is true regarding the VERSIONS BETWEEN clause？（）
- A、 The VERSIONS BETWEEN clause may be used in DML statements.
- B、 The VERSIONS BETWEEN clause may be used in DDL statements.
- C、 The VERSIONS BETWEEN clause may not be used to query past DDL changes to tables.
- D、 The VERSIONS BETWEEN clause may not be used to query past DML statements to tables.
正确答案:C
第5题：
B.Matching.
C.Gapfilling.
D.Labeling.
下定义是呈现新词汇的方法，而不是巩固已学词汇的方法。故此题的正确选项为A。
B、C、D均属于巩固词汇的方法。
故此题的正确选项为A。
第6题：
12 Which of the following statements are correct?
(1) Contingent assets are included as assets in financial statements if it is probable that they will arise.
(2) Contingent liabilities must be provided for in financial statements if it is probable that they will arise.
(3) Details of all adjusting events after the balance sheet date must be given in notes to the financial statements.
(4) Material non-adjusting events are disclosed by note in the financial statements.
A 1 and 2
B 2 and 4
C 3 and 4
D 1 and 3
第7题：
A.UDT
B.Trigger
C.Package
D.Access plan
第8题：
Which of the following statements about Leopold and Rudolph Blaschka is TRUE?
A. They were brothers.
B. They were artists.
C. They were florists.
D. They were farmers.
32．答案为B。根据第一段最后一句，the work of two artists-naturalists，Leopold Blaschka and his son Rudolph作出该项选择。
第9题：
在Cisco路由器中增加用户的命令，错误的是（）。
- A、creat user
- B、adduser
- C、useradd
- D、user…password
- E、user creat
正确答案:A,B,C,E
第10题：
Consider the Mysql Enterprise Audit plugin. A CSV file called data.csv has 100 rows of data. The stored procedure prepare_db ( ) has 10 auditable statements. You run the following statements in the mydb database: Mysql＞ CALL prepare_db ( ); Mysql＞ LOAD DATA INFILE '/tmp/data.cav' INTO TABLE mytable; Mysql＞ SHOW TABLES; How many events are added to the audit log as a result of the preceding statements?（）
- A、12; only top-level statements and stored procedure events are logged
- B、111; top-level statements and all lower-level statements are logged
- C、3; only the top-level statements are logged
- D、102; top-level statements are logged, but LOAD DATA INFILE is logged as a separate event
正确答案:C