pass4sure ibm 000-526

By PassGuide-IBM Study Guide | Oct 11, 2008
Visited 106 times, 2 so far today

db2 udb database administration for os/390 : 000-516 Exam
Known also as the IBM DB/2 Administration for OS/390 (000-516), this exam plays an integral role in obtaining your certification. All IBM certification exams are extremely detailed and cover many different technological areas. We designed the 000-516 questions and answers for this very purpose, to prepare you for the unexpected. Beyond the testing center, the skills you learn and the knowledge you confirm using the 000-516 practice exams and exam simulators will translate directly into your daily work environment.
Product Description

Exam Number/Code: 000-516

Exam Name:db2 udb database administration for os/390

“db2 udb database administration for os/390″, also known as 000-516 exam, is a IBM certification. With the complete collection of questions and answers, Pass4sure has assembled to take you through 142 questions to your 000-516 Exam preparation. In the 000-516 exam resources, you will cover every field and category in DB2 helping to ready you for your successful IBM Certification.

Question: 1
Which of the following SQL clauses CANNOT be used in a CREATE VIEW statement?

A. GROUP BY B. ORDER BY C. Subselect D. Outer join
Answer: B Question: 2
Given the following partitioned table space index definition: CREATE INDEX OWN1.IX1
ON OWN1.TB1 (COL_KEY ASC)
USING STOGROUP DSN8G710
PRIQTY 7200
SECQTY 720
CLUSTER
(
PART 1 VALUES(25), PART 2 VALUES(50), PART 3 VALUES(75),
PART 4 VALUES(99),
)
BUFFERPOOL BP1;
Which of the following partitions will a data row with a COL_KEY value of 55 fall into?

A. Partiton 1
B. Partition 2
C. Partition 3
D. Partition 4
Answer: C Question: 3
Which of the following is NOT a valid option on a CREATE INDEX statement for a TYPE 2 index?

A. CLOSE B. DEFER
C. SUBPAGE D. PIECESIZE
Answer: C Question: 4
Which of the following statements is NOT true for a segmented table space?

A. It is more efficient for table spaces greater than 4 GB
B. It makes free pages available immediately after a commit
C. It generally skips empty pages when a table scan is being processed
D. It has more efficient space map processing than a simple table space

Answer: A Question: 5

When copying a table using CREATE TABLE…LIKE, which of the following is TRUE of the new
table?

A. Table check constraints are copied from the original table
B. WITH RESTRICT ON DROP will be copied from the original table
C. Column null attributes will be copied from the original table
D. Primary and foreign keys will be copied from the original table
E. Database and table space information is the same as the original table
Answer: C Question: 6
Given the following CREATE TABLE statement: CREATE TABLE STAFF
(
EMPID CHAR(6) NOT NULL, NAME VARCHAR(15) NOT NULL, SALARY DECIMAL(9,2)
)
IN DATABASE HUMANRES;
Where will DB2 put the STAFF table?

A. In an implicit table space B. In the default table space C. In an existing table space D. In a temporary table space
Answer: A Question: 7
Which of the following tasks CANNOT be accomplished using the DB2 Catalog or Directory?

A. Determine plan/package dependencies
B. Determine referential constraints upon a table
C. Determine the characteristics of indexes on a table
D. Determine table spaces that do not have image copies
E. Determine active/archive log data set characteristics
Answer: E Question: 8
Which TWO of the following system catalog tables contains the correlation between the name of an index and the physical dataset name? (Select two.)

A. SYSIBM.SYSKEYS
B. SYSIBM.SYSINDEXES
C. SYSIBM.SYSKEYSPART D. SYSIBM.SYSINDEXPART E. SYSIBM.SYSINDEXSTAT

Answer: B, D Question: 9

RUNSTATS with the KEYCARD parameter has been run for all the tables in the payroll
application. Which two of the following columns will tell the DBA the estimated number of distinct values in a column of any table?

A. SYSTABLES.CARDF B. SYSCOLDIST.CARDF
C. SYSTABLEPART.CARDF D. SYSINDEXPART.CARDF
E. SYSCOLUMNS.COLCARDF F. SYSCOLSTATS.COLCARD
Answer: B, E Question: 10
Which DB2 catalog table can be used to determine if a user has the authorization to bind a new
plan?

A. SYSDBAUTH B. SYSTABAUTH
C. SYSUSERAUTH D. SYSPLANAUTH
Answer: C Question: 11
Which of the following statements will create a partitioned table space TS1 in database DB1 with
5 partitions with selective partition locking?

A. CREATE TABLESPACE ts1 IN db1 LOCKPART YES MAXROWS 5
B. CREATE TABLESPACE ts1 IN db1 NUMPARTS 5 LOCKPART YES C. CREATE TABLESPACE ts1 IN db1 PARTITIONS 5 LOCKING YES
D. CREATE TABLESPACE ts1 IN db1 NUMPARTS 5 SELPARTLOCK YES
Answer: B Question: 12
Which of the following ALTER TABLESPACE statements causes DB2 to record data page changes in the space map pages of a segmented table space
DSN8D71A.DSN8S71E?

A. ALTER TABLESPACE dsn8d71a.dsn8s71e LOG YES;
B. ALTER TABLESPACE dsn8d71a.dsn8s71e CLOSE YES;
C. ALTER TABLESPACE dsn8d71a.dsn8s71e TRACKMOD YES; D. ALTER TABLESPACE dsn8d71a.dsn8s71e COMPRESS YES;
E. ALTER TABLESPACE dsn8d71a.dsn8s71e CHANGEMOD YES;
Answer: C Question: 13
Which of the following statements will create a table space TS1 in database DB1 with 3
partitions?

A. CREATE LOB TABLESPACE ts1 IN db1 …
B. CREATE TABLESPACE ts1 IN db1 NUMPARTS 3 …
C. CREATE SEGMENTED TABLESPACE ts1 IN db1 NUMPARTS 3 …

* pass4sure ibm 000-526 Questions and Answers : 142 questions
* Updated: October 2nd , 2008
* Price: $159.99 $99.99

Free down:Testking ibm 000-516
Free down:Pass4sure ibm 000-516