Given the following table spaces, their associated page size, and number of pages:
Which sets of buffer pools will ensure that all of the data in the table spaces will be fit into memory for optimal data access?
A. BP1 - 4K page size, 30000 pages BP2 - 8K page size, 20000 pages BP3 - 16K page size, 15000 pages
B. BP1 - page size 8K, 45000 pages
C. IBMDEFAULTBP - 4K page size, 25000 pages BP1 -16K page size, 20000 pages
D. IBMDEFAULTBP - 16K page size, 85000 pages
正解:A
質問 2:
Which command CANNOT be used to create the compression dictionary for a table?
A. INSPECT
B. RUNSTATS
C. LOAD
D. IMPORT
正解:B
質問 3:
A database recovery operation (RECOVER DATABASE) failed during the roll forward phase. The DBA wants to force the RECOVER DATABASE to redo the restore phase. What must occur to accomplish this?
A. The RECOVER DATABASE operation must be terminated and a new RECOVER DATABASE command must be issued.
B. A RECOVER DATABASE command must be issued with the TO END OF LOGS option specified.
C. A RECOVER DATABASE command must be re-issued with the REPLACE option specified.
D. A RECOVER DATABASE command must be issued with the RESTART option specified.
正解:D
質問 4:
A database named MYDB was created by executing the following command: CREATE DATABASE mydb AUTOMATIC STORAGE NO Later, a decision is made to modify this database so that both it and its table spaces use automatic storage. What steps are required to make this modification?
A. Use the ALTER DATABASE command to convert the database; use the ALTER TABLESPACE command to convert all existing table spaces.
B. Use the ALTER DATABASE command to convert the database; use the ALTER TABLESPACE command to convert all existing SMS table spaces.
C. Use the ALTER DATABASE command to convert the database; use the ALTER TABLESPACE command to convert all existing DMS table spaces.
D. Use the ALTER DATABASE command to convert the database; all existing table spaces will be converted automatically.
正解:C
質問 5:
If you know that the table space containers for your database reside on RAID-5 3+p arrays, which registry variable should be assigned the value *:3 to help improve performance?
A. DB2_EXTENDED_IO_FEATURES
B. DB2_APM_PERFORMANCE
C. DB2_PARALLEL_IO
D. DB2_RESOURCE_POLICY
正解:C
質問 6:
While attempting to establish connectivity between a Windows client and a UNIX server, the following commands were issued from the Windows client:
CATALOG TCPIP NODE node001 REMOTE hostnm01 SERVER 50000;
CATALOG DATABASE samp001 AS samp001 AT NODE node001;
TERMINATE;
When trying to connect to the SAMP001 database the following error was received: SQL30061N The database alias or database name name was not found at the remote node.
The database name is not an existing database at the remote database node. The statement cannot be processed. What should be done resolve the problem?
A. Add a Database Connection Services entry to the /etc/services file on the Windows client.
B. Match the port number in the CATALOG TCPIP NODE command with the port number in the /etc/services file on the remote server.
C. Add an entry into the Database Connection Services directory on the Windows client.
D. Change the service name (SVCENAME) in the remote servers database configuration.
正解:D
質問 7:
What will the db2audit facility do when a DB2 database instance is stopped?
A. Remain active.
B. Stop automatically.
C. Generate an error stating that the audit facility should be stopped prior to stopping the instance.
D. Write an error message to the audit log and stop automatically.
正解:A
質問 8:
At which two levels can events be audited? (Choose two.)
A. Instance level
B. Server level
C. Database level
D. Operating System level
E. Node level
正解:A,C
西方** -
重要なキーワードや解説も丁寧で基礎も含めてこれC2090-544一冊で十分カバー出来ます。