A DB2 for AIX server has two instances named DEV and PROD. Each instance contains a database named ACCOUNTS and a database named PAYROLL. What can be done to prevent a DB2 Discovery operation from seeing the DEV instance and its databases?
A. Set the DISCOVER DB2 administration server (DAS) configuration parameter on the server to DISABLE.
B. Set the DISCOVER_DB database manager configuration parameter for the DEV instance to DISABLE.
C. Set the DISCOVER_INST database manager configuration parameter for the DEV instance to DISABLE.
D. Set the DISCOVER DB2 administration server (DAS) configuration parameter on the client to DISABLE.
正解:C
質問 2:
Which command can be used to restore a corrupted database using only the recovery history file?
A. ROLLFORWARD DATABASE
B. RESTORE DATABASE
C. RECOVER DATABASE
D. RESTART DATABASE
正解:C
質問 3:
Due to a hardware failure, it appears that there may be some corruption in database DB_1 as DB2 is reporting a "bad page". DB2DART is performed for the entire database and it appears that several bad pages were detected in table space TBSP_1. What command should be used to recover the database and repair the corruption in table space TBSP_1?
A. ROLLFORWARD DATABASE
B. RESTORE DATABASE
C. RESTORE TABLESPACE
D. RESTART DATABASE
正解:B
質問 4:
What is the purpose of specifying the RESTART CONTINUE option in an INGEST command?
A. To terminate a failed INGEST command.
B. To clean up the log records of a failed INGEST command.
C. To restart a failed INGEST command from the last commit point.
D. To restart a failed INGEST command from the beginning.
正解:C
質問 5:
Which statement describes a way to minimize the impact of a RUNSTATS operation?
A. Limit the number of pages and rows processed by using page-level or row-level table sampling.
B. Execute the RUNSTATS command with the DETAILED UNSAMPLED option specified.
C. Execute the RUNSTATS command with the WITH DISTRIBUTION option specified.
D. Reduce I/O by using a shadow table space for statistics collection.
正解:A
質問 6:
Which data movement utility is suitable for moving and processing large amounts of real-time data without affecting availability?
A. IMPORT WITH BUFFERED INSERT
B. INGEST
C. REPLICATION
D. LOAD WITH READ ACCESS
正解:B
質問 7:
A table named CUSTOMER and an index named CUST_IDX were created as follows:

Which operation would you expect to see in the access plan diagram produced?
A. NLJOIN
B. HSJOIN
C. TBSCAN
D. IXSCAN
正解:D
久保** -
A2090-611問題集が大好きです。全面的で、覚えやすくて、そして、合格率が高いです。A2090-611試験をパスしたい場合、A2090-611問題集を選びましょう!