[Free] 2018(Jan) Dumps4cert Pass4sure IBM C2090-730 Dumps with VCE and PDF 21-30

By | February 3, 2018

Dumps4cert.com : Latest Dumps with PDF and VCE Files
2018 Jan IBM Official New Released C2090-730
100% Free Download! 100% Pass Guaranteed!
http://www.Dumps4cert.com/C2090-730.html

DB2 9 Family Fundamentals

Question No: 21

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#39;

SET MESSAGE_TEXT = ‘Deletes not allowed!#39;; Which of the following statements is NOT true?

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

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

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

  4. 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

Answer: D

Question No: 22

Which of the following is the lowest cost DB2 product that can be legally installed on a Windows server that has 2CPUs?

  1. DB2 Everyplace

  2. DB2 Express Edition

  3. DB2 Workgroup Server Edition

  4. DB2 Enterprise Server Edition

Answer: B

Question No: 23

Given thefollowing UPDATE statement: UPDATE employees SET workdept =

(SELECT deptno FROM department WHERE deptno = #39;A01#39;) WHERE workdept IS NULL

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

  1. The statement will fail because anUPDATE statement cannot contain a subquery.

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

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

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

Answer: B

Question No: 24

Given the following set of statements:

CREATE TABLE tab1 (col1 INTEGER, col2 CHAR(20)); COMMIT;

INSERT INTO tab1 VALUES (123, #39;Red#39;); INSERT INTO tab1 VALUES (456, #39;Yellow#39;);

SAVEPOINT s1 ON ROLLBACK RETAIN CURSORS; DELETE FROM tab1 WHERE col1 = 123;

INSERT INTO tab1 VALUES (789, #39;Blue#39;); ROLLBACK TO SAVEPOINT s1;

INSERT INTO tab1 VALUES (789, #39;Green#39;); UPDATE tab1 SET col2 =NULL WHERE col1 = 789; COMMIT;

Which of the following records would be returned by the following statement?

SELECT * FROM tab1

  1. COL1 COL2

    — —-

    123 Red

    456 Yellow

    2 record(s) selected.

  2. COL1 COL2

    — —

    456 Yellow

    1 record(s) selected.

  3. COL1 COL2

    — —

    123 Red

    456 Yellow

    789 –

    3 record(s) selected.

  4. COL1 COL2

— —

123 Red

456 Yellow

789 Green

3 record(s) selected.

Answer: C

Question No: 25

The following SQL statement:

DELETE FROM tab1 WHERE CURRENT OF csr1 WITH RR

Is used to perform which type of delete operation?

  1. Positioned

  2. Searched

  3. Embedded

  4. Dynamic

Answer: A

Question No: 26

Which of the following CREATE TABLE statements will NOT be successful?

  1. CREATE TABLE t1 (c1 XML NOT NULL UNIQUE, c2 INT)

  2. CREATE TABLE t1 (c1 XML NOT NULL, c2 CHAR(20))

  3. CREATE TABLE t1 (c1 XML CHECK (c1 IS VALIDATED), c2 INT)

  4. CREATE TABLE t1 (c1 XML, c2 XML)

Answer: A

Question No: 27

Whichof the following statements allows user USER1 to take the ability to create packages in a database named SAMPLE away from user USER2?

  1. REVOKE CONNECT ON DATABASE FROM user2

  2. REVOKE CREATETAB ON DATABASE FROM user2

  3. REVOKE BIND ON DATABASE FROM user2

  4. REVOKE BINDADD ON DATABASE FROM user2

Answer: D

Question No: 28

An alias can be an alternate name for which two of the following DB2 objects?

  1. Sequence

  2. Trigger

  3. View

  4. Schema

  5. Table

Answer: C,E

Question No: 29

Which of the following isNOT a characteristic of a data warehouse?

  1. Summarized queries that perform aggregations and joins

  2. Heterogeneous data sources

  3. Voluminous historical data

  4. Sub-second response time

Answer: D

Question No: 30

Which of the following tools can NOT be used to catalog a database?

  1. Control Center

  2. SQL Assist

  3. Configuration Assistant

  4. Command Line Processor

Answer: B

100% Dumps4cert Free Download!
Download Free Demo:C2090-730 Demo PDF
100% Dumps4cert Free Guaranteed!
C2090-730 Dumps

Dumps4cert ExamCollection Testking
Lowest Price Guarantee Yes No No
Up-to-Dated Yes No No
Real Questions Yes No No
Explanation Yes No No
PDF VCE Yes No No
Free VCE Simulator Yes No No
Instant Download Yes No No

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.