Download DB2 10 DBA for z-OS.Prep4sure.C2090-612.2018-08-08.1e.75q.vcex

Download Dump

File Info

Exam DB2 10 DBA for z/OS
Number C2090-612
File Name DB2 10 DBA for z-OS.Prep4sure.C2090-612.2018-08-08.1e.75q.vcex
Size 39 Kb
Posted August 08, 2018
Downloaded 1



How to open VCEX & EXAM Files?

Files with VCEX & EXAM extensions can be opened by ProfExam Simulator.

Purchase
Coupon: EXAM_HUB

Coupon: EXAM_HUB
With discount: 20%

 
 



Demo Questions

Question 1
Which authority level allows a user to run utilities that change the data in an application database? 


  • A: DBCTRL
  • B: SYSOPR
  • C: DBMAINT
  • D: INSTALL SYSOPR



Question 2
Which trace gives information about frequent log space shortages?

  • A: Audit trace class(8)
  • B: Statistics trace class(3)
  • C: Accounting trace class(10)
  • D: Performance trace class(4)



Question 3
When creating a stored procedure that will access non DB2 resources using the authorization ID of the user invoking the stored procedure, what value must the SECURITY clause specify?

  • A: DB2
  • B: RACF
  • C: USER
  • D: DEFINER



Question 4
Row and column level security can be implemented using mask and permissions. Which two DB2 authorities are able to create a mask or permission? (Choose two.)

  • A: SECADM authority.
  • B: ACCESSCTRL authority.
  • C: DATAACCESS authority.
  • D: SYSADM authority when SEPARATE_SECURITY=NO.
  • E: The owner of the object as he/she has that authority implicitly.



Question 5
Which connection type can exploit trusted connections?

  • A: IMS
  • B: CAF
  • C: CICS 
  • D: RRSAF



Question 6
What should be implemented in order to audit all the activity of the install SYSADM?

  • A: DATA CAPTURE CHANGES should be set on all tables.
  • B: A DB2 audit policy should be established, identifying the SYSADM ID to be audited.
  • C: The DB2 authorization exit should be modified to convert the install SYSADM ID to another ID
  • D: Nothing can be done, the install SYSADM has the highest authority and is not controlled or monitored.



Question 7
Which attribute(s) determine the absolute maximum number of partitions for a partition-by-growth table space?

  • A: MAXPARTITIONS
  • B: MAXPARTITIONS, DSSIZE
  • C: MAXPARTITIONS, page size
  • D: MAXPARTITIONS, DSSIZE, page size



Question 8
Which ALTER TABLE statement will generate a new table space version?

  • A: ALTER TABLE ... ADD PARTITION ...
  • B: ALTER TABLE ... ADD COLUMN COL2 ...
  • C: ALTER TABLE ... DATA CAPTURE CHANGES ...
  • D: Altering an already existing VARCHAR column on the table to shorten its maximum length.



Question 9
Given that the following table (TB1) has been created with this statement: CREATE TABLE TB1 (COLA SMALLINT NOT NULL WITH DEFAULT ,COLB CHAR(5) NOT NULL WITH DEFAULT) IN DB1.TS1; Which of the following statements, which alter a table (TB1), will NOT invalidate all the plans, packages and dynamic cache statements associated with the table TB1?

  • A: ALTER TABLE TB1 AUDIT CHANGES;
  • B: ALTER TABLE TB1 ADD COLUMN COLC DATE;
  • C: ALTER TABLE TB1 RENAME COLUMN COLA TO COLC;
  • D: ALTER TABLE TB1 ADD COLUMN COLC CHAR(8) NOT NULL WITH DEFAULT AS SECURITY LABEL;



Question 10
When defining a foreign key on a table, which statement is true? 


  • A: It is not mandatory to have an index on the foreign key columns but it can help to avoid locking problems.
  • B: There is no need to define an index on the foreign key columns as DB2 cannot use an index for foreign key checking.
  • C: It is not mandatory to have an index on the foreign key columns but it can help performance when you insert rows into this table.
  • D: You must define an index on the foreign key columns where the index columns are the same as the foreign key columns to guarantee uniqueness of the foreign key.









CONNECT US


ProfExam
PROFEXAM WITH A 20% DISCOUNT

You can buy ProfExam with a 20% discount..

Get Now!


HOW TO OPEN VCEX AND EXAM FILES

Use ProfExam Simulator to open VCEX and EXAM files
ProfExam Screen



HOW TO OPEN VCE FILES

Use VCE Exam Simulator to open VCE files
Avanaset