File Info
| Exam | DB2 10 DBA for z/OS |
| Number | C2090-612 |
| File Name | IBM.C2090-612.Prep4Sure.2018-08-08.75q.vcex |
| Size | 39 KB |
| Posted | Aug 08, 2018 |
| Download | IBM.C2090-612.Prep4Sure.2018-08-08.75q.vcex |
How to open VCEX & EXAM Files?
Files with VCEX & EXAM extensions can be opened by ProfExam Simulator.
Coupon: MASTEREXAM
With discount: 20%
Demo Questions
Question 1
Which authority level allows a user to run utilities that change the data in an application database?
- DBCTRL
- SYSOPR
- DBMAINT
- INSTALL SYSOPR
Correct answer: A
Question 2
Which trace gives information about frequent log space shortages?
- Audit trace class(8)
- Statistics trace class(3)
- Accounting trace class(10)
- Performance trace class(4)
Correct answer: B
Explanation:
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?
- DB2
- RACF
- USER
- DEFINER
Correct answer: C
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.)
- SECADM authority.
- ACCESSCTRL authority.
- DATAACCESS authority.
- SYSADM authority when SEPARATE_SECURITY=NO.
- The owner of the object as he/she has that authority implicitly.
Correct answer: AD
Question 5
Which connection type can exploit trusted connections?
- IMS
- CAF
- CICS
- RRSAF
Correct answer: D
Question 6
What should be implemented in order to audit all the activity of the install SYSADM?
- DATA CAPTURE CHANGES should be set on all tables.
- A DB2 audit policy should be established, identifying the SYSADM ID to be audited.
- The DB2 authorization exit should be modified to convert the install SYSADM ID to another ID
- Nothing can be done, the install SYSADM has the highest authority and is not controlled or monitored.
Correct answer: B
Question 7
Which attribute(s) determine the absolute maximum number of partitions for a partition-by-growth table space?
- MAXPARTITIONS
- MAXPARTITIONS, DSSIZE
- MAXPARTITIONS, page size
- MAXPARTITIONS, DSSIZE, page size
Correct answer: D
Explanation:
Question 8
Which ALTER TABLE statement will generate a new table space version?
- ALTER TABLE ... ADD PARTITION ...
- ALTER TABLE ... ADD COLUMN COL2 ...
- ALTER TABLE ... DATA CAPTURE CHANGES ...
- Altering an already existing VARCHAR column on the table to shorten its maximum length.
Correct answer: B
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?
- ALTER TABLE TB1 AUDIT CHANGES;
- ALTER TABLE TB1 ADD COLUMN COLC DATE;
- ALTER TABLE TB1 RENAME COLUMN COLA TO COLC;
- ALTER TABLE TB1 ADD COLUMN COLC CHAR(8) NOT NULL WITH DEFAULT AS SECURITY LABEL;
Correct answer: B
Question 10
When defining a foreign key on a table, which statement is true?
- It is not mandatory to have an index on the foreign key columns but it can help to avoid locking problems.
- There is no need to define an index on the foreign key columns as DB2 cannot use an index for foreign key checking.
- 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.
- 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.
Correct answer: A
