Learning Visually with Examples [Electronic resources]

Raul F. Chong, Clara Liu, Sylvia F. Qi, Dwaine R. Snow

نسخه متنی -صفحه : 312/ 68
نمايش فراداده

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