PrepAway - Latest Free Exam Questions & Answers

What is the purpose of the following query?

What is the purpose of the following query? SELECT DBNAME, NAME FROM

SYSIBM.SYSTABLESPACE TS WHERE NOT EXISTS (SELECT TP.DBNAME, TP.TSNAME
FROM SYSIBM.SYSTABLEPART TP WHERE TP.DBNAME = TS.DBNAME AND TP.TSNAME =
TS.NAME);

PrepAway - Latest Free Exam Questions & Answers

A.
It displays the number of inconsistent rows in SYSIBM.SYSTABLESPACE.

B.
It identifies which tables do not have related rows in SYSIBM.SYSTABLEPART.

C.
It identifies which table spaces have missing related rows in SYSIBM.SYSTABLEPART.

D.
It displays which rows in SYSIBM.SYSTABLEPART do not have a matching table name in
SYSIBM.SYSTABLESPACE.

Explanation:


Leave a Reply