Braindumps of 000-513
DB/2 Administration for Windows, Linux & OS/2
Exam Questions, Answers, Braindumps
Hi all. passed it today. It was
easy. It’s my contribution.
Given the following piece of a LIST APPLICATIONS output:
Exhibit missing. Will be fixed in later versions
Which of the following commands terminates the client
A. KILL APPLICATION (7)
B. FORCE APPLICATION
C. DISCONNECT APPLICATION (7)
D. KILL APPLICATION payroll.exe
E. FORCE APPLICATION payroll.exe
F. DISCONNECT APPLICATION payroll.exe
Which of the following statements is TRUE?
A. DB2MOVE does not support LOBs.
B. DB2MOVE supports the data links data type
C. DB2MOVE supports DRDA data resources and targets.
D. DB2MOVE supports LOBs residing on disk in separate
E. DB2MOVE supports exporting and importing trigger
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 node directory on the client
C. The system catalog on the server
D. The operating system on the server
E. The operating system on the client
Which of the following is NOT possible when issuing
a FORCE command?
A. IDLE users can be successfully forced
B. Users creating a database can be forced
C. DB2STOP can be successfully executed during a force
D. The database will still successfully accept connections
Given the 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
WITH "EXTENTSIZE 8"
How many buffer pools are in the inventory database?
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
CREATE TABLE STUDENT OF STUDENT_T UNDER PERSON INHERIT
CREATE TABLE STAFF (COL1 INT, COL2 INT) and
INSERT 1 row into PERSON
INSERT 1 row into EMP
INSERT 1 row into STUDENT
INSERT 2 rows into STAFF
How many rows will be returned after issuing the SQL
SELECT * FROM PERSON?
Which of the following tasks is performed by the DB2
Query Patroller Tracker Utility?
A. Accepts, analyzes, prioritizes, and schedules database
requests and optionally notifies users when their
requests have been processed.
B. Enables the user to monitor query status, view
job details, cancel jobs, submit new jobs, drop result
tables, and resubmit completed jobs.
C. Allows you to determine which tables and columns
have been accessed most frequently, which tables have
returned the most result rows, and which jobs have
been completed within a specific time period.
D. Enables the system administrator to manage the
DB2 Query Patroller system parameters, create or delete
profiles for DB2 Query Patroller users, manage nodes,
result destinations, data sources and job queues.