C2090-320 Exam Questions

Given the following SQL statement: GRANT DELETE ON TABLE customer TO user1; Which of the following statements is TRUE?

Which protocol provides applications the ability to connect to a server at another location and execute packages that have been previously bound at that server?

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

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

You need to add the employee picture to the employee table. Which of the following is the appropriate built-in data type for storing images?

Which type of lock is obtained when using a `WITH UR' clause on an SQL SELECT statement in a data-sharing environment?

When the following SQL statement is executed, user smith will NOT be able to do which of the following? REVOKE USE OF STOGROUP stogr1 FROM smith;

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) Set SAVEPOINT A 4) Update COL1 in SCHEMA.TABLE to 30 5) Set...

Which of the following automatically maintains historical versions of data over several years?

Which SQL statement will retrieve the department number (WORKDEPT) and the highest salary (SALARY) for each department in a table named EMPLOYEE and arrange the result set in ascen...

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

Which catalog table contains the information about definition changes for an object that have not yet been applied by the REORG utility?

Which statement about an application-period temporal table is TRUE?

Which SQL statement supports an insert or an update in a single SQL statement?

Which of the following types of DB2 tables would you use to store information that is derived and summarized from other tables?

Which of the following SECURITY values tells DB2 to use the authorization ID of the user that calls the stored procedure to access a non DB2 resource?

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

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

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;

Which of the following utilities CANNOT be executed from the DB2 utilities panel in DB2I?

Which of the following locking scenarios requires the least amount of real storage in the IRLM address space?

Which of the following is NOT TRUE?

The DB2 subsystem DSN has been correctly configured to access a remote DB2 location MYREMOTE. Which of the following processes can be used on subsystem DSN to access MYUSER.EMP tab...

Which of the following elements is affected by a ROLLBACK statement?

Which statement is TRUE regarding ROLLBACK processing?

What does the fourth character in a DB2 message number indicate?

In a data sharing environment, to control access to data that is of inter-DB2 interest, whenever the data is changed, DB2 caches it in which of the following objects?

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

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

The metadata for which of the following objects is NOT stored in the DB2 catalog table SYSIBM.SYSTABLES?

In a unique referential constraint, which type of key does a foreign key reference?

The following definition for COL1 is given by this statement: CREATE TABLE... (COL1 BINARY (05)) Which of the following statements will successfully insert data into the table?

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

You want to reduce lock contention that results from uncommitted insert and delete operations by enabling transactions that read data to access only the currently committed data ra...

Given the following CREATE VIEW statement and sample data; your login id is "ROGER". What will be the result for this query?

Assume DELETE triggers exist on the employee table. Which of the following statements will delete all the rows in the employee table and ignore any DELETE triggers?

Which of the following is a characteristic of a stand-alone utility?

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?

Which package level privileges does the user smith have when the following statement is executed? GRANT ALL ON PACKAGE clct1.pkg1 TO smith;

Which of the following can activate a trigger?

Which of the following statement describes the effect of setting the SEPARATE_SECURITY installation parameter to YES?

What are the only predicates that can be applied to an XML data type?

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

You want to see all messages that were generated by one specific DB2 subsystem such as log switches and timeout messages. Which job log would show all of these?

Which of the following statements about a table with a LOB column is TRUE?

Which catalog table provides information about the validity of a bound package?

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

What is the result XQuery FLWOR expression when running the following scenario?

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

While DSN is running, which of the following commands CANNOT be successfully executed?