513参考

zhangyh123

Category: Section 7 - Problem Determination
   
(67/67) Given the DB2DIAG.LOG entry:
1999-05-25-06.34.11.102000 Instance: DB2 Node:000
PID:103 (db2sysc.exe) TID:210 Appid:none
common_communication sqlcctcpconnmgr Probe:50

DIA3200E The SVCENAME parameter in the database manager configuration file is not configured. Update the SVCENAME parameter using the service name defined in the TCP/IP services file.
Which of the following indicates when the above message will be generated?
  
(Select the correct response)
C
   
A.      db2stop
B.      db2start
C.      attach to an instance
D.      connect to a database
DB2 UDB Database Administration

Category: Section 7 - Problem Determination
   
(66/67) Given the following DB2DIAG.LOG entry:
"Crash Recovery is needed."
and the database configuration autorestart is set to off.
Which of the following is required to initiate crash recovery?
  
(Select the correct response)
B
   
A.      CONNECT TO <database-alias>;
B.      RESTART database <database-alias>;
C.      RECOVER database <database-alias>;
D.      RESTORE database <database-alias>;
DB2 UDB Database Administration

Category: Section 6 - Database Recovery and Maintenance
   
(65/67) How might you recover the original backup history file given the following?

LIST BACKUP ALL FOR <database-alias>; SQL2160W A damaged recovery history file has been replaced. Processing continued.  
(Select the correct response)
B
   
A.      Restore the database from previous backup.
B.      Copy the database SQLBP.2 file to SQLBP.1.
C.      Restore just the catalog tablespace from a previous backup.
D.      Copy the db2rhist.asc file from another database on the same instance.

Category: Section 6 - Database Recovery and Maintenance
   
(64/67) Which of the following is supported when LOGRETAIN is OFF and USEREXIT is OFF?  
(Select the correct response)

  B
A.      Log archiving
B.      Crash recovery
C.      Rollforward recovery
D.      Rollforward to point in time
BASE - Browser based Assessment System
DB2 UDB Database Administration

Category: Section 6 - Database Recovery and Maintenance
   
(63/67) During database restart, some indexes may be required to be rebuilt. This can be minimized by changing which of the following DBM CFG parameters prior to restart?  
(Select the correct response)
A
   
A.      update dbm cfg using indexrec access
B.      update dbm cfg using indexrec restart
C.      update dbm cfg using indexrec connect
D.      update dbm cfg using indexrec rebuild

BASE - Browser based Assessment System
DB2 UDB Database Administration

Category: Section 6 - Database Recovery and Maintenance
   
(62/67) Which of the following must occur to restore a database which has table space containers on invalid drives/devices?  
(Select the correct response)
C
   
A.      Use rollforward recovery on the database.
B.      Use the restart database command on the database.
C.      Use the recovery history file to restore the database.
D.      Use the restore command.

DB2 UDB Database Administration

Category: Section 6 - Database Recovery and Maintenance
   
(61/67) Given the command:
BACKUP DATABASE sample to path/dir
Which of the following parameters determines how much memory will be used to backup the database sample?  
(Select the correct response)
B
   
A.      logbufsz
B.      backbufsz
C.      extentsize
D.      prefetchsize

--------------------------------------------------------------------------------



BASE - Browser based Assessment System
DB2 UDB Database Administration

Category: Section 5 - DB2 Utilities
   
(60/67) Which of the following is NOT true of DB2MOVE?  
(Select the correct response)
C
   
A.      DB2MOVE can export all user tables from a database.
B.      DB2MOVE can export specific tables from a database.
C.      DB2MOVE can export trigger definitions from a database.
D.      DB2MOVE can export all tables created by one user in a database.
E.      DB2MOVE can accept wildcards for tables to export from a database.

--------------------------------------------------------------------------------



BASE - Browser based Assessment System
DB2 UDB Database Administration

Category: Section 5 - DB2 Utilities
   
(59/67) Which of the following authorizations can be used to rollforward through database logs, but NOT restore a backup image into a new database?  
(Select the correct response)
D
   
A.      DBADM
B.      SYSADM
C.      SYSCTRL
D.      SYSMAINT

--------------------------------------------------------------------------------



DB2 UDB Database Administration

Category: Section 5 - DB2 Utilities
   
(58/67) Which of the following will NOT allow for loading data into a table?  
(Select the correct response)
C
   
A.      DBADM authority
B.      SYSADM authority
C.      UPDATE privilege
D.      LOAD authority with the INSERT and DELETE privileges

DB2 UDB Database Administration

Category: Section 5 - DB2 Utilities
   
(57/67) Given the following data from SYSCAT.TABLES with partial dates:
TABNAME STATS_TIME CARD NPAGES FPAGES OVERFLOW
--------------- ---------- ------- --------- -------- -----------
T1 - -1 -1 -1 -1
ORG 1999-05-05- 8000 157 157 2
EMPO_SALES 1998-05-05- 767 23 23 5
EMP_SALES 1998-04-04- 844 19 19 45
MYTABV - -1 -1 -1 -1

Which of the following tables will benefit most from being reorganized?
  
(Select the correct response)
D
   
A.      T1
B.      ORG
C.      MYTABV
D.      EMP_SALES
E.      EMPO_SALES

DB2 UDB Database Administration

Category: Section 5 - DB2 Utilities
   
(56/67) Which of the following DB2 commands updates information used by the optimizer when choosing an access path?  
(Select the correct response)
D
   
A.      REORG
B.      IMPORT
C.      REBIND
D.      RUNSTATS

DB2 UDB Database Administration

Category: Section 5 - DB2 Utilities
   
(55/67) An IXF file contains data to be placed into a DB2 database. The layout of the data in the file matches the layout of a view in the target database. Which of the following DB2 utilities can insert the data using the view?  
(Select the correct response)
D
   
A.      LOAD
B.      LVIEW
C.      EXPORT
D.      IMPORT
E.      UPLOAD

--------------------------------------------------------------------------------







BASE - Browser based Assessment System
DB2 UDB Database Administration

Category: Section 5 - DB2 Utilities
   
(54/67) When are table check constraints enforced using the DB2 LOAD utility?  
(Select the correct response)
D
   
A.      During the BUILD phase of the LOAD
B.      During the DELETE phase of the LOAD
C.      When the UPDATE CONSTRAINTS statement is issued
D.      Using the SET INTEGRITY ... IMMEDIATE CHECKED statement

--------------------------------------------------------------------------------








BASE - Browser based Assessment System
DB2 UDB Database Administration

Category: Section 5 - DB2 Utilities
   
(53/67) Which of the following is TRUE about the IMPORT utility?  
(Select the correct response)
C
   
A.      Views can be created
B.      Summary tables can be targets
C.      Datalink columns can be imported
D.      System catalog tables can be targets

--------------------------------------------------------------------------------



DB2 UDB Database Administration

Category: Section 5 - DB2 Utilities
   
(52/67) Given the following SQL statements and statement stub:
DB2 CONNECT TO Source_db
DB2 EXPORT TO Student_sub.del OF DEL
SELECT * FROM IIP_Student
DB2 CONNECT TO Target_db
DB2 IMPORT FROM Student_sub.del OF DEL MODIFIED BY
NO_TYPE_ID METHOD P (1,2,3,4,5) INSERT INTO ....
All of the following describe what the statements are doing, EXCEPT?  
(Select the correct response)
B
   
A.      Exporting from a regular table
B.      Exporting from a non-typed table
C.      The target table is created if not present
D.      Importing into a single table in a hierarchy

DB2 UDB Database Administration

Category: Section 5 - DB2 Utilities
   
(51/67) Which of the following CANNOT be used as input to an export?  
(Select the correct response)
D
   
A.      Select statement with a table view
B.      Select statement with large objects
C.      Select statement with hierarchy table
D.      Select statement with multi-table join

--------------------------------------------------------------------------------



DB2 UDB Database Administration

Category: Section 5 - DB2 Utilities
   
(50/67) Which of the following methods is required to specify the output data during export?  
(Select the correct response)
C
   
A.      Key range
B.      Table name
C.      Column list
D.      Full select

DB2 UDB Database Administration

Category: Section 4 - Monitoring DB2 Activity
   
(49/67) Nodes that are down or in an unknown state are reported in the Alert Center as which of the following?  
(Select the correct response)
A
   
A.      Alarms
B.      Alerts
C.      Warnings
D.      Informational Messages

DB2 UDB Database Administration

Category: Section 4 - Monitoring DB2 Activity
   
(48/67) Which of the following is shown by the Messages Page on the Journal?  
(Select the correct response)
D
   
A.      All messages in the DB2 Diagnostic log
B.      All messages issued by the DB2 Governor
C.      All messages issued by the DB2 Audit Facility
D.      All messages issued through the DB2 administration tools

--------------------------------------------------------------------------------



DB2 UDB Database Administration

Category: Section 4 - Monitoring DB2 Activity
   
(47/67) Given the following Event Monitor output:
Database Event
Buffer Pool Statistics:
Buffer pool logical data page reads: 22500
Buffer pool physical data page reads: 1800
Buffer pool data page writes: 1200
Buffer pool logical index page reads: 10000
Buffer pool physical index page reads: 2500
Buffer pool index page writes: 230
Buffer pool read time: 3230 milliseconds
Buffer pool write time: 7830 milliseconds
...
Buffer pool LSN gap cleans: 8
Buffer pool dirty page steal cleans: 0
Buffer pool dirty page threshold cleans: 3
Which two of the following database configuration parameters will affect when bufferpool page cleaners are triggered?  
(Select all that apply)
CE
   
A.      DBHEAP
B.      SOFTMAX
C.      LOGBUFSZ
D.      MINCOMMIT
E.      CHNGPGS_THRESH
F.      APP_CTL_HEAP_SZ

Category: Section 4 - Monitoring DB2 Activity
   
(46/67) Which of the following is a valid statement to create an event monitor?  
(Select the correct response)
A
   
A.      CREATE EVENT MONITOR ev1 FOR TABLES WHERE APPL_NAME = 'PGM1' WRITE TO FILE 'd:\f1'
B.      CREATE EVENT MONITOR ev1 FOR DEADLOCKS WHERE APPL_NAME = 'PGM1' WRITE TO FILE 'd:\f1'
C.      CREATE EVENT MONITOR ev1 FOR TABLESPACES WHERE APPL_NAME = 'PGM1' WRITE TO FILE 'd:\f1'
D.      CREATE EVENT MONITOR ev1 FOR CONNECTIONS WHERE APPL_NAME = 'PGM1' WRITE TO FILE 'd:\f1'

--------------------------------------------------------------------------------


DB2 UDB Database Administration

Category: Section 4 - Monitoring DB2 Activity
   
(45/67) Given the following scenario:
First Snapshot Output:
GET SNAPSHOT FOR ALL DATABASES
Database Snapshot
Database name= SAMPLE
...
High water mark for connections= 100
...
Applications connected currently= 50
Appls. executing in db manager currently= 40
...
Second Snapshot Output:
GET SNAPSHOT FOR ALL DATABASES
Database Snapshot
Database name= SAMPLE
...
High water mark for connections= 100
...
Applications connected currently= 80
Appls. executing in db manager currently= 40
Both snapshots show "Appl. executing in db manager currently equal to 40".

Which of the following database manager configuration parameters must be updated to increase this data element, assuming there are 60 connections attempting to execute an SQL statement?  
(Select the correct response)
B
A.      MAXAPPLS
B.      MAXAGENTS
C.      MAXCAGENTS
D.      NUM_INITAGENTS
E.      MAX_COORDAGENTS

DB2 UDB Database Administration

Category: Section 4 - Monitoring DB2 Activity
   

DB2 UDB Database Administration

Category: Section 4 - Monitoring DB2 Activity
   
(44/67) Which of the following are functional groups (switches) that can be collected with snapshot monitoring?  
(Select the correct response)
C
   
A.      BUFFERPOOL, SORT, TABLESPACE, UOW
B.      BUFFERPOOL, SORT, DEADLOCKS, STATEMENTS
C.      BUFFERPOOL, SORT, STATEMENTS, TABLE, UOW
D.      BUFFERPOOL, SORT, CONNECTIONS, DEADLOCKS
E.      BUFFERPOOL, SORT, CONNECTIONS, TABLESPACE

--------------------------------------------------------------------------------



DB2 UDB Database Administration

Category: Section 4 - Monitoring DB2 Activity
   
(43/67) Which of the following commands displays the current values of the configured DB2 registry variables?  
(Select the correct response)
B
   
A.      db2set -lr
B.      db2set -all
C.      db2set -env
D.      db2set -list
E.      db2set -display

DB2 UDB Database Administration

Category: Section 4 - Monitoring DB2 Activity
   
(42/67) Which of the following tasks is performed by the DB2 Query Patroller Tracker Utility?  
(Select the correct response)
A
   
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.

DB2 UDB Database Administration

Category: Section 4 - Monitoring DB2 Activity
   
(41/67) To examine the Exhibit, press the exhibit button.
Given the following statement:
SELECT id, deptname, manager
FROM staff, org
WHERE dept=deptnumb
ORDER BY deptname
How many sort operations occurred based on the Visual Explain output?  
(Select the correct response)

D
   
A.      0
B.      1
C.      2
D.      3

DB2 UDB Database Administration

Category: Section 4 - Monitoring DB2 Activity
   
(40/67) Which of the following commands will cause explain snapshots to be captured for SQL statements issued from the Command Line Processor?  
(Select the correct response)
D
   
A.      REBIND CLP PACKAGE
B.      SET CURRENT EXPLAIN SNAPSHOT NO
C.      BIND CLP PACKAGE WITH EXPLSNAP YES
D.      SET CURRENT EXPLAIN SNAPSHOT EXPLAIN

--------------------------------------------------------------------------------



DB2 UDB Database Administration

Category: Section 4 - Monitoring DB2 Activity
   
(39/67) Given the scenario:
user1 Issues :CONNECT TO db1
user2 Issues :CONNECT TO db1
user1 Issues :ALTER BUFFERPOOL BP1 SIZE 10000
user1 Issues :CONNECT RESET
During which of the following does the new size of the BP1 buffer pool get allocated?  
(Select the correct response)
D
   
A.      If user1 now connects to db1
B.      When database db1 is backed up
C.      When user1 issues ALTER BUFFERPOOL
D.      The next time the database is re-activated

--------------------------------------------------------------------------------



DB2 UDB Database Administration

Category: Section 4 - Monitoring DB2 Activity
   
(38/67) Given the DBM configuration information:
Application support layer heap size (4KB)(ASLHEAPSZ) = 15
Database monitor heap size (4KB)(MON_HEAP_SZ) = 48
Sort heap threshold (4KB)(SHEAPTHRES) = 4096
UDF shared memory set size(4KB) (UDF_MEM_SZ) = 256

Which of the following parameters affects whether record blocking for an application will occur?  
(Select the correct response)
A
   
A.      ASLHEAPSZ
B.      SHEAPTHRES
C.      UDF_MEM_SZ
D.      MON_HEAP_SZ

DB2 UDB Database Administration

Category: Section 3 - Database Access
   
(37/67) Which of the following must be performed to join a table from a DB2 database on AIX to a DB2 database on Windows NT within one SQL statement?  
(Select the correct response)
D
   
A.      Create a syncpoint manager database on AIX.
B.      Reference both tables with three part names.
C.      Create a Transaction Monitor Database on AIX.
D.      Set up a nickname on the database on AIX.
E.      Identify one of the databases as a syncpoint manager database.

--------------------------------------------------------------------------------



DB2 UDB Database Administration

Category: Section 3 - Database Access
   
(36/67) Which two of the following can be performed to see the DDL needed to create objects in an existing database?  
(Select all that apply)
AD
   
A.      Use the db2look utility.
B.      Run SELECT * FROM SYSCAT.TABLES.
C.      Click on Show DDL in Visual Explain.
D.      Click on Generate DDL in the Control Center.
E.      Click on the Catalogs tab in the Control Center.

DB2 UDB Database Administration

Category: Section 3 - Database Access
   
(35/67) Which of the following will eliminate duplicate rows in a result set?  
(Select the correct response)
A
   
A.      SELECT DISTINCT col1 FROM table1
B.      SELECT col1 FROM table1 OPTIMIZE FOR 1 ROW
C.      SELECT col1 FROM table1 WHERE col1 IS DISTINCT
D.      SELECT col1 FROM table1 FETCH FIRST 2 ROWS ONLY
E.      SELECT col1 FROM table1 UNION ALL SELECT * FROM table2

--------------------------------------------------------------------------------



DB2 UDB Database Administration

Category: Section 3 - Database Access
   
(34/67) Which of these methods will NOT enforce uniqueness of rows already in the table:  
(Select the correct response)
D
   
A.      Creating a primary key on the table.
B.      Defining a unique index on the table.
C.      Altering the table to add a unique constraint.
D.      Altering an existing column to add a unique constraint.

--------------------------------------------------------------------------------



DB2 UDB Database Administration

Category: Section 3 - Database Access
   
(33/67) Which of the following tools allows users to right click on a table, choose sample contents and then get a list of some records in the table?  
(Select the correct response)
D
   
A.      Table Center
B.      Script Center
C.      Command Center
D.      Control Center
E.      Client Configuration Assistant

DB2 UDB Database Administration

Category: Section 3 - Database Access
   
(32/67) Which of the following System Catalog Table columns can be examined to see if a foreign key has been validated after a load?  
(Select the correct response)
D
   
A.      SYSCAT.TABLES.CONST_VALID
B.      SYSCAT.TABLES.FOREIGN_KEY
C.      SYSCAT.TABLES.KEYS_CHECKED
D.      SYSCAT.TABLES.CONST_CHECKED

--------------------------------------------------------------------------------



DB2 UDB Database Administration

Category: Section 3 - Database Access
   
(31/67) Which of the following utilities allows for the creation of alternative catalog tables that are optimized for ODBC?  
(Select the correct response)
C
   
A.      db2opt
B.      db2ocat
C.      db2odbc
D.      db2catlg

--------------------------------------------------------------------------------



DB2 UDB Database Administration

Category: Section 3 - Database Access
   
(30/67) Given the following data from syscat.tabauth:

GRANTEE TABNAME CONTROLAUTH ALTERAUTH DELETEAUTH INDEXAUTH INSERTAUTH SELECTAUTH
------- ------- ----------- -------- --------- --------- ---------- ----------
USER1 MYTAB Y G G G G G
W MYTAB N N N N Y N
M MYTAB N N N N G Y
K MYTAB N N N N N G

Which of the following users CANNOT view the data in table MYTAB?
  
(Select the correct response)
A
   
A.      W
B.      K
C.      M
D.      user1

DB2 UDB Database Administration

Category: Section 3 - Database Access
   
(29/67) Which of the following DB2 objects allows multiple users to access data in a table with each only being able to access certain portions of the data?  
(Select the correct response)
A
   
A.      Views
B.      Aliases
C.      Indexes
D.      Mirrored Tables
E.      Table Constraints

DB2 UDB Database Administration

Category: Section 3 - Database Access
   
(28/67) Assuming a user has CREATETAB privileges, which of the following will NOT allow the user to create a table T2 with a foreign key that references table T1?  
(Select the correct response)
C
   
A.      SYSCTRL authority
B.      Control privilege on table T1
C.      References privilege on the table T1
D.      References privilege on each column of the parent key

--------------------------------------------------------------------------------


   


DB2 UDB Database Administration

Category: Section 3 - Database Access
   
(27/67) Given the following tables:
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:
1) Candidate identifiers are unique.
2) Test numbers are unique.
3) Referential integrity must be supported between parent table CANDIDATE and dependent table TEST_TAKEN.
Which of the following index constraints must be created?  
(Select the correct response)
C
A.      Foreign key on table candidate
B.      Primary key on table candidate
C.      Foreign key on table test_taken
D.      Primary key on table test_taken

DB2 UDB Database Administration

Category: Section 3 - Database Access
   
(26/67) A query needs to return column data for column C1 in descending alphabetical order. In the access plan, a temporary table cannot be used. Which of the following index types is NOT valid for use with this query?  
(Select the correct response)
C
   
A.      ASCENDING INDEX ALLOWING REVERSE SCANS
B.      DESCENDING INDEX ALLOWING REVERSE SCANS
C.      ASCENDING INDEX DISALLOWING REVERSE SCANS
D.      DESCENDING INDEX DISALLOWING REVERSE SCANS

DB2 UDB Database Administration

Category: Section 3 - Database Access
   

DB2 UDB Database Administration

Category: Section 3 - Database Access
   
(25/67) Which of the following is the purpose for creating a clustering index on a table as opposed to a non-clustering index?  
(Select the correct response)
D
   
A.      Enforces uniqueness of key columns in the table
B.      Provides logical ordering of rows based on key columns of table
C.      Saves disk space when adding rows to tables with an index defined
D.      Rows with equal/near key values are physically stored near each other in the table

--------------------------------------------------------------------------------



DB2 UDB Database Administration

Category: Section 3 - Database Access
   
(24/67) Which of the following DB2 tools can be used to create a DB2 script based on the contents of a previously used script created in the DB2 Script Center?  
(Select the correct response)
A
   
A.      DB2 Command Center
B.      DB2 Control Center
C.      DB2 Command Window
D.      DB2 Command Line Processor
E.      DB2 Stored Procedure Builder

--------------------------------------------------------------------------------



DB2 UDB Database Administration

Category: Section 3 - Database Access
   
(23/67) Which of the following tasks CANNOT be performed from the DB2 Script Center?  
(Select the correct response)
D
   
A.      Check the status of a script execution
B.      Run a saved command script immediately
C.      Schedule a script to run at a later date
D.      Import a DB2 command line processor input file

--------------------------------------------------------------------------------



DB2 UDB Database Administration

Category: Section 2 - Data Placement
   
(22/67) Which of the following objects CANNOT be altered?  
(Select the correct response)
A
   
A.      index
B.      table
C.      nickname
D.      bufferpool
E.      table space

DB2 UDB Database Administration

Category: Section 2 - Data Placement
   
(21/67) Given the following SQL statements:
1) CONNECT TO mydb
2) CONNECT RESET
3) CREATE TABLESPACE ts8 PAGESIZE 8K MANAGED BY SYSTEM
    USING ('D:\file1') BUFFERPOOL bp8
4) CREATE BUFFERPOOL bp8 SIZE 1000 PAGESIZE 8K
5) CREATE TABLE mytab (col1 CHAR(64)) IN ts8
In order for the table to be created with an 8K page size, which of the following indicates the order that the above statements must be executed?  
(Select the correct response)
B
   
A.      1,3,4,5,2
B.      1,4,3,5,2
C.      1,3,2,1,4,5
D.      1,4,2,1,3,5

DB2 UDB Database Administration

Category: Section 2 - Data Placement
   
(20/67) 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
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 statement:
SELECT * FROM PERSON?  
(Select the correct response)
C
   
A.      1
B.      2
C.      3
D.      5
E.      10

DB2 UDB Database Administration

Category: Section 2 - Data Placement
   
(19/67) Given the following:
A System has twenty 4GB disk devices for the database.
Table is named mytab
mytab data portion 17GB
mytab index portion 23GB
Two tablespaces exist
  mydatats
  myindexts
If the table was created as follows:
Create table mytab (...) in mydatats index in myindexts
Given that containers cannot span devices, which of the following is the minimum number of containers that must be created (for all table spaces) in order to hold the expected amount of data?  
(Select the correct response)
C
   
A.      5
B.      10
C.      15
D.      20

DB2 UDB Database Administration

Category: Section 2 - Data Placement
   
(18/67) Which of the following must occur in order to separate index data from table user data?  
(Select the correct response)
A
   
A.      Use DMS table spaces
B.      Use SMS table spaces
C.      Create table space containers on different devices
D.      Ensure table space definition has multiple containers

--------------------------------------------------------------------------------



DB2 UDB Database Administration

Category: Section 2 - Data Placement
   
(17/67) Given the partial output of the command:
GET DATABASE CONFIGURATION FOR db1
Database Configuration for Database db1
Rollforward pending = TABLESPACE
Which of the following commands provides information to determine which table space is in rollforward pending state?  
(Select the correct response)
B
   
A.      GET TABLESPACES
B.      LIST TABLESPACES
C.      SELECT * FROM SYSCAT.TSPACE
D.      GET PENDING STATE TABLESPACES
E.      LIST DATABASE TABLESPACES STATE

DB2 UDB Database Administration

Category: Section 2 - Data Placement
   
(16/67) Which of the following allows containers to be added to an SMS tablespace?  
(Select the correct response)
C
   
A.      BACKUP DATABASE command
B.      ALTER TABLESPACE command
C.      RESTORE DATABASE command
D.      ALTER SMS TABLESPACE command

--------------------------------------------------------------------------------



DB2 UDB Database Administration

Category: Section 2 - Data Placement
   
(15/67) 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 'filea' 1000) WITH "LOGSPACE1"
Which of the following table spaces has all of its storage pre-allocated?  
(Select the correct response)
D
   
A.      LOGSPACE1
B.      TEMPSPACE1
C.      USERSPACE1
D.      SYSCATSPACE

DB2 UDB Database Administration

Category: Section 2 - Data Placement
   
(14/67) Which of the following allows user "manager" (who is a regular user) to control access to schema "city"?  
(Select the correct response)
A
   
A.      CREATE SCHEMA city GRANT TO manager
B.      CREATE SCHEMA city RESTRICT manager
C.      CREATE SCHEMA city AUTHORIZATION manager
D.      CREATE SCHEMA city, when logged on as user "manager"

DB2 UDB Database Administration

Category: Section 2 - Data Placement
   
(13/67) 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 'filea' 1000)
WITH "EXTENTSIZE 8"
How many bufferpools are in the inventory database?  
(Select the correct response)
B
   
A.      0
B.      1
C.      2
D.      3
E.      4

DB2 UDB Database Administration

Category: Section 1 - DB2 Server Management
   
(12/67) Which of the following must be performed to restrict clients from being able to discover ALL DB2 instances on a server?  
(Select the correct response)
D
   
A.      Set the DISCOVER_COMM parameter to NONE.
B.      Set the DISCOVER_DB parameter to DISABLE.
C.      Set the DAS instance parameter SEARCH to DISABLE.
D.      Set the DAS instance parameter DISCOVER to DISABLE.

--------------------------------------------------------------------------------



DB2 UDB Database Administration

Category: Section 1 - DB2 Server Management
   
(11/67) When scheduling a job, certain actions can be specified to take place upon completion or failure of the job. Which two of the following actions does this include?  
(Select all that apply)
AC
   
A.      Run a command script.
B.      Send a page to a pager.
C.      Send a message to the job log.
D.      Re-run the job that just completed.
E.      Send an email to an indicated address.

--------------------------------------------------------------------------------

DB2 UDB Database Administration

Category: Section 1 - DB2 Server Management
   
(9/67) Which of the following is required for the use of TCP/IP between a client and server?  
(Select the correct response)
C
   
A.      A named pipe is established between client and server.
B.      Both the client and server are on Unix operating systems.
C.      The registry variable DB2COMM includes TCPIP at the server.
D.      The registry variable DB2COMM includes TCPIP at the client.

--------------------------------------------------------------------------------



DB2 UDB Database Administration

Category: Section 1 - DB2 Server Management
   
(8/67) Which of the following is NOT possible when issuing a FORCE command?  
(Select the correct response)
D
   
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

--------------------------------------------------------------------------------

DB2 UDB Database Administration

Category: Section 1 - DB2 Server Management
   
(7/67) Given the following piece of a LIST APPLICATIONS output:
Auth Id Application Appl Application Id DB # of
Name Handle  Name Agents
------- ------------ ------ ----------------------- ----- -----
CERT PAYROLL.EXE 7 *LOCAL.DB2.991004124355 STAFF 1

Which of the following commands terminates the client application's connection?  
(Select the correct response)
B
   
A.      KILL APPLICATION (7)
B.      FORCE APPLICATION (7)
C.      DISCONNECT APPLICATION (7)
D.      KILL APPLICATION payroll.exe
E.      FORCE APPLICATION payroll.exe
F.      DISCONNECT APPLICATION payroll.exe

DB2 UDB Database Administration

Category: Section 1 - DB2 Server Management
   
(6/67) Given an application with the embedded static SQL statement:
INSERT INTO
  admin.payroll
  (employee, salary)
VALUES
  ("Joe Smith", 30000)
Which two of the following could be granted insert privilege on table admin.payroll in order for the application to bind successfully for later execution?
  
(Select all that apply)
BD
   
A.      The DB2 group called PUBLIC
B.      The person who binds the application
C.      Each person who executes the application
D.      Each person who executes this section of the package
E.      The non-PUBLIC group of the person binding the package

--------------------------------------------------------------------------------



DB2 UDB Database Administration

Category: Section 1 - DB2 Server Management
   
(5/67) 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?
  
(Select the correct response)
D
   
A.      GRANT SELECT ON TABLE t1 TO ALL
B.      GRANT SELECT ON TABLE t1 TO PUBLIC
C.      GRANT CREATE_VIEW ON TABLE t1 TO ALL
D.      GRANT CREATE_VIEW ON TABLE t1 TO PUBLIC
E.      GRANT SELECT ON TABLE t1 TO USER GroupA, GroupB

--------------------------------------------------------------------------------



DB2 UDB Database Administration

Category: Section 1 - DB2 Server Management
   
(4/67) Given the following:
SYSADM group name (SYSADM_GROUP) = ADMIN
SYSCTRL group name (SYSCTRL_GROUP)= CONTROL
SYSMAINT group name (SYSMAINT_GROUP) = MAINT
Which two of the following determines which users have SYSCTRL authority?
  
(Select all that apply)
CE
   
A.      The node directory
B.      The system catalog
C.      The operating system security
D.      The database configuration file
E.      The database manager configuration file

--------------------------------------------------------------------------------
DB2 UDB Database Administration

Category: Section 1 - DB2 Server Management
   
(3/67) Given an application with the embedded static SQL statement:
INSERT INTO
  admin.payroll
  (employee, salary)
VALUES
  ("Joe Smith", 30000)
Which of the following privileges must a user hold to run the application?  
(Select the correct response)
B
   
A.      ALTER on the table
B.      INSERT on the table
C.      UPDATE on the table
D.      DBADM on the database
E.      EXECUTE on the package




DB2 UDB Database Administration

Category: Section 1 - DB2 Server Management
   
(2/67) In which of the following locations must userids and passwords be defined if using authentication SERVER?  
(Select the correct response)
D
   
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

--------------------------------------------------------------------------------



DB2 UDB Database Administration

Category: Section 1 - DB2 Server Management
   
(1/67) A DB2 server with DB2 Connect installed needs to have the userids and passwords for the DB2 clients going to DB2 for OS/390 validated at the DB2 for OS/390 host. Which of the following authentication levels provides this requirement while providing authentication for other DB2 clients at the DB2 server?  
(Select the correct response)
A
   
A.      DCS
B.      DRDA
C.      HOST
D.      CLIENT
E.      SERVER