Dan Zhang

Greenhorn
+ Follow
since Feb 17, 2005
Cows and Likes
Cows
Total received
0
In last 30 days
0
Total given
0
Likes
Total received
0
Received in last 30 days
0
Total given
0
Given in last 30 days
0
Forums and Threads
Scavenger Hunt
expand Ranch Hand Scavenger Hunt
expand Greenhorn Scavenger Hunt

Recent posts by Dan Zhang

Thanks Francivalb Lima !!

That's very helpful.

-----------
Hi Bala Ram:

Maybe I can help you a little.
I am a college student in China. I have no any working experience on DB2. I want to gain some database certifications, so I learn DB2.

I just study DB2 2 months and read some books earnest.

1) DB2� Universal Database� v8 for Linux�, UNIX�, and Windows� Database Administration Certification Guide, 5th Edition (2 times)
2)IBM DB2-701 tutorial (1 time)
3)A Chinese Book of DB2 (I forget the name. 1 time)
4)A Chinese flash demo from IBM's Chinese web. (1 time)
5)Using DB2-UDB everyday.
6)Last week , I did some sample tests.

I don't think it is difficult for people who are prepared.I can pass this book by email. If you know Chinese I also can pass the flash demo.

Good Luck!

My email:
Bsspirit@gmail.com
Hi All,
Could you please provide info on "IBM DB2 703 Exam" Sample Questions/Mock test?
21.Which of the following allows index data to be stored on separate devices from table data?
A.DMS table spaces
B.SMS table spaces
C.The table space containers defined on different devices
D.A DMS table space for the index data and an SMS table space for the user data
A


22.Given the following statement:
CREATE TABLESPACE dms1 MANAGED BY DATABASE USING
(FILE 'dms01' 1024K)
How many pages will be created for the table space?
A.128
B.256
C.512
D.1024
B
23.Given that there are two containers in table space TS1 and the following statement:
ALTER TABLESPACE ts1
REDUCE (ALL 100 M)
Which of the following describes the result of the statement?
A.The total size of table space TS1 will be reduced to 100 MB.
B.Each container in table space TS1 will be reduced in size to 100 MB.
C.Each container in table space TS1 will be reduced in size by 100 MB.
D.Each container in table space TS1 that has no data will be reduced in size to 100 MB.
E.Each container in table space TS1 that has no data will be reduced in size by 100 MB.
C

24.A DBA has created three related backup tasks in the Task Center. Which of the following tools can be used to edit the tasks?
A.Journal
B.Command Center
C.Control Center
D.Development Center
B
25.Given the following table definitions:
CANDIDATE
---------
CandidateName CHAR(20) NOT NULL
CandidateID INTEGER NOT NULL
Address CHAR(100) NOT NULL
CandidatePhoto BLOB(1M)

TEST_TAKEN
----------
TestName CHAR(50) NOT NULL
TestNumber INTEGER NOT NULL
TestScore INTEGER NOT NULL
CandidateID INTEGER NOT NULL
And the following information:
� Candidate IDs are unique in the CANDIDATE table
� Requirement to select all candidate IDs who have taken test number 701
Assuming no other indexes, which of the following indexes should be created to support the requirement?
A.Primary key on candidate (CandidateID) allowing reverse scans
B.Unique index on candidate (CandidateID) disallowing reverse scans
C.Clustered index on test_taken (CandidateID) allowing reverse scans
D.Index on test_taken (CandidateID, TestNumber) allowing reverse scans
D
26.Which of the following is a benefit of a clustering index?
A.Data compression is allowed in the table
B.Disk space is saved when adding rows to the table
C.Uniqueness of key columns is guaranteed in the table
D.Rows are stored with equal key values close to each other in the table
D





27.What is the purpose for creating a primary key on a table?
A.To ensure duplicate key values are entered
B.To support creation of a table check constraint
C.To support referential integrity between tables
D.To provide free space on each index page for new data
C

28.Given the following table definition:
CREATE TABLE class_list
(studentId INTEGER,
grade INTEGER CONSTRAINT chk CHECK (grade <= 100) NOT ENFORCED
)
and the statement:
INSERT INTO class_list VALUES (98, 100), (123,123), (101, 98)
How many records will be retrieved by the following statement?
SELECT * FROM class_list
A.0
B.1
C.2
D.3
D

29.Which of the following DB2 objects allows multiple users to access data in a table with each user only being able to access certain portions of the data?
A.Views
B.Summary Tables
C.Dimension Tables
D.Table Constraints
A
DB2 UDB Test Sample 701

1.To allow incoming connections via TCP/IP to an instance, which of the following must be set on the server?
A.The node directory should have an entry for the instance.
B.The value of the DB2COMM registry variable for the instance should include TCPIP.
C.The value of the AUTHENTICATION parameter for the instance should be set to SERVER.
D.The value of the SVCENAME parameter for the instance should be set to the TCP/IP host name of this machine.
B

2.DB2 Enterprise Server Edition (ESE) is running on Linux and needs to validate the userids and passwords on the z/OS server for the DB2 clients connecting to DB2 for z/OS. Which of the following authentication levels satisfies this while providing authentication for other DB2 clients at the DB2 ESE server?
A.DCS
B.DRDA
C.HOST
D.CLIENT
E.SERVER
A
3.To permit all users from any DB2 UDB client to connect to the database, which of the following is required in the database's instance?
A.Set trust_clntauth = Client, trust_allclnts=No
B.Set trust_clntauth = Server, trust_allclnts=No
C.Set trust_clntauth = Client, trust_allclnts=Yes
D.Set trust_clntauth = Server, trust_allclnts=Yes
C
4.In which of the following locations must userids and passwords be defined if using authentication SERVER?
A.The node directory on the server
B.The system catalog on the server
C.The PASSWORD table in the database
D.The operating system on the server
D
5.Given an application with the embedded static SQL statement:
INSERT INTO admin.payroll (employee, salary) VALUES ("Becky Smith",80000)
Which of the following privileges must a user hold to run the application?
A.ALTER on the table
B.INSERT on the table
C.DBADM on the database
D.EXECUTE on the package
D
6.AUTHENTICATION=SERVER_ENCRYPT allows DB2 to encrypt which of the following?
A.data
B.userid
C.password
D.userid and password
C
7.Which of the following is required to use the IMPORT utility to import data into a table?
A.SYSCTRL authority
B.LOAD authority on the table
C.ALTER privilege on the table
D.IMPORT authority on the table
E.INSERT privilege on the table
E
8.Which two of the following identify which users have SYSCTRL authority?
A.The node directory
B.The system catalog
C.The database configuration
D.The operating system security
E.The database manager configuration
DE
9.Which of the following can be done by a user who is granted the CONTROL privilege on an INDEX?
A.Drop the index
B.Alter the index
C.Add columns to the index
D.Create an index extension on the index
A
10.Which of the following actions will occur when issuing the command FORCE APPLICATION ALL?
A.No new database connections are allowed
B.Uncommitted units of work are committed
C.Uncommitted units of work are rolled back
D.Disconnect warning messages are sent to connected users
C
11.Which of the following must be set to restrict clients from being able to discover any DB2 instances on a server?
A.DISCOVER_DB parameter to DISABLE
B.DISCOVER_INST parameter to DISABLE on a DB2 instance
C.DB2 Administration Server configuration parameter SEARCH to DISABLE
D.DB2 Administration Server configuration parameter DISCOVER to DISABLE
D
12.When scheduled using the Task Center, all of the following actions can be specified to take place upon completion or failure of the task, EXCEPT:
A.Create a new task.
B.Send an email or page.
C.Cancel other scheduled tasks.
D.Re-run the task that just completed.
A
13.Given the following notification message:
*
2002-02-05-03.14.38.559911 Instance b2inst1 Node:000
PID:89198(db2agent (DB2PROD ))
Appid:*LOCAL.db2inst1.020205091435
buffer pool services sqlbStartPoolsErrorHandling Probe:39
ADM6080E The tablespace "ID" (ID "3"), was put OFFLINE and in
ROLLFORWARD_PENDING. Tablespace state is 0x"00004080". 1

*
Which database does this message apply to?
A.ID
B.DB2PROD
C.db2inst1
D.db2agent
B
14.Given the following command:
CREATE DATABASE inventory
CATALOG TABLESPACE
MANAGED BY SYSTEM USING ('path1','path2')
EXTENTSIZE 16 PREFETCHSIZE 32
USER TABLESPACE
MANAGED BY SYSTEM USING ('patha')
TEMPORARY TABLESPACE
MANAGED BY DATABASE USING ( FILE 'filea' 1000)
WITH "EXTENTSIZE 8"
With which of the following buffer pools is the catalog table space associated?
A.IBMUSERBP
B.IBMTEMPBP
C.IBMCATALOGBP
D.IBMDEFAULTBP
D
15.Given the following command:
CREATE DATABASE inventory
CATALOG TABLESPACE
MANAGED BY SYSTEM USING ('path1','path2')
EXTENTSIZE 16 PREFETCHSIZE 32
USER TABLESPACE
MANAGED BY SYSTEM USING ('patha')
TEMPORARY TABLESPACE
MANAGED BY DATABASE USING ( FILE 'filea' 1000)
WITH "EXTENTSIZE 8"
How many bufferpools are in the inventory database?
A.0
B.1
C.2
D.3
E.4
B
16.Given the following statements:
CREATE TABLE T1 (COL1 INT NOT NULL PRIMARY KEY, COL2 CHAR, COL3 CLOB (40K), COL4 VARCHAR(10));

CREATE UNIQUE INDEX IND_1 ON T1 (COL1, COL2) INCLUDE (COL3) ALLOW REVERSE SCANS;
The CREATE UNIQUE INDEX statement will fail because:
A.LOB columns cannot be used in an index.
B.A unique index cannot include an existing primary key.
C.Reverse scans are not supported on multi-column indexes.
D.INCLUDE columns are not supported in indexes that support REVERSE SCANS.
A
17.Given the following DDL statements:
CREATE TABLE person OF person_t
(REF IS OID USER GENERATED)
CREATE TABLE emp OF emp_t UNDER person
INHERIT SELECT PRIVILEGES
CREATE TABLE student OF student_t UNDER person
INHERIT SELECT PRIVILEGES
Which of the following will drop all tables associated with the hierarchy?
A.Dropping the PERSON table
B.Dropping the table hierarchy called PERSON
C.Deleting all rows from the person hierarchy
D.Dropping all columns from the subtables STUDENT and EMP
B
18.Which two of the following objects can be changed with an ALTER statement?
A.Index
B.Trigger
C.Procedure
D.Constraint
E.Table space
DE
19.Given the following command:
CREATE TABLESPACE tbs1
MANAGED BY SYSTEM USING ( 'path1' )
EXTENTSIZE 16 PREFETCHSIZE 32
In a single partition database, how can the amount of storage available to the table space tbs1 be increased?
A.Extend the container
B.Add a container to tbs1
C.Free up disk space on path1
D.Increase the extent size of the table space
C
20.Which of the following kinds of table spaces allows LOBs to use the filesystem cache?
A.An SMS table space
B.A user temporary table space
C.A system temporary table space
D.A DMS table space created with raw devices
A
Last week, I passed DB2-700(92%) and DB2-701(76%)

I plan to prepare for DB2-703.Where can I find Test Sample or Mocks. THX.!!

DB2 UDB Test Sample 700

To set up a client that can access DB2 UDB through DB2 Connect Enterprise Edition, which of the following is the minimum software client that must be installed?
A.DB2 Runtime Client
B.DB2 Personal Edition
C.DB2 Administration Client
D.DB2 Application Development Client
A

A client application on OS/390 or OS/400 must access a DB2 server on AIX. At a minimum, which of the following products is required to provide DRDA Application Server functionality on the DB2 server?
A.DB2 Connect Enterprise Edition
B.DB2 UDB Workgroup Server Edition
C.DB2 Connect Enterprise Edition and DB2 UDB Workgroup Server Edition
D.DB2 Connect Enterprise Edition and DB2 UDB Enterprise Server Edition}
B

A developer is building a Windows embedded SQL application that will access DB2 UDB for OS/390 or OS/400 servers. Which of the following products is required to be installed on the Windows system in order to build the application?
A.DB2 UDB Personal Edition
B.DB2 Connect Personal Edition
C.DB2 Personal Developer's Edition
D.DB2 UDB Workgroup Server Edition
C

Which of the following tools can be used to identify inefficient SQL statements without executing them?
A.QMF大机
B.Task Center
C.Visual Explain
D.Development Center
C

Which of the following tools maintains a history of all executed statements/commands for the current session within the tool?
A.Journal
B.SQL Assist
C.Health Center
D.Command Center
D

Which of the following products is designed for analyzing data with more than two dimensions?
A.DB2 OLAP Server
B.DB2 Warehouse Manager
C.DB2 Relational Connect
D.DB2 Data Links Manager
A

Which of the following tools is used to create and build stored procedures?
A.SQL Assist
B.Task Center
C.Development Center
D.Replication Center
C

Which of the following tools is used to create subscription sets 复制预约and add subscription-set members to subscription sets?
A.Journal
B.License Center
C.Replication Center
D.Development Center
C

Which two of the following types of storage management methods are supported by DB2 OLAP Server?
A.Object
B.Network
C.Relational
D.Hierachical
E.Multi-dimensional
CE

Which of the following products can be used to perform a dictionary-based search?
A.DB2 XML Extender
B.DB2 AVI Extender
C.DB2 Text Extender
D.DB2 Spatial Extender
C

Which of the following extenders allows data to be presented in a three-dimensional format?
A.DB2 AVI Extender
B.DB2 XML Extender
C.DB2 Text Extender
D.DB2 Spatial Extender
D
When establishing client-server communication, which two of the following can be used to verify passwords?
A.Catalog Tables
B.Access Control List
C.Application Programs
D.DRDA Application Server
E.Client Operating System
DE

Given the following users and groups with no privileges on table t1:
GroupA GroupB
------ ------
user1 user4
user2 user5
user3
Which of the following commands gives all users in the above groups the ability to create a view on table t1?
A.GRANT SELECT ON TABLE t1 TO ALL
B.GRANT SELECT ON TABLE t1 TO PUBLIC
C.GRANT REFERENCES ON TABLE t1 TO ALL
D.GRANT SELECT ON TABLE t1 TO USER GroupA, GroupB
B
A table called EMPLOYEE has the following columns:
NAME
DEPARTMENT
PHONE_NUMBER
Which of the following will allow USER1 to modify the PHONE_NUMBER column?
A.GRANT INDEX (phone_number) ON TABLE employee TO user1
B.GRANT ALTER (phone_number) ON TABLE employee TO user1
C.GRANT UPDATE (phone_number) ON TABLE employee TO user1
D.GRANT REFERENCES (phone_number) ON TABLE employee TO user1
C

An administrator issues:
GRANT ALL PRIVILEGES ON TABLE appl.tab1 TO user1 WITH GRANT OPTION
Which of the following statements is USER1 authorized to execute?
A.GRANT DROP ON TABLE appl.tab1 TO user8
B.GRANT OWNER ON TABLE appl.tab1 TO user8
C.GRANT INSERT ON TABLE appl.tab1 TO user8
D.GRANT CONTROL ON TABLE appl.tab1 TO user8
C
A user defined function named F.FOO has an input parameter of an integer. USER4 executes the following SQL statement:
SELECT col1, col2 FROM t.tab1 WHERE f.foo(col1) < 6;
Which of the following statements grants USER4 the privilege needed to be able to execute the user defined function?
A.GRANT USE ON FUNCTION f.foo(INT) TO user4
B.GRANT SELECT ON FUNCTION f.foo(INT) TO user4
C.GRANT EXECUTE ON FUNCTION f.foo(INT) TO user4
D.GRANT REFERENCES ON FUNCTION f.foo(INT) TO user4
C

Which of the following will grant just DML operations on table T.T4 to all users?
A.GRANT ALL PRIVILEGES ON t.t4 TO PUBLIC
B.GRANT ALL PRIVILEGES ON t.t4 TO ALL USERS
C.GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE t.t4 to PUBLIC
D.GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE t.t4 TO ALL USERS
C

What does the following statement do?
GRANT REFERENCES(col1) ON TABLE t.t1 TO user7
A.Gives USER7 the ability to refer to column COL1 of table T.T1 in views or select statements
B.Gives USER7 the ability to refer to column COL1 of table T.T1 on user-defined function calls
C.Gives USER7 the ability to define referential integrity on table T.T1 using column COL1 as the parent key
D.Gives USER7 the ability to define referential integrity on table T.T1 using column COL1 as the foreign key
C

Communications is being manually established from a Windows 2000 client through a DB2 Connect gateway to a DB2 host system. Which of the following does NOT have to be cataloged on the gateway?
A.The client
B.The node where the data source resides
C.The data source on the DB2 database server
D.The Database Connection Service (DCS) database
A

A database administrator has supplied the following information:
� Protocol: TCP/IP
� Port Number: 446
� Host Name: ZEUS
� Database Name: SAMPLE
� Database Server Platform: OS/400
Which are the appropriate commands to set up the ability to connect to the database?
A.CATALOG TCPIP NODE zeus REMOTE zeus SERVER 446 OSTYPE os400 DATABASE sample;
B.CATALOG TCPIP DATABASE sample REMOTE zeus SERVER 446 OSTYPE os400;
CATALOG DATABASE dcssam AS sample AT NODE zeus AUTHENTICATION dcs;
C.CATALOG TCPIP NODE zeus REMOTE zeus SERVER 446 OSTYPE os400;
CATALOG DCS分布式连接服务 DB dcssam AS sample;
CATALOG DATABASE dcssam AS sample AT NODE zeus AUTHENTICATION dcs;
D.CATALOG TCPIP NODE sample REMOTE sample SERVER 446 OSTYPE os400;
CATALOG DCS DB sample AS dcssam;
CATALOG DATABASE dcssam AS sample AT NODE zeus AUTHENTICATION dcs;
C

Given the following:
CREATE TABLE tab1 (c1 char(3) WITH DEFAULT NULL, c2 INTEGER);
INSERT INTO tab1(c2) VALUES (345);
What will be the result of the following statement if issued from the Command Line Processor?
SELECT * FROM tab1;
A.C1 C2
--- -----------
0 record(s) selected.
B.C1 C2
--- -----------
123 345
1 record(s) selected.
C.C1 C2
--- -----------
345
1 record(s) selected.
D.C1 C2
--- -----------
- 345
1 record(s) selected.
D
Last week , I passed DB2 700 and DB2 701. I don't think it's difficult.

Then I plan to prepare for DB2 703.

Where can I find DB2-703 Mocks or free sample tests?

Thx.
I passed ibm 285(80%) and 286(68%) yesterday afternoon. So tired I was.I think I am crazy to do 2 exams in one afternoon. Luckily, I pass all. Thx everyone who give much useful experience in the forum.

I study 285 in two weeks like other people.
For the test 285:
1. A book "An Introduction to Web Application Development with IBM WebSphere Studio: IBM Certified Associate Developer"
2. http://java.boot.by/icad-guide/
3. Dirk Nolte's topic, "an ICE test", but i can't find the link again.(Thanks Dirk Nolte)
It's easy. I finished the exam in 58 mins.I have used eclipse 3 months before study wsad.

I study 286 also in two weeks
For the test 286:
1. http://www-03.ibm.com/certify/tests/obj286.shtml
2. http://java.boot.by/ibm-287/ (chapter 2)
3. A book: "Developing J2EE Applications with WebSphere Studio: IBM Certified Enterprise Developer" (ch2,ch3,ch4,ch11)
4. scwcd guide (a little help)
The exam is not easy. I use out time. I nearly give it up.
Unbelievably, I pass it when the time is over.
Thank godness.

Now i have 5 certification.(That 's a good grade.)
IBM Certified Solution Developer - WebSphere Studio, V5.0
IBM Certified Associate Developer - WebSphere Studio, V5.0
IBM certification XML and related technologies
2005,Sun Certified Web Component Developer for the Java 2 Platform
2004,Sun Certified Programmer for the Java 2 Platform, Standard Edition 1.4

Good luck to everybody!

PS: Next year i will graduate from South China Univerciry of technology in China. I wish to find a job in US. Please tell me how to do?Thx.
Thanks everyone on the site who posts these valuable notes.

I pass xml 79% today.
I spend 3 months to do it.

I am from China. My Englihs is not good. I think it's difficult for me to pass the cert. But today I am happy.

Thanks everyone on the site again. It really help me a lot.