Which result do you get from the SELECT SESSION statement ?
A. the SQLFLAG value for the user
B. the session number for the user
C. the session transaction mode for the user
D. the number of sessions running for the user
Which information does HELP TABLE <tablename> provide about the specified table?
A. column name, data type, and comment
B. column name, index, data type, and comment
C. column name, table id, data type, and comment
D. column name, constraint, data type, and comment
Consider this request in Teradata mode: DELETE t1; Which request performs equivalently
in ANSI mode?
A. DROP TABLE t1;
B. DELETE FROM t1;
C. DELETE FROM t1 ALL;
D. DELETE FROM t1; COMMIT;
What does the EXPLAIN output provide to assist the user in query analysis? (Choose two.)
A. which steps may be processed in parallel
B. what statistics should be collected on a column
C. accurate time measurements for query processing
D. details of which indexes, if any, wil be used to process the query
E. recommendations to improve the query based on timing and sizing