Massive Summer Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: netdisc

IBM P2090-018 IBM Information Management DB2 10 Technical Mastery Test v3 Exam Practice Test

Demo: 5 questions
Total 35 questions

IBM Information Management DB2 10 Technical Mastery Test v3 Questions and Answers

Question 1

Which of the following options best defines the Label-Based Access Control (LBAC) feature?

Options:

A.

DB2 LBAC allows you to use labels to reference database objects by a short name instead of the full qualified name.

B.

DB2 LBAC lets you decide exactly who has write/read access to individual rows and columns by comparing the security labels between database objects and users.

C.

DB2 LBAC monitors table data access and tables modifications made by database users.

D.

DB2 LBAC is the DB2 authority in charge of issuing GRANT and REVOKE statements.

Question 2

What are some of the benefits of DB2 Express?

Options:

A.

DB2 Express has affordable licensing terms with all of the core features of the DB2 engine.

B.

DB2 Express is designed for development and testing. It is not used as a production database.

C.

DB2 Express is fastest and most powerful DB2 edition.

D.

DB2 Express is a tool that allows DBAs to quickly solve complex database issues.

Question 3

Which one of the following options contains a benefit of the Java Generic Table Functions?

Options:

A.

Java Generic Table Functions allow you to specify the output of a table function when you create it, rather than when you reference it.

B.

Java Generic Table Functions allow you to specify the output of a table function when you reference it, rather than when you create it.

C.

Java Generic Table Functions must run on a separate server, thus they don't consume DB2 resources.

D.

Java Generic Table Functions can be implemented in any programming language.

Question 4

How does automatic storage work in DB2?

Options:

A.

Automatic storage simplifies storage management by allowing you to specify storage paths where the database manager can place table space data.

B.

Automatic storage is an option which is set when you create a DB2 database. It allows transactions that are executed to be automatically committed.

C.

Automatic storage is a function of DB2 that allows tables to be backed up automatically on a set schedule.

D.

Automatic storage allows automatic allocation of free space in memory for optimizing query execution.

Question 5

Which DB2 licensing type is based on the number of users allowed to access the data server?

Options:

A.

PVU (Processor Value Unit) licensing

B.

Sub-capacity licensing

C.

Authorized User (AU) licensing

D.

Per Server licensing

Demo: 5 questions
Total 35 questions