What is the effect of the AFTER LAST ROW clause in a stream statement?
What is the effect of the AFTER LAST ROW clause in a stream statement?
When will the language complier return both a warning and an error message?
When will the language complier return both a warning and an error message?
What will be the new value of jobdesc after the following UPDATE STATEMENT is executed?
The current value of the CHAR(13) column jobdesc is SQL/MX Expert. What will be the new value of
jobdesc after the following UPDATE STATEMENT is executed? UPDATE persnl.job SET jobesc = RPAD
(jobdesc, 1, ‘X’);
What will happen when the following query is executed?
What will happen when the following query is executed?
SELECT * FROM STREAM(quotes);
Which statement is true about the following mxic command?
Which statement is true about the following mxic command?
mxci>> control query default optimization_level ‘0’;
Which OSS command is used to compile the C program “sqlprog.sql”?
Which OSS command is used to compile the C program “sqlprog.sql”?
When must the declaration of a cursor include the FOR UPDATE OF clause?
When must the declaration of a cursor include the FOR UPDATE OF clause?
which file or table organization can TRA be used?
Reload Analyzer (TRA) can be used to determine if files or tables would benefit from being reloaded.
For which file or table organization can TRA be used?