| 1: | Which of the DB2 tools can be used to schedule SQL scripts in DB2? |
| 2: | The DB2 Command Window is only available on Windows. What is the equivalent tool on the Linux/UNIX platforms? |
| 3: | Which registry variable needs to be changed to set autocommit to off permanently for the CLP? |
| 4: | When is it handy to start the CLP in interactive mode with a different terminator character as in db2 -td!? |
| 5: | Which command is necessary to guarantee the CLP back-end process is terminated? |
| 6: | How can Visual Explain be invoked? |
| 7: | Which tool can be used to develop SQL user-defined functions? |
| 8: | Can the Control Center be used to administer DB2 for iSeries databases? |
| 9: | It's 9:00 a.m. and you would like to investigate a problem that happened at 3:00 a.m. Where do you look for more information? |
| 10: | How can you obtain the most current information about a given DB2 topic? |
| 11: | Which two of the following tools can be used to execute SQL statements against a DB2 database? Command Window Command Editor Command Line Processor Command Processor db2cc
|
| 12: | Which of the following is the default termination character for files processed by the DB2 CLP? : ; | $
|
| 13: | If you have the following CLP input file named samp.sql, how many commits will occur during the processing of the db2 tvf samp.sql command? connect to sample; select * from org; select * from dept; connect reset;
0 1 2 3 4
|
| 14: | The Health Center will alert you when: A row is deleted from a table You run the load tool You exceed a defined threshold on performance characteristics An SQL statement fails because of incorrect syntax
|
| 15: | Which of the following tools will give you information about the memory used by DB2 and your DB2 applications? db2memlist Memory Visualizer db2mv Memory Center db2mtrk
|
| 16: | If you have the following CLP input file named samp.sql, how many commits will occur during the processing of the db2 +c tvf samp.sql command? connect to sample; select * from org; select * from dept;
0 1 2 3 4
|
| 17: | If you have the following CLP input file named samp.sql, which of the commands below will run this file successfully? connect to sample@ select * from org@ select * from dept@ connect reset@
db2 t@f samp.sql db2 -td@ -f samp.sql db2 -t@ -f samp.sql db2 -td@f samp.sql
|
| 18: | If your application receives the SQL code -911, which of the following commands can be used to get its description? db2 ? -911 db2 ? 911N db2 ? SQL-911 db2 ? SQL911N
|
| 19: | Which of the following commands cannot be run from the CLP in interactive mode? History Edit Runcmd Repeat
|
| 20: | Which two of the following can be performed from the CLP in interactive mode? db2 ? SQL911N db2stop list applications select * from staff
|
