최신 IBM certifications I 000-541 무료샘플문제:

1. A database named PAYROLL resides on an IBM System Storage DS8000 and a database administrator would like to use Flash Copy to back up the database. Which command can be used to accomplish this?

A) BACKUP DATABASE payroll USE XBSA
B) BACKUP DATABASE payroll USE SNAPSHOT
C) BACKUP DATABASE payroll USE FU\SHCOPY
D) BACKUP DATABASE payroll USE MIRROR

2. Click the Exhibit button.

IBM 000-541: Practice Exam
What is the result after executing the SELECT statement shown below?
SELECT COUNTO FROM applicant WHERE gender='C'

A) 4
B) 7
C) 0
D) 3

3. If this command is executed:
db2advis -d sample -g
What is the Design Advisor using to perform its analysis?

A) A set of dynamic SQL statements that have been stored in the SYSCAT.WORKLOADS catalog view of a database named SAMPLE.
B) A set of dynamic SQL statements that have been captured by the Query Patroller for a database named SAMPLE.
C) A set of dynamic SQL statements that are stored in a file named db2advise.in that is to be executed against a database named SAMPLE
D) A set of dynamic SQL statements that have been captured by the snapshot monitor for a database named SAMPLE.

4. You want to grant user BOB the ability to create tables in table space PLANS and to grant this privilege to others Which command would you use?

A) GRANT USE OF plans TABLESPACE TO bob WITH GRANT OPTION
B) GRANT USE AND GRANT FOR TABLESPACE plans TO bob
C) GRANT USE OF TABLESPACE plans TO bob WITH GRANT OPTION
D) GRANT USE AND GRANT FOR plans TABLESPACE TO bob

5. A database named PAYROLL resides on an IBM System Storage DS8000 and a database administrator would like to use Flash Copy to back up the database. Which command can be used to accomplish this?

A) BACKUP DATABASE payroll USE XBSA
B) BACKUP DATABASE payroll USE SNAPSHOT
C) BACKUP DATABASE payroll USE FU\SHCOPY
D) BACKUP DATABASE payroll USE MIRROR

질문과 대답: