CompTIA
Checkpoint
ISC
HP
Dell
EC-Council
EXIN
Fortinet
ITIL®
Juniper
PMI
Microsoft
VMware
Avaya
Google
Salesforce
Amazon
Palo Alto Networks
Certiport
ISC2
All Vendors
  2. Home
  3. Exams
  4. IBM
  5. C2090-600

Free C2090-600 Exam Braindumps (page: 4)

Page 3 of 16
PDF with 60 Questions

If the following SQL statements are executed:

CREATE DATABASE testdb AUTOMATIC STORAGE NO;
CONNECT TO testdb;
CREATE STOGROUP sg1 ON ‘/data1’;
CREATE STOGROUP ibmstogroup ON ‘/data2’; CREATE
STOGROUP sg2 ON ‘/data3’;

Which storage group is the default storage group for the TESTDB database?

  1. SG1
  2. SG2
  3. IBMSTOGROUP
  4. IBMDEFAULTTSG

Answer(s): C


Reference:

https://www.tutorialspoint.com/db2/db2_storagegroups.htm



If Secure Sockets Layer is a requirement, which of the following parameters must be set to encrypt data in transit?

  1. Set the DB2COMM registry variable to DB2COMM=SSL
  2. Set the DB2COMM registry variable to DB2COMM=SSL, TCPIP
  3. Set the AUTHENTICATION configuration parameter to DATA_ENCRYPT
  4. Set the AUTHENTICATION configuration parameter to SERVER_ENCRYPT

Answer(s): B


Reference:

https://www.ibm.com/developerworks/data/library/techarticle/dm-1306securesocketlayers/



Automatic space reclamation for column-organized tables can be accomplished in which of the following scenarios?

  1. When the registry variable DB2_AUTORECLAIMSPACE=YES
  2. After termination all the back-end processes using TERMINATE command
  3. After setting the database configuration parameter AUTO_DEL_REC_OBJ to ON
  4. When the registry variable DB2_WORKLOAD=ANALYTICS prior to database creation

Answer(s): C


Reference:

https://www.ibm.com/support/knowledgecenter/SSEPGG_11.1.0/com.ibm.db2.luw.admin.perf.doc/doc/c0061069.html



Which security mechanism is responsible for verifying that users are indeed who the claim to be?

  1. Authentication
  2. Roles and privileges
  3. Mandatory access control
  4. Discretionary access control

Answer(s): A


Reference:

https://www.ibm.com/support/knowledgecenter/en/SSEPGG_9.7.0/com.ibm.db2.luw.admin.sec.doc/doc/c0005435.html






Post your Comments and Discuss IBM C2090-600 exam with other Community members:

C2090-600 Discussions & Posts