Given the following queries:
SELECT c1 FROM tab1; SELECT c1 FROM tab2;
Which of the following set operators can be used to produce a result data set that contains only records that are not found in the result data set produced by each query after duplicate rows have been eliminated?
A. UNIONWhich of the following is the lowest cost DB2 product that can be legally installed on a windows server that has 2 CPUs?
A. DB2 EveryplaceIn which of the following situations would DB2 retain resources associated with a transaction at COMMIT time?
A. A cursor is defined as WITH HOLD.A view is created with the following statement:
CREATE VIEW v1 AS SELECT col1, col2, col3 FROM t1 WHERE col4 > 1000 ;
When will DB2 access the data from table T1 for view V1?
A. When view V1 is createdThe 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;
A. 4Which of the following tasks can NOT be performed using the Developer Workbench?
A. Develop and debug an SQL stored procedureWhich of the following is a valid DB2 data type?
A. NUMBERGiven the following CREATE TABLE statement:
CREATE TABLE customer(custid INTEGER, info XML)
And the following INSERT statements:
INSERT INTO customer VALUES (1000,
'
');
INSERT INTO customer VALUES (1000,
'
');
What is the result of the following XQuery expression?
XQUERY declare default element namespace "http://custrecord.dat"; for $info in db2-fn:xmlcolumn ('CUSTOMER.INFO')/customerinfo where $info/addr/state-prov="Ontario" return $info/name/text();
A. Paul SmithWhich of the following causes a lock that is being held by an application using the Cursor Stability isolation level to be released?
A. The cursor is moved to another rowWhich of the following provides a logical grouping of database objects?
A. ViewNowadays, the certification exams become more and more important and required by more and more enterprises when applying for a job. But how to prepare for the exam effectively? How to prepare for the exam in a short time with less efforts? How to get a ideal result and how to find the most reliable resources? Here on Vcedump.com, you will find all the answers. Vcedump.com provide not only IBM exam questions, answers and explanations but also complete assistance on your exam preparation and certification application. If you are confused on your C2090-730 exam preparations and IBM certification application, do not hesitate to visit our Vcedump.com to find your solutions here.