AllExam Dumps

DUMPS, FREE DUMPS, VCP5 DUMPS| VMWARE DUMPS, VCP DUMPS, VCP4 DUMPS, VCAP DUMPS, VCDX DUMPS, CISCO DUMPS, CCNA, CCNA DUMPS, CCNP DUMPS, CCIE DUMPS, ITIL, EXIN DUMPS,


READ Free Dumps For IBM- 000-611





Question ID 19947

If an MQT named Q1_SALES was created as follows:

Which statement will execute successfully?

Option A

DELETE FROM q1_sales

Option B

REFRESH TABLE q1_sales

Option C

INSERT INTO q1_sales VALUES(80.2)

Option D

ALTER TABLE q1_sales REFRESH IMMEDIATE

Correct Answer B
Explanation


Question ID 19948

Table TAB1 was created as follows:

Which statement(s) should be used to create an index on column COL1 of table TAB1 that is enabled for
compression?

Option A

CREATE INDEX tab1_idx ON tab1(col1);

Option B

CREATE INDEX tab1_idx ON tab1(col1);ALTER INDEX tab1_idx COMPRESS YES;

Option C

CREATE INDEX tab1_idx ON tab1(col1);REORG INDEX tab1_idx FOR TABLE tab1;

Option D

CREATE INDEX tab1_idx ON tab1(col1);ALTER INDEX tab1_idx COMPRESS YES;REORG INDEX
tab1_idx FOR TABLE tab1;

Correct Answer A
Explanation

Send email to admin@getfreedumps for new dumps request!!!