Latest Certified Success Dumps Download

CISCO, MICROSOFT, COMPTIA, HP, IBM, ORACLE, VMWARE
000-611 Real Tests (May 2017)

[Free] 2017(May) Ensurepass Pass4sure IBM 000-611 Real Tests 11-20

May 4, 2017

Ensurepass
2017 May IBM Official New Released 000-611 Q&As
100% Free Download! 100% Pass Guaranteed!
http://www.ensurepass.com/000-611.html

DB2 10.1 DBA for Linux, UNIX, and Windows

QUESTION 11

If the current value for self-tuning memory is: Self Tuning Memory (SELF_TUNING_MEM) = ON (Inactive) Which statement is true?

 

A.

Self-tuning is occurring only on the instance memory area.

B.

The memory tuner is actively tuning the memory on the system.

C.

Self-tuning is not occurring because it is waiting for the database to be recycled.

D.

Self-tuning is not occurring because there are less than two memory consumers enabled.

 

Correct Answer: D

 

 

QUESTION 12

What are two types of security label components that can be used with Label-Based Access Control (LBAC)? (Choose two).

 

A.

Set

B.

Tree

C.

Group

D.

Range

E.

Hierarchy

 

Correct Answer: AB

 

 

QUESTION 13

Where are column mask definitions stored?

 

A.

In the table definition

B.

In the system catalog

C.

In the table space metadata

D.

In the database configuration file

 

Correct Answer: B

 

 

QUESTION 14

Which statement is correct when describing trusted contexts?

 

A.

A trusted context defines a trust relationship for a connection between the database and an external entity.

B.

A trusted context promotes the authorization level of the connection initiator and grants them DBADM authority.

C.

A trusted context defines a trust relationship between a user and a table allowing that user additional capabilities.

D.

A trusted context gives the database connection the ability to bypass auditing since authentication has already occurred.

 

Correct Answer: A

 

 

QUESTION 15

A table named SALES was created as follows:

 

clip_image002

 

If management wants to use Label-Based Access Control (LBAC) to protect individual rows in the SALES table, and the security policy needed (SEC_POLICY) has already been created, what must be done to protect the table as desired?

 

A.

Associate the SEC_POLICY security policy with the SALES table.

B.

Add a column with the DB2SECURITYLABEL data type to the SALES table.

C.

Add a column with the DB2SECURITYLABEL data type to the SALES table and then associate the SEC_POLICY security policy with the table.

D.

Add a SECURED WITH clause to every column in the SALES table and then associate the SEC_POLICY security policy with the SALES table.

 

Correct Answer: C

 

 

QUESTION 16

Which authorities can be audited with the AUDIT statement?

 

A.

SECADM, DBADM, SYSMAINT, and SYSCTRL can be audited, but SYSADM cannot.

B.

SYSADM, DBADM, SYSMAINT, and SYSCTRL can be audited, but SECADM cannot.

C.

SYSADM, SECADM, DBADM, SQLADM, ACCESSCTRL, and DATAACCESS can be audited.

D.

DBADM, SYSMAINT, ACCESSCTRL, and DATAACCESS can be audited, but SYSADM and SECADM cannot.

 

Correct Answer: C

 

 

QUESTION 17

Which authority is required to revoke SECADM authority?

 

A.

DBADM

B.

SECADM

C.

SYSADM

D.

SQLADM

 

Correct Answer: B

 

 

 

 

 

QUESTION 18

Which statement regarding SECADM authority is true?

 

A.

The instance owner has SECADM authority by default.

B.

PUBLIC cannot receive SECADM authority, either directly or indirectly.

C.

Only users with SECADM authority are allowed to grant the CONNECT database authority to others.

D.

The SECADM_GROUP database manager configuration parameter determines who has SECADM authority by default.

 

Correct Answer: B

 

 

QUESTION 19

What authorization is needed to execute the CREATE MASK statement?

 

A.

SECADM

B.

SQLADM

C.

SYSADM

D.

SYSCTRL

 

Correct Answer: A

 

 

QUESTION 20

Which statement is correct for a user who holds SECADM authority?

 

A.

A user who holds SECADM authority can only grant and revoke database object privileges.

B.

A user who holds SECADM authority can grant and revoke all database level authorities and database object privileges.

C.

A user who holds SECADM authority can only grant and revoke DBADM and SECADM database level authorities.

D.

A user who holds SECADM authority can only grant and revoke label based access control (LBAC) security labels.

 

Correct Answer: B

100% Free Download!
—Download Free Demo:000-611 Demo PDF
100% Pass Guaranteed!
Download 2017 Ensurepass 000-611 Dumps Q&As:118
—Get 10% off your purchase! Copy it:TJDN-947R-9CCD [2017.05.01-2017.05.31]

Ensurepass ExamCollection Testking
Lowest Price Guarantee Yes No No
Up-to-Dated Yes No No
Real Questions Yes No No
Explanation Yes No No
PDF + VCE Yes No No
Free VCE Simulator Yes No No
Instant Download Yes No No

2017 Ensurepass IT Certification PDF and VCE