100% Pass Guarantee with IBM C2090-730 Dumps!

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;

B. 3

C. 1

D. 0

Given the following UPDATE statement:

UPDATE employees SET workdept =

(SELECT deptno FROM department WHERE deptno = 'A01') WHERE workdept IS NULL

Which of the following describes the result if this statement is executed?

A. The statement will fail because an UPDATE statement cannot contain asubquery.

B. The statement will only succeed if the data retrieved by thesubquery does not contain multiple records.

C. The statement will succeed; if the data retrieved by thesubquery contains multiple records, only the first record will be used to perform the update.

D. The statement will only succeed if every record in the EMPLOYEES table has a null value in the WORKDEPT column.

The following triggers were defined for a table named SALES in the order shown:

CREATE TRIGGER trigger_a NO CASCADE BEFORE UPDATE ON sales REFERENCING NEW AS new FOR EACH ROW SET new.commission = sale_amt * .05 WHERE invoice = n.invoice;

CREATE TRIGGER trigger_b AFTER INSERT ON sales REFERENCING NEW AS new FOR EACH ROW UPDATE sales SET bill_date = CURRENT DATE + 30 DAYS WHERE invoice = n.invoice;

CREATE TRIGGER trigger_c NO CASCADE BEFORE DELETE ON sales FOR EACH ROW SIGNAL SQLSTATE '75005' SET MESSAGE_TEXT = 'Deletes not allowed!';

Which of the following statements is NOT true?

A. Once a row has been added to the SALES table, it cannot be removed

B. Whenever a row is inserted into the SALES table, the value in the BILL_DATE column is automatically set to 30 days from today

C. Each time a row is inserted into the SALES table, trigger TRIGGER_A is fired first, followed by trigger TRIGGER_B

D. Whenever a row in the SALES table is updated, all three triggers are fired but nothing happens because none of the triggers have been coded to trap update operations