Monday, September 23, 2013

CHAPTER 1 (PLANNING) DB2 9 Exam 730 certification Dumps

The DB2 9 Fundamental exam(730) consists of 64 questions with time limit of 90 minutes.
It is sub divided into different sections as below with Percentage of questions from each chapter.
Chapter 1:  Planning (14%)
Chapter 2:  Security (11%)
Chapter3:   Working with Databases and Database Objects(17%)
Chapter4:   Working with DB2 data using SQL and Xquery(23.5%)
Chapter5:   Working with DB2 Tables,Views and Indexes( 23.5%)
Chapter6:   Concurrency(11%).
730 CERTIFICATION GUIDE


CHAPTER 1 - PRACTICE QUESTIONS


Q)Which of the following is the lowest cost DB2 product that can be legally installed on
a Windows server that has 2 CPUs?
A. DB2 Everyplace
B. DB2 Express Edition
C. DB2 Workgroup Server Edition
D. DB2Enterprise Server Edition

Q)Which of the following is the lowest cost DB2 product that can be legally installed on an HP-UX server?
A. DB2 Express-C
B. DB2 Express
C. DB2 Personal Edition
D. DB2 Enterprise Server Edition

Q)Which of the following DB2 products can only be installed on a System i server?
A. DB2 for z/OS
B. DB2 for i5/OS
C. DB2 Data Warehouse Edition
D. DB2 Enterprise Server Edition

 
Q)What is the purpose of the Design Advisor?
A. To analyze workloads and make recommendations for indexes and MQTs
B. To present a graphical representation of a data access plan and recommend
    design changes that will improve performance
C. To replicate data between a DB2 database and another relational database
D. To configure clients so they can access databases stored on remote servers

Q)Which of the following DB2 tools allows a user to set DB2 registry parameters?
A. Task Center
B. Visual Explain
C. Configuration Assistant
D. Satellite Administration Center

Q)What is the SQL Performance Monitor used for?
A. To examine the health of a DB2 Database Manager instance
B. To visually construct complex DML statements and examine the results of
     their execution
C. To schedule tasks, run tasks, and send notifications about completed tasks to other    users
D. To analyze database operations performed against a DB2 for i5/OS database

Q)Which of the following tasks can NOT be performed using the Developer Workbench?
A. Develop and debug an SQL stored procedure
B. Develop and debug a user-defined data type
C. Develop and debug a user-defined function
D. Develop and run XML queries

Which of the following tools can be used to automate table reorganization operations?
A. Control Center
B. Command Center
C. Command Line Processor
D. Task Center

Q)Which of the following can be viewed with the Journal?
A. Historical information about tasks, database changes, messages, and notifications
B. Information about licenses associated with each DB2 9 product installed on a particular system
C. Graphical representations of data access plans chosen for SQL statements
D. Warning and alarm thresholds for database indicators

Q)Which of the following is NOT a characteristic of an OLTP database?
A. Granular transactions
B. Current data
C. Optimized for queries
D. Frequent updates

Q)Which of the following products is used to shred extensible markup language documents?
A. DB2 AVI Extender
B. DB2 Text Extender
C. DB2 XML Extender
D. DB2 Spatial Extender

Q)Which of the following best describes the difference between the DB2 Spatial Extender and the DB2 Geodetic Extender?
A. The DB2 Spatial Extender uses a latitude-longitude coordinate system; the DB2 Geodetic Extender uses a planar, x- and y-coordinate system
B. The DB2 Geodetic Extender is used to describe points, lines, and polygons; the DB2 Spatial Extender is used to find area, endpoints, and intersects
C. The DB2 Spatial Extender treats the world as a flat map; the DB2 Geodetic Extender treats the world as a round globe
D. The DB2 Geodetic Extender can be used to manage information like the locations of office buildings or the size of a flood zone; the DB2 Spatial Extender can be used for calculations and visualizations in disciplines like military command/control and asset management, meteorology and oceanography

Q)Which of the following is true about XML columns?
A. XML columns are used to store XML documents as a hierarchical set of entities
B. Only XQuery can be used to retrieve an XML document from an XML column
C. XML columns must be altered to accommodate additional parent/child relationships if they are used in referential constraints
D. In order to access any portion of an XML document stored in an XML column, the entire document must be retrieved

Q)Which of the following is the major difference between relational data and XML data?
A. Relational data is self-describing; XML data is not
B. Relational data has inherent ordering; XML data does not
C. Relational data must be tabular; XML data does not have to be tabular
D. Relational data is comprised of entities; XML data is comprised of numbers, characters, and dates

Q)Which of the following products is allowed to access other DB2 servers, but cannot accept requests from other remote clients?
A. DB2 Personal Edition
B. DB2 Workgroup Server Edition
C. DB2 Enterprise Server Edition
D. DB2 Data Warehouse Edition

Q)A client application on z/OS must access a DB2 database on a Solaris Server. At a minimum, which of the following products must be installed on the Solaris workstation?
A. DB2 Connect Enterprise Edition
B. DB2 Workgroup Server Edition
C. DB2 Workgroup Server Edition and DB2 Connect Enterprise Edition
D. DB2 Enterprise Server Edition and DB2 Connect Enterprise Edition

Q)Which of the following is used to create and debug user-defined functions?
A. SQL Assist
B. Control Center
C. Command Editor
D. Developer Workbench

Q)Which two of the following allow you to perform administrative tasks against database objects?
A. Control Center
B. Journal
C. Command Line Processor
D. Task Center
E. Health Center

Q)Which of the following is NOT a characteristic of a data warehouse?
A. Summarized queries that perform aggregations and joins
B. Heterogeneous data sources
C. Voluminous historical data
D. Sub-second response time



Monday, September 9, 2013

Different forms of INSPECT clause in cobol

Below are the different INSPECT with REPLACE clause and their usage in cobol.

INSPECT WS-TEXT      REPLACING ALL LOW-VALUES BY SPACE
INSPECT WS-TEXT      REPLACING ALL ' ' BY '0'
INSPECT WS-TEXT      REPLACING ALL LOW-VALUES BY SPACES
INSPECT WS-TEXT      REPLACING FIRST '*' BY '%'
INSPECT WS-TEXT      REPLACING ALL '~' BY WS-INSPECT-VAL
INSPECT WS-TEXT      REPLACING ALL WS-INSPECT-VAL  BY '('
INSPECT WS-TEXT      REPLACING ALL  '('   BY    ')'     AFTER INITIAL '('

**
01 VAR-STRING PIC X(20) VALUE 'THIS IS COBOL'.
01 VAR-COUNT PIC 9(2).

INSPECT VAR-STRING TALLYING VAR-COUNT FOR ALL 'S'
O/P : VAR-COUNT = 2
**
VAR-STRING = "THIS IS COBOL"
INSPECT VAR-STRING TALLYING VAR-COUNG FOR ALL "S" AFTER INITIAL SPACE.

O/P : VAR-COUNT = 1 (Since first 'S' wont be counted . All the 'S' after the first space will be counted.)
**
VAR-STRING = "MY COBOL PROGRAMMING COURSE"
INSPECT VAR-STRING TALLYING VAR-COUNT FOR ALL LEADING 'M'

O/P : VAR-COUNT = 1 (ONLY THE FIRST 'M' WILL BE TAKEN INTO ACCOUNT)
**
01 WS-INPUT3='PTEST'
INSPECT WS-INPUT3 CONVERTING 'PTHASI' TO '3090RI'.
O/P:  30ES0
The exact number of characters need to be compared and mapped. Also duplicate is not
allowed in the parameters.
ex: INSPECT WS-INPUT3 CONVERTING 'PTPTSI' TO '3090RI' will result in error
because 'P' and 'T' is duplicated.
**