- 论坛徽章:
- 0
|
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)
A. db2stop
B. db2start
C. attach to an instance
D. connect to a database
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)
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.
Which of the following must occur to restore a database which has table space containers on invalid drives/devices? (Select the correct response)
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.
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)
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
Which of the following CANNOT be used as input to an export?
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
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)
A. DBHEAP
B. SOFTMAX
C. LOGBUFSZ
D. MINCOMMIT
E. CHNGPGS_THRESH
F. APP_CTL_HEAP_SZ
Which of the following is a valid statement to create an event monitor?
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'
Which of the following are functional groups (switches) that can be collected with snapshot monitoring? (Select the correct response)
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
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
Which two of the following can be performed to see the DDL needed to create objects in an existing database? (Select all that apply)
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.
Which of the following utilities allows for the creation of alternative catalog tables that are optimized for ODBC? (Select the correct response)
A. db2opt
B. db2ocat
C. db2odbc
D. db2catlg
Which of the following tasks CANNOT be performed from the DB2 Script Center? 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
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?
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
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?
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.
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?
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
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
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?
A. The node directory
B. The system catalog
C. The operating system security
D. The database configuration file
E. The database manager configuration file |
|
免费注册
发表于 2003-12-15 17:45
