[单项选择]The following triggers were defined for table TAB1 in the order shown:CREATE TRIGGER trig_a AFTER UPDATE ON tab1 FOR EACH ROW UPDATE sale_tab SET sale_date = CURRENT DATE; CREATE TRIGGER trig_b AFTER UPDATE ON tab1 FOR EACH STATEMENT UPDATE invoice_tab SET invoice_date = CURRENT DATE; CREATE TRIGGER trig_c AFTER UPDATE ON tab1 FOR EACH ROW UPDATE shipping_tab SET ship_date = CURRENT DATE; CREATE TRIGGER trig_d AFTER UPDATE ON tab1 FOR EACH STATEMENT UPDATE billing_tab SETbilling_date = CURRENT DATE;If an event occurs that causes all of them to activate, which trigger will be activated first?（）
A. TRIG_A
B. TRIG_B
C. TRIG_C
D. TRIG_D

更多"The following triggers were defined"的相关试题:

[单项选择] 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

查看答案

[单项选择]Table TAB1 was created using the following statement: CREATE TABLE tab1 (c1 INT, c2 INT, c3 INT, c4 INT, c5 INT); If column C1 is unique and queries typically access columns C1, C2 and C3 together, which statement(s) will createindex(es) that will provide optimal query performance?（）
A. CREATE UNIQUE INDEX xtab1 ON tab1 (c1); CREATE INDEX xtab2 ON tab1 (c2) INCLUDE (c3)
B. CREATE UNIQUE INDEX xtab1 ON tab1 (c1) INCLUDE (c2, c3)
C. CREATE UNIQUE INDEX xtab1 ON tab1 (c3, c2, c1)
D. CREATE UNIQUE INDEX xtab1 ON tab1 (c2) INCLUDE (c1, c3)

查看答案

[单项选择]We looked for a table to sit down, but they were all ______.
A. reserved for
B. engaged in
C. used up
D. taken up

查看答案

[单项选择]在下列查询语句中，与SELECT TAB1．* FROM TAB1 WHERE InStr([简历]，"篮球")<>0 功能相同的语句是
A. SELECT TAB1．* FROM TAB1 WHERE TAB1．简历Like "篮球"
B. SELECT TAB1．* FROM TAB1 WHERE TAB1．简历Like "*篮球"
C. SELECT TAB1．* FROM TAB1 WHERE TAB1．简历Like "*篮球*"
D. SELECT TAB1．* FROM TAB1 WHERE TAB1．简历Like "篮球*"

查看答案

[单项选择] Given the following two tables: TAB1 C1 C2 1 Antarctica 2 Africa 3 Asia 4 Australia TAB2 CX CY 5 Europe 6 North America 7 South America Which of the following SQL statements will insert all rows found in table TAB2 into table TAB1?（）
A. INSERT INTO tab1 SELECT cx, cy FROM tab2
B. INSERT INTO tab1 VALUES (tab2.cx, tab2.cy)
C. INSERT INTO tab1 VALUES (SELECT cx, cy FROM tab2)
D. INSERT INTO tab1 (c1, c2) VALUES (SELECT cx, cy FROM tab2)

查看答案

[单项选择] Given the following two tables: TAB1 C1 C2 A 11 B 12 C 13 TAB2 CX CY A 21 C 22 D 23 The following results are desired: C1 C2 CX CY A 11 A 21 C 13 C 22 -- --D 23 Which of the following queries will yield the desired results?（）
A. SELECT * FROM tab1 INNER JOIN tab2 ON c1=cx
B. SELECT * FROM tab1 LEFT OUTER JOIN tab2 ON c1=cx
C. SELECT * FROM tab1 FULL OUTER JOIN tab2 ON c1=cx
D. SELECT * FROM tab1 RIGHT OUTER JOIN tab2 ON c1=cx

查看答案

[单项选择] Given the following two tables: TAB1 R1 A A A B B C C D E TAB2 R2 A A B B C C D Which of the following queries returns the following result set? RETVAL E（）
A. SELECT r1 AS retval FROM tab1 INTERSECT SELECT r2 AS retval FROM tab2
B. SELECT r1 AS retval FROM tab1 EXCEPT SELECT r2 AS retval FROM tab2
C. SELECT DISTINCT r1 AS retval FROM tab1, tab2 WHERE r1 <> r2
D. SELECT r1 AS retval FROM tab1 UNION SELECT r2 AS retval FROM tab2

查看答案

[单项选择]下列哪个语句将赋予用户John向表tab1中插入数据的权限？（）
A. GRANT ADD ON TABLE tab1 TO John
B. GRANT INSERT ON tab1 TO John
C. GRANT ADD ON TABLE tab1 TO USER John
D. GRANT INSERT ON TABLE tab1 TO USER John

查看答案

[单项选择] You own a table called EMPLOYEES with this table structure: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) HIRE_DATE DATE What happens when you execute this DELETE statement? DELETE employees;（）
A. You get an error because of a primary key violation.
B. The data and structure of the EMPLOYEES table are deleted.
C. The data in the EMPLOYEES table is deleted but not the structure.
D. You get an error because the statement is not syntactically correct.

查看答案

[单项选择]How is slang defined by the author
A. Words and phrases accepted by the majority for formal usage.
B. Words and phrases understood by the majority but not found in standard dictionaries.
C. Words and phrases that are understood by a restricted group of speakers.
D. Words and phrases understood by a large number of speakers but not accepted as formal us- age.

查看答案

[单项选择]After criminals were caught, they were accused and put to ______.
A. death
B. trial
C. torture
D. sentence

查看答案

[单项选择]你定义了一个对象类型myOBJ，要基于该类型来创建表tab1，语句为（）。
A. CREATE TABLE tab1 OF myOBJ
B. CREATE TABLE myOBJ OF tab1
C. CREATE TABLE tab1 AS myOBJ
D. CREATE TABLE tab1 TYPE OF myOBJ

查看答案

[单项选择]We were running out of money and things were looking ______.
A. grim
B. glossy
C. gorgeous
D. gracious

查看答案

[单项选择]Two were killed, but the others were only slightly injured in the two-car （）.
A. collision
B. conflict
C. contact
D. collapse

查看答案

我来回答:

提交