Section 4.12. Review Questions


4.12. Review Questions

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?

  1. Command Window

  2. Command Editor

  3. Command Line Processor

  4. Command Processor

  5. db2cc

12:

Which of the following is the default termination character for files processed by the DB2 CLP?

  1. :

  2. ;

  3. |

  4. $

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; 

  1. 0

  2. 1

  3. 2

  4. 3

  5. 4

14:

The Health Center will alert you when:

  1. A row is deleted from a table

  2. You run the load tool

  3. You exceed a defined threshold on performance characteristics

  4. 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?

  1. db2memlist

  2. Memory Visualizer

  3. db2mv

  4. Memory Center

  5. 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; 

  1. 0

  2. 1

  3. 2

  4. 3

  5. 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@ 

  1. db2 t@f samp.sql

  2. db2 -td@ -f samp.sql

  3. db2 -t@ -f samp.sql

  4. 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?

  1. db2 ? -911

  2. db2 ? 911N

  3. db2 ? SQL-911

  4. db2 ? SQL911N

19:

Which of the following commands cannot be run from the CLP in interactive mode?

  1. History

  2. Edit

  3. Runcmd

  4. Repeat

20:

Which two of the following can be performed from the CLP in interactive mode?

  1. db2 ? SQL911N

  2. db2stop

  3. list applications

  4. select * from staff



Understanding DB2(R. Learning Visually with Examples)
Understanding DB2: Learning Visually with Examples (2nd Edition)
ISBN: 0131580183
EAN: 2147483647
Year: 2004
Pages: 313

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net