IBM Assessment DB2 10.1 DBA for Linux, UNIX, and Windows Set 3

1.

Which administrative authority is needed to grant ACCESSCTRL, DATAACCESS, or SECADM authority to other users, groups, or roles?

DBADM SYSADM SQLADM SECADM

2.

What authority is required to grant a user ACCESSCTRL authority?

DBADM SQLADM SECADM DATAACCESS

3.

Which is a valid statement about the Row and Column Access Control (RCAC) feature?

Users with SECADM authority are exempt from RCAC rules. The RCAC feature uses a subset of Label Based Access Control (LBAC) functionality. RCAC is a more powerful security mechanism than Label Based Access Control (LBAC). When a result set is restricted due to the RCAC rules defined on a table, no warnings or errors are returned.

4.

What authority must be held to create a trusted context?

DBADM SQLADM SECADM CONNECT

5.

What authorization is needed to use the AUDIT statement to create an audit policy?

DBADM SYSADM SECADM SYSMAINT

6.

Which statement about the REORGCHK command is true?

It cannot be run against the system catalog. It automatically calls RUNSTATS by default. It cannot be run against multidimensional clustering tables. It automatically calls REORG if it is determined that a reorg is necessary.

7.

You are tasked with using the Export, Import, and Load utilities to move data from a UNIX platform database to a Windows platform database. What file format is recommended for moving data across platforms?

IXF DEL ASC WSF

8.

What is the purpose of the Design Advisor?

To recommend physical changes to objects in a database. To recommend database configuration parameter changes. To generate profiles for autonomic activity within the database. To generate query definitions required to create usage reports.

9.

If the following statement is executed: REORGCHK UPDATE STATISTICS ON TABLE ALL What will happen?

RUNSTATS will be executed on all user tables and a REORGCHK report will be generated. RUNSTATS will be executed on all user and system tables and a REORGCHK report will be generated. RUNSTATS will be executed on all user tables only if statistics have not been collected and a REORGCHKreport will be generated. RUNSTATS will be executed on all system tables only if statistics have not been collected and aREORGCHK report will be generated.

10.

What is the purpose of specifying the RESTART CONTINUE option in an INGEST command?

To terminate a failed INGEST command. To restart a failed INGEST command from the beginning. To clean up the log records of a failed INGEST command. To restart a failed INGEST command from the last commit point.

IBM Assessment DB2 10.1 DBA for Linux, UNIX, and Windows Set 3

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Congratulations

COMPANY

Products

OTHERS

Partner

IBM Assessment DB2 10.1 DBA for Linux, UNIX, and Windows Set 3

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Congratulations

Detail Form

COMPANY

Products

OTHERS

Partner