Welcome to KillTest.com

TOP Exams

Want to practice some free IBM C2090-318 exam questions? You can study the following IBM C2090-318 exam online questions. Killtest provides 60 Q&As for IBM C2090-318 exam, which has been proven effective in the C2090-318 exam preparation. Besides, you can get full payment fee refund if you fail C2090-318 exam by using Killtest C2090-318 practice exam questions. Ready? Go!

 Get C2090-318 with 60 Q&As

IBM C2090-318 Online Practice Exam Questions

The questions of C2090-318 were last updated on Jun 17,2021 .

Viewing page 1 out of 4 pages.

Viewing questions 1 out of 20 questions

Question#1

Which of the following is TRUE about the SYSCTRL authority?

A. It is designed to allow access to all data directly in DB2
B. It is designed not to be a part of the administrative authorizations
C. It is designed so group privileges cannot be granted to SYSCTRL
D. It is designed to be an administrator in a system with sensitive data

Explanation:
https://www.ibm.com/support/knowledgecenter/SSEPEK_10.0.0/seca/src/tpc/db2z_sysctrla uthority.html
The SYSCTRL authority is designed for administering a system that contains sensitive data. With the SYSCTRL authority, you have nearly complete control of
the DB2® subsystem. However, you cannot access user data directly unless you are explicitly granted the privileges to do so.

Question#2

At what point in the upgrade process is the catalog migrated to DB2 12?

A. Completion of DSNTIJTC job
B. At the completion of CATMAI NT in function level 500
C. After issuing command -ACTIVATE FUNCTION LEVEL (V12R1M100)
D. After issuing command -ACTIVATE FUNCTION LEVEL (V12R1M500)

Question#3

Which service class does not have a goal, but runs with a fixed dispatching priority above all of the other work on the system?

A. ONLINE
B. SYSSTC
C. SYSTEM
D. SYSOTHER

Question#4

To simulate a new buffer pool size, what buffer pool parameter is used?

A. PGFIX
B. VPSIZE
C. SPSIZE
D. AUTOSI2E

Question#5

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

A. If you DROP a role that owns objects, those objects will also be dropped
B. Within a trusted connection. DB2 allows multiple roles to be associated with any given thread at any point in time
C. Roles are used to provide a more flexible technique than security group definitions or userids in assigning and controlling authorization
D. 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

Exam Code: C2090-318
Q & A: 60 Q&As
Updated:  Jun 17,2021

 Get C2090-318 Full Version

KILLTEST CONTACT INFO

[email protected]

GMT+8: Mon-Sat 8:00-18:00

GMT: Mon-Sat 0:00-10:00