Given the following statements:

题目

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;()

  • A、3
  • B、2
  • C、1
  • D、0
如果没有搜索结果或未解决您的问题,请直接 联系老师 获取答案。
相似问题和答案

第1题:

Given the following DDL and INSERT statements:CREATE VIEW v1 AS SELECT col1 FROM t1 WHERE col1 > 10; CREATE VIEW v2 AS SELECT col1 FROM v1 WITH CASCADED CHECK OPTION; CREATE VIEW v3 AS SELECT col1 FROM v2 WHERE col1 < 100; INSERT INTO v1 VALUES(5); INSERT INTO v2 VALUES(5); INSERT INTO v3 VALUES(20); INSERT INTO v3 VALUES(100);How many of these INSERT statements will be successful?()

A.0

B.1

C.2

D.3


参考答案:C

第2题:

Which of the following objects contains control structures that are considered the bound form of SQL statements?()

A.UDT

B.Trigger

C.Package

D.Access plan


参考答案:C

第3题:

Which of the following statements about the situational-behavioral interview are true?

A.The interviewees need use STAR model or structure to specify their past behaviors in a given situation.

B.The interviewees should consider the three steps or elements of STAR as a whole.

C.The interviewees are required to predict how they would perform. in a work-related task.

D.The interviewees are asked to describe how the job needs to be accomplished in real situations.


参考答案:A、B

第4题:

Which of the following commands should be used to show the percentage of time that any given disk was busy?()

  • A、 ps
  • B、 tprof
  • C、 iostat
  • D、 vmstat

正确答案:C

第5题:

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

第6题:

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;()

A.3

B.2

C.1

D.0


参考答案:D

第7题:

Which of the following statements is NOT a way of consolidating vocabulary

A.Defining.
B.Matching.
C.Gapfilling.
D.Labeling.

答案:A
解析:
考查词汇教学。

下定义是呈现新词汇的方法,而不是巩固已学词汇的方法。故此题的正确选项为A。

B、C、D均属于巩固词汇的方法。

故此题的正确选项为A。

第8题:

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


正确答案:B

第9题:

Which of the following commands should be used to monitor the number of threads on the scheduler’s run queue for any given interval?()

  • A、 sar
  • B、 pstat
  • C、 iostat
  • D、 filemon

正确答案:A

第10题:

Given the following code fragment:     public void create() {     Vector myVect;     myVect = new Vector();      }  Which of the following statements are true?() 

  • A、 The declaration on line 2 does not allocate memory space for the variable myVect.
  • B、 The declaration on line 2 allocates memory space for a reference to a Vector object.
  • C、 The statement on line 2 creates an object of class Vector.
  • D、 The statement on line 3 creates an object of class Vector.
  • E、 The statement on line 3 allocates memory space for an object of class Vector.

正确答案:A,D,E

更多相关问题