What is the purpose of the following query? SELECT DBNAME, NAME FROMSYSIBM.SYSTABLESPACE TS WHERE NOT EXISTS (SELECT TP.
Posted: Fri Aug 26, 2022 9:58 am
What is the purpose of the following query? SELECT DBNAME, NAME FROMSYSIBM.SYSTABLESPACE TS WHERE NOT EXISTS (SELECT TP.DBNAME,TP.TSNAMEFROM SYSIBM.SYSTABLEPART TP WHERE TP.DBNAME = TS.DBNAMEAND TP.TSNAME = TS.NAME);
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 whichtable 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.
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 whichtable 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.