C2090-320 Exam Questions - Online Test

C2090-320 Premium VCE File

Learn More 100% Pass Guarantee - Dumps Verified - Instant Download
150 Lectures, 20 Hours

Act now and download your IBM C2090-320 test today! Do not waste time for the worthless IBM C2090-320 tutorials. Download Up to the minute IBM DB2 11 Fundamentals for z/OS exam with real questions and answers and begin to learn IBM C2090-320 with a classic professional.

P.S. Simulation C2090-320 dump are available on Google Drive, GET MORE: https://drive.google.com/open?id=1XIupSsBUtO-ijoq0DwWZR2atFXSuzaPm

New IBM C2090-320 Exam Dumps Collection (Question 1 - Question 10)

Q1. Which of the following is TRUE for using LOAD on a partition-by-growth table space?

A. Data can only be loaded at the partition level

B. Data can only be loaded at the table space level

C. Data can only be loaded using a clustering index

D. Data can be loaded at either the table space level or the partition level

Answer: A

Q2. You are designing a payroll table that will contain a salary column. Which of the following is the appropriate built-in data type for a salary column?

A. REAL

B. BIGINT

C. DECIMAL

D. INTEGER

Answer: C

Q3. Given the following CREATE TABLE statement, and a unique index on column EMPID, which set of SQL statements is valid?

A.

B.

C.

D.

Answer: D

Q4. If a scrollable cursor is INSENSITIVE, which of the following applies?

A. The cursor is read only

B. WITH ROWSET POSITIONING is not allowed

C. The select-statement must not contain an SQL data change statement

D. The cursor has sensitivity to changes that are made to the database after the result table is materialized

Answer: A

Q5. Which statement is TRUE regarding catalog table SYSIBM.SYSROUTINES?

A. Contains scheduled tasks for the administrative scheduler

B. Contains information about UDFs, BIFs and stored procedures

C. Contains information about bound packages

D. Contains information about UDFs and stored procedures

Answer: D

Q6. Which of the following tables can be used to set the default of the special register CURRENT APPLICATION COMPATIBILITY for remote users?

A. The resource limit facility table authid.DSNRLMTxx

B. The DB2 catalog table SYSIBM.SYSENVIRONMENT

C. The profile table SYSIBM.DSN_PROFILE_ATTRIBUTES

D. The communications database table SYSIBM.USERNAMES

Answer: C

Q7. Given a non-partitioned table space TS1 is built with LOCKSIZE ROW, LOCKMAX 1000 and SEGSIZE 64. If a unit of work acquires 1001 locks against table space TS1, the lock will be escalated to which of the following levels?

A. PAGE

B. TABLE

C. PARTITION

D. TABLESPACE

Answer: C

Q8. Which of the following statements concerning a bi-temporal table is TRUE?

A. It provides business history, but is not useful for audit purposes

B. It is defined with both an application period and a system period

C. It is useful for audit purposes, but is not useful for business history

D. It contains data reflecting two different times u2013 current time and one previous time

Answer: B

Q9. Consider the following scenario:

User1 creates table USER1.TABLE1 in DATABASE1 User1 grants ALL PRIVILEGES on TABLE1 to User2 User2 grants ALL PRIVILEGES on TABLE1 to User3 User1 revokes ALL PRIVILEGES on TABLE1 to User2 User3 has DBCTRL authority on DATABASE1

Is User3 able to retrieve rows from TABLE1?

A. No

B. Yes

C. No, if the revoke used INCLUDING DEPENDENT PRIVILEGES

D. Yes, if User3 was granted DBCTRL prior to the creation of table USER1.TABLE1

Answer: B

Q10. You want to limit the access of a table to allow users to only see certain columns and/or rows.

Which of the following options CANNOT be used to accomplish this?

A. A view

B. Multilevel security

C. An MQT (Materialized Query Table)

D. A combination of row permissions and column masks

Answer: C

P.S. Easily pass C2090-320 Exam with Thedumpscentre Simulation Dumps & pdf vce, Try Free: http://www.thedumpscentre.com/C2090-320-dumps/ ( New Questions)