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;()
第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
第2题:
A.UDT
B.Trigger
C.Package
D.Access plan
第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.
第4题:
Which of the following commands should be used to show the percentage of time that any given disk was busy?()
第5题:
Which of the following statements is true regarding the VERSIONS BETWEEN clause?()
第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
第7题:
第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
第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?()
第10题:
Given the following code fragment: public void create() { Vector myVect; myVect = new Vector(); } Which of the following statements are true?()