Decide Fast & Get 50% Flat Discount on This Summer Discount offer | Limited Time Offer - Ends In COUPON CODE: Summer50

Home
Dumps
IBM
C2090-318

Practice IBM C2090-318 Exam Questions

1. Page: 1/12
  Total 60 Questions
Question No 1

Which of the following can be accomplished by altering a table to use column access control?

Choose the Choices:

Restrict the access to specific rows for all or some users

Hide column definitions from the DB2 catalog table SYSIBM.SYSCOLUMNS

Pre - materialize a view with the changed values provided by the column mask

Modify the values returned for table columns based on column masking definitions

D
Question No 2

Which of the following is an advantage of role - based security?

Choose the Choices:

If you DROP a role that owns objects, those objects will also be dropped

Within a trusted connection. DB2 allows multiple roles to be associated with any given thread at any point in time

Roles are used to provide a more flexible technique than security group definitions or userids in assigning and controlling authorization

If a role creates an object, a user requires no additional privileges to access the object if the access uses that role as the object owner in the SQL statement

A
Question No 3

For best DB2 lock avoidance, which of the following BIND/REBIND options should be included in the REBIND command execution?

Choose the Choices:

ACQUIRE(USE)ISOLATION(CS)

ACQUIRE(USE)ISOLATION(RR)

CURRENTDATA(NO)ISOLATION(CS)

CURRENTDATA(YES) ISOLATION(CS)

C
Question No 4

Which authority prevents unintended access to user data but allows installation or migration of a DB2 subsystem?

Choose the Choices:

SYSADM

SYSCTRL

Installation SYSADM

Installation SYSOPR

D
Question No 5

Which of the following is TRUE about the SYSCTRL authority?

Choose the Choices:

It is designed to allow access to all data directly in DB2

It is designed not to be a part of the administrative authorizations

It is designed so group privileges cannot be granted to SYSCTRL

It is designed to be an administrator in a system with sensitive data

D
1. Page: 1/12
  Total 60 Questions
  
  Buy Now Latest Questions
Full Access
C2090-318 Exam Features

In Just $79 Access Your All Questions

All Official Question Types

Interactive Web-Based Practice Test Software

No Installation or 3rd Party Software Required

Practice your Exam Questions (Free Demo)

24/7 Customer Support

Buy Now
Full Access
C2090-318 PDF Dumps

In Just $ Access All PDF Questions

All Official Question Types

PDF Practice Questions & Answers

Printable & Portable Format

Download PDF Questions (Free Demo)

24/7 Customer Support

Buy Now