All About Certified C2090-320 Free Draindumps

NEW QUESTION 1
Which of the following can be defined on the basis of a query?

• A. An alias
• B. A base table
• C. An accelerator-only table
• D. A materialized query table

Answer: D

NEW QUESTION 2
How can a stored procedure be invoked?

• A. Via an SQL SELECT statement
• B. Via a CALL statement using SPUFI
• C. Directly via a RUN PROGRAM command
• D. Via a CALL statement from within an application program

Answer: D

NEW QUESTION 3
Given the following sequence of events:
* 1) COL1 in SCHEMA.TABLE has a value of 10
* 2) Update COL1 in SCHEMA.TABLE to 20
* 3)SetSAVEPOINTA
* 4) Update COL1 in SCHEMA.TABLE to 30
* 5)SetSAVEPOINTB
After issuing the statement: ROLLBACK TO SAVEPOINT
What will be the value in COL1 of the SCHEMA.TABLE?

• A. 10
• B. 20
• C. 30
• D. An -880 SQLCODE will be issued when the statement is executed

Answer: D

NEW QUESTION 4
Why would an SQL statement receive an SQLCODE of +100? (Choose two)

• A. The result of a SELECT INTO statement was an empty table
• B. A rowset FETCH statement encountered one or more error conditions
• C. The statement references an object that is not defined in the DB2 subsystem
• D. An error occurred during the insertion of a row into an optional Explanation table
• E. A FETCH statement was executed when the cursor was positioned after the last row of the result table

Answer: AC

NEW QUESTION 5
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

NEW QUESTION 6
Which of the following CREATE TABLE or associated CREATE INDEX options are valid when defining a table with the PARTITION BY RANGE clause? (Choose two)

• A. MAXPARTITIONS
• B. ENDING AT clause on a CREATE INDEX statement for the table
• C. MEMBER CLUSTER
• D. ENDING AT clause on the CREATE TABLE statement
• E. A LOB column specified as a column of the partitioning key

Answer: B

NEW QUESTION 7
Which of the following effectively and efficiently manages priorities of a mixed workload as a result of its tight integration with DB2 for z/OS?

• A. Data Facility Storage Management
• B. z/OS Parallel Sysplex Configuration
• C. Workload Manager
• D. z Systems Processor Resource

Answer: C

NEW QUESTION 8
Assuming column hire date is a DATE data type, which SQL statement will retrieve the maximum salary (salary) and minimum salary(salary) for each job(job) from EMPLOYEE table for those hired(hiredate) before 1965?

• A. Option A
• B. Option B
• C. Option C
• D. Option D

Answer: D

NEW QUESTION 9
In which address space would a native SQL stored procedure run?

• A. WLM
• B. DIST
• C. DBM1
• D. The address space of the calling program

Answer: C

NEW QUESTION 10
Given the following table and index definitions, what type of index will be created?

• A. Non-partitioned index
• B. Non-partitioned secondary index
• C. Data-partitioned secondary index
• D. Data-partitioned partitioning index

Answer: C

NEW QUESTION 11
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

NEW QUESTION 12
What is the implicitly created column in a base table which contains an XML column called?

• A. Node ID
• B. ROWID
• C. LOCATOR
• D. DOCID

Answer: B

NEW QUESTION 13
In order to evaluate the real-time relative disorganization of an index, which catalog table would you query?

• A. SYSIBM.SYSINDEXES
• B. SYSIBM.SYSINDEXPART
• C. SYSIBM.SYSINDEXSTATS
• D. SYSIBM.SYSINDEXSPACESTATS

Answer: B

NEW QUESTION 14
Which of the following SQL constructs does NOT provide information about the success or failure of the SQL statement that was just executed?

• A. SQLCA
• B. SQLDA
• C. SQLCODE
• D. SQLSTATE

Answer: B

NEW QUESTION 15
Which type of index will cause DB2 to store the data in a given physical order?

• A. UNIQUE
• B. PRIMARY
• C. CLUSTER
• D. PARTITIONED

Answer: D

NEW QUESTION 16
Which of the following statements is TRUE when issuing an SQL ROLLBACK (without SAVEPOINT) statement?

• A. All held LOB locators are retained
• B. All locks that are implicitly acquired during the unit of recovery are retained
• C. All rows and all logical work files of every created temporary table of the application process are deleted
• D. All cursors are closed, all prepared statements are retained, and any cursors that are associated with the prepared statements are invalidated

Answer: C

NEW QUESTION 17
Which of the following are contained in the PLAN_TABLE? (Choose two.)

• A. RUNSTATS recommendations
• B. Access to LOB values, which are stored separately from the base table
• C. Access to parent or dependent tables needed to enforce referential constraints
• D. Whether an index access or table space scan is used for each access to a table
• E. The join methods and types that are used, and the order in which DB2 joins the tables

Answer: DE

NEW QUESTION 18
Using the SQL statement DECLARE GLOBAL TEMPORARY TABLE (DGTT) which of the following is TRUE?

• A. A DGTT is only stored in memory
• B. The qualifier for a DGTT is SESSION
• C. The DGTT can be specified in a referential constraint
• D. All privileges associated with the DGTT are stored in the DB2 catalog

Answer: B

NEW QUESTION 19
Which type of constraint is NOT enforced by DB2 during SQL processing?

• A. Check
• B. Referential
• C. Primary key
• D. Informational referential

Answer: D

NEW QUESTION 20
Which privilege will user smith be able to grant to another user on table emp when the following SQL is executed?
GRANT ALL ON TABLE emp TO smith WITH GRANT OPTION;

• A. BIND
• B. REORG
• C. TRIGGER
• D. EXECUTE

Answer: D

NEW QUESTION 21
......