C2090-320 Exam Questions

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 r...

Given the following INDEX definition, which attributes apply to this index? (Choose two.)

Which characteristic best describes a created global temporary table?

Which of the following actions can you take in order to prevent users from obtaining implicit privileges as a result of object ownership?

Which authorizations can change the value of the subsystem parameter SYSADM using the 璖 ET SYSPARM command? (Choose two.)

Which of the following is NOT a valid trigger?

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

Given the following: Which of the following occurs automatically when rows are deleted from POLICY_INFO_AET?

What is the proper sequence for running the steps of the program preparation process?

A view is considered read only if which of the following is TRUE?

Which of the following are valid objects created using DDL? (Choose two.)

Which of the following is used to identify valid source and target combinations and to perform the conversion from one coded character set to another?

Which of the following programming techniques can be used to check for any error codes after executing an SQL statement?

Which of the following coupling facility structures are used by DB2 in a data sharing environment?

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?

Which command displays the DB2 catalog level and migration mode?

Which of the following SELECT statements returns a different data value than the other SQL statements?

What is the purpose of an auxiliary table?

Why would an SQL statement receive an SQLCODE of +100? (Choose two.)

Which isolation level is described by the following? The ISOLATION(..) option allows maximum concurrency with data integrity. Under the ISOLATION(..) option, a transaction holds lo...

DB2 native SQL procedures execute in which DB2 address space?

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

To ensure only positive values are entered into a column, you add a constraint on the SALARY column of a previously populated table. If DB2 cannot guarantee the existing values in...

For a partition-by-range table, which data types can be used to define the key columns that are used to partition the data? (Choose two.)

Given the following table: Which of the following INSERT statements will be successful?

Your application has a read-only cursor. You cannot tolerate uncommitted data but want to make sure that it provides the best concurrency. Which of the following bind options would...

Which job generates the subsystem parameter module?

Which option is used with the RECOVER utility when the data sets of the target objects have already been restored to a point of consistency by another process offline?

An external stored procedure is invoked using a CALL :hv (host variable). Which special register identifies the location of the procedure?

Which of the following utilities or utility control statements require datasets for execution?

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

User1 creates table user1.customers in a partitioned-by-growth (PBG) table space DB1.TS1 Which of the following operations CANNOT be performed by user1 with implicit owner privileg...

Which of the following table space types does NOT support the use of REORG TABLESPACE SHRLEVEL (NONE)?

A stored procedure needs to issue a dynamic SQL statement (SELECT) at runtime. The stored procedure's owner ID must be used for the authorization check (whether or not the SELECT i...

Which of the following is NOT a valid lock size in DB2?

The following warning message is issued when the last available active log data set is 5% full: DSNJ110E - LAST COPY n ACTIVE LOG DATA SET IS nnn PERCENT FULL What will happen if y...

When you add an XML column to a table by using an ALTER TABLE statement, which of the following are TRUE? (Choose two.)

An array value CANNOT be specified using which of the following methods?

The PERIOD BUSINESS_TIME clause on a DDL statement is used in which of the following? (Choose two.)

Which catalog table would you query in order to determine the relevant statistics for an index?

Select the SQL statement which will list the employee(empno) and the project numbers(projno) from the EMPACT table that has an employee(empno) whose salary(salary) is in the top th...

Which two of the following functions are synonyms of one another? (Choose two.)

You have created a new index. What is the command to potentially change the access path for a static package?

Your current authorization ID is DBA. Only one of your secondary IDs, DB2, has the privilege to drop an existing index DB2.AAA on a table. The appropriate SQL statement is "DROP IN...

Which DB2 command displays the status information about DB2 database MYDB and displays the status of all objects in this database?

Which catalog table contains the IN, OUT and INOUT parameters used in a stored procedure?

Which CREATE TABLESPACE option specifies that a table space is partition-by-growth?

When the following SQL statement is executed, the user SMITH is able to manage all objects in the DB2 subsystem except for which of the following? GRANT DBADM ON SYSTEM TO smith;

An application program is running much longer than expected. The PLAN_TABLE shows the following access path information: ACCESSTYPE = `R' PREFETCH = `S' What access path does this...

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