anyone taking db2 dba exam?

Hi, several Qs need help!

1)
Which two of the following must be done to allow DB2 databases to be automatically detected by DB2 clients.

a) Run the Client Configuration Assistant at the database server.

b) Set AUTHENTICATION=CLIENT in the database manager configuration.

c) Ensure the database configuration parameter DISCOVER_DB is set to ENABLE.

d) Ensure the database manager configuration parameter DISCOVER is set to ENABLE.

e) Ensure the database manager configuration parameter DISCOVER_INST is set to ENABLE.

2)
Given the following:

Node 1 entry:
Node name = DB2SERV
Comment = My TCPIP connection
Protocol = TCPIP
Hostname = db2inst1
Service name = db2svce

Which of the following commands must be executed before updating the DBM configuration for this instance?

a) ATTACH TO db2serv

b) ATTACH TO db2inst1

c) CONNECT TO db2serv

d) CONNECT TO db2inst1

3)
Which of the following actions is required before forcing a user off of a remote database?

a) Catalog the remote database

b) Quiesce the remote database

c) Connect to the remote database

d) Attach to the remote DB2 instance

e) Update DB2INSTANCE environment variable



5)
Which two of the following steps are required to set up a DB2 server to allow remote client access using APPC and TCP/IP?

a) Update the DBM configuration

b) Catalog the client workstation

c) Set the DB2COMM registry variable

d) Create a DB2 instance for each protocol

e) Update the DB configuration for each database



6)
Which of the following table space creation statements enables container space to be allocated as required?

a) CREATE TABLESPACE TS1 MANAGED BY SYSTEM USING ('D:\CONTAIN3', 'G:\CONTAIN4')

b) CREATE INCREMENTAL TABLESPACE TS1 MANAGED BY DATABASE USING (DEVICE '/dev/rdev11' 24000)

c) CREATE TABLESPACE TS1 MANAGED BY DATABASE USING (DEVICE '/dev/rdev23' 150000) EXTENTSIZE 1

d) CREATE INCREMENTAL TABLESPACE TS1 MANAGED BY SYSTEM USING ('D:\CONTAIN1', 'G:\CONTAIN2') EXTENTSIZE 1



8)
Given the following statement:

CREATE TYPE Emp_type AS
(Serialno Char(6)
Name Varchar(32)
Address Varchar(100)
Salary Integer
Photo Blob(1M)
MODE DB2SQL

Which of the following statement stubs must be used to create a table with this definition?


a) CREATE TABLE StateEmp OF Emp_type...

b) CREATE TABLE StateEmp OF TYPE Emp_type...

c) CREATE TABLE StateEmp WITH TYPE Emp_type...

d) CREATE TABLE StateEmp USING TYPE Emp_type...



12)
Given the following tables:

TEST_TAKEN
TestName CHAR(50) NOT NULL
TestNumber INTEGER NOT NULL
TestScore INTEGER NOT NULL
CandidateID INTEGER NOT NULL

CANDIDATE_DB2
CandidateName CHAR(20) NOT NULL
CandidateID INTEGER NOT NULL
Address CHAR(100) NOT NULL
CandidatePhoto BLOB(1M)

And the following information:

o Candidate Ids are unique
o A query which returns all addresses of individuals who have taken a DB2 test

While reading a minimum number of physical pages, an optimizer needs to consider the index to scan over all rows of the table data. Which of the following indexes must be created?


a) Primary key on candidate_db2 (CandidateID)

b) Unique clustered index on test_taken (CandidateName)

c) Unique index on test_taken (CandidateID, TestNumber)

d) Unique index on candidate_db2 (CandidateID, CandidateName)

e) Unique clustered index on candidate_db2 (Candidate ID, CandidateName)



13)
Which of the following enables joining tables in heterogeneous databases with DB2's Federated Database function:

a) The join columns in the two tables must have exactly the same data type.

b) The only join permitted with heterogeneous databases is a cartesian product, so join columns are not required.

c) The user or DBA may have to override some mappings of data types from the non-DB2 database to a different DB2 data type for the join to succeed.

d) The Federated database feature will automatically map all data type values in the non-DB2 database to the closest DB2 data type so the join keys match.



16)
From the Journal, which of the following can reschedule a job to execute at a later time?

a) Messages page

b) Job History page

c) Pending Jobs page

d) Running Jobs page



Which of the following in Visual Explain output indicates that intra-partition parallelism is being used in the access strategy?

a) sort table queues

b) local table queue

c) remote table queue

d) look-ahead table queue



Given the following scenario:

GET SNAPSHOT FOR ALL DATABASES
Database Snapshot
Database name = SAMPLE
..... Sort overflows = 18
Which of the following actions will NOT reduce sort overflows?

a) Create an index

b) Increase sort heap size

c) Reorganize sorted tables

d) Update statistics on sorted tables

e) Decrease number of concurrent users



Given the catalog view:

SYSSTAT.INDEXES
indschema indname nleaf nlevels firstkeycard fullkeycard clusterratio
ADMIN PAYROLL1 -1 -1 -1 -1 -1
ADMIN PAYROLL2 -1 -1 -1 -1 -1
Which of the following is the first step to improving query response time?

a) Drop these indexes

b) Reorganize the table based on index PAYROLL1

c) Reorganize the table based on index PAYROLL2

d) Run statistics on the base tables for these indexes



Which of the following DB2 utilities can insert data into a DRDA host database?

a) LOAD

b) EXPORT

c) IMPORT

d) UPLOAD

e) FORCEIN



Which of the following must be used to move a DB2 database from Windows NT to Linux?

a) Backup the database on Windows NT and restore it on Linux.

b) Use Relational Connect to move the data using INSERT statements with subselects.

c) Use db2move to automate exporting the tables on Windows NT and LOADing them on Linux.

d) Use db2look with the -e option to capture the DDL and data for each table in a format that can be imported to DB2 on Linux.

1:
c) Ensure the database configuration parameter DISCOVER_DB is set to ENABLE.
e) Ensure the database manager configuration parameter DISCOVER_INST is set to ENABLE

2::
a) ATTACH TO db2serv

3:
d) Attach to the remote DB2 instance

5:
a) Update the DBM configuration
c) Set the DB2COMM registry variable

6:
a) CREATE TABLESPACE TS1 MANAGED BY SYSTEM USING ('D:\CONTAIN3', 'G:\CONTAIN4')

8:
a) CREATE TABLE StateEmp OF Emp_type...

Haha, just want to take the free db2 exam. everytime around 70% (ft)

I will try,try ,try...

thanks again!!  :D