Home > Articles > Data > DB2

  • Print
  • + Share This
This chapter is from the book

Review Questions

  1. Which IBM tool 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. When would you choose to use CLPPlus over CLP?
  7. Which tool can be used to develop SQL user-defined functions?
  8. Can the IBM Data Studio be used to perform database development for DB2 for i 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 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 Line Processor Plus
  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. In which function of the IBM Data Studio would you be able to view a data access explain plan visually?

    1. Configure Automatic Maintenance editor
    2. IBM Data Studio Web Console
    3. SQL and XQuery Editor
    4. Query Tuner Workflow Assistant
  15. Which of the followings are tasks of the IBM Data Studio Web Console?

    1. View alerts
    2. Manage database jobs
    3. View data access plan graphs
    4. Deploy and debug stored procedures
    5. Manage data connection profiles
  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 following commands 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
  • + Share This
  • 🔖 Save To Your Account