A2090-731 Exam free PDF download

http://www.passfine.com/A2090-731.html
http://www.passfine.com/pdf/A2090-731.pdf
http://www.passfine.com/IBM-certifications-I-cert.html
Exam Number/Code : A2090-731
Exam Name : Assessment: DB2 9 DBA for LUW-Assessment
Questions and Answers : 115 Q&As
Update Time: 2014-06-05


QUESTION NO: 1
Given the following CREATE TABLE statement:
CREATE TABLE employee
(
empno CHAR(6) NOT NULL,
firstnmeVARCHAR(12),
midinit CHAR(1),
lastnameVARCHAR(15),
workdept CHAR(3)
)
Which of the following statements prevents two employees with the same first name, middle initial,
and last name from being inserted into the table, but allows NULL values?
A. CREATE INDEX e1 ON employee(firstnme, midinit, lastname)
B. CREATE UNIQUE INDEX e1 ON employee(firstnme, midinit, lastname)
C. ALTER TABLE employee ADD CONSTRAINT const1UNIQUE(firstnme, midinit, lastname)
D. ALTER TABLE employee ADD CONSTRAINT const1PRIMARY KEY(firstnme, midinit,
lastname)
Answer: B


QUESTION NO: 2
A database administrator needs to benchmark a database for both SQL and XOUERY. What utility
can be used to accomplish this task?
A. db2batch
B. db2explain
C. db2analyze
IBM A2090-731 Exam
"Pass Any Exam. Any Time." - www.actualtests.com 2
D. db2benchmark
Answer: A


QUESTION NO: 3
Which of the following commands will re-initialize the commit counter reported by the snapshot
monitor?
A. RESET MONITOR ALL
B. ZERO MONITOR COUNTERS
C. ZERO MONITOR FOR COMMIT
D. RESET MONITOR FOR COMMIT
Answer: A


QUESTION NO: 4
A database named QA that was using archival logging crashed. An attempt
to restart it failed with error code SOL0290N. Examination of the db2diag.log shows that the disk
drive containing the system catalog table space SYSCATSPACE is not responding. Backup
images of both the QA database and the SYSCATSPACE table space exist. After replacing the
failed disk drive, what is the quickest method to bring the QA database back online?
A. Restore the QA database from the latest off-line backup image.
B. Restore the QA database from the latest off-line backup image and rollforward to end of logs.
C. Restore the System Catalog table space from the latest SYSCATSPACE backup image without
rolling forward.
D. Restore the System Catalog table space from the latest SYSCATSPACE backup image and
rollforward to end of logs.
Answer: D


QUESTION NO: 5
A non-administrative user, USER1, can no longer access a view on which
they have been granted SELECT privilege. The DBA examines the SYSCAT.VIEWS catalog view
and finds that the view has been marked inoperative. In order to allow this view to be accessed by
the user, which of the following should be done?
A. Determine the CREATE VIEW statement in the SYSCAT.VIEWS catalog view, DROP the
inoperativeview and issue the determined CREATE VIEW statement.
B. Determine the CREATE VIEW statement in the SYSCAT.VIEWS catalog view, issue the
CREATE VIEWstatement, and grant SELECT privilege to USER1.
C. Determine the CREATE VIEW statement from a database backup and recreate the view
issuing this CREATE VIEWstatement.
D. Determine the inoperative view, issue the ALTER VIEW statement, and grant SELECT privilege
to USER1.
Answer: B


QUESTION NO: 6
Which of the following is the correct command for obtaining detailed information about a table
space, including its current status?
A. list tablespaces
B. list tablespaces show detail
C. list tablespace containers show detail
D. get snapshot for tablespace containers on sample
Answer: B