C2090-320 Online Practice Questions and Answers

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

A. COPY

B. REORG

C. STOSPACE

D. BACKUP SYSTEM

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 starts with "CREATE INDEX AAA ON...". Which of the following statements must precede the CREATE statement so that you can create the index?

A. SET CURRENT SQLID = `DB2';

B. SET CURRENT RULES = `DB2';

C. No preceding statement is needed

D. SET CURRENT SCHEMA = `DB2';

The maximum size for each partition of a partition-by-range table space, with fewer than 255 partitions, is determined by which combination of options? (Choose two.)

A. DSSIZE

B. PRIQTY

C. NUMPARTS

D. BUFFERPOOL

E. MAXPARTITIONS

Which of the following statements about a system-period temporal table is TRUE?

A. Rows can be archived into a history table which is always read only

B. Every row has a pair of timestamps which is set and managed by the application

C. AN SQL query for auditing can be run against current data or history data, but not both

D. The table contains only the current active rows

What are two major encoding schemes? (Choose two.)

A. UNIX

B. Linux

C. CCSID

D. Unicode

E. EBCDIC

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

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 the column are positive, it will place the table space or partition that contains the table into which of the following states?

A. CHECK PENDING

B. REORG PENDING

C. REBUILD PENDING

D. ADVISORY REORG PENDING

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

A. DB2 implicitly creates an XML table space

B. DB2 implicitly creates an AUX table to store the XML data

C. If this is the first XML column you created for the table, DB2 implicitly creates a unique index on the XML column

D. If this is the first XML column you created for the table, DB2 implicitly creates a ROWID column on the base table

E. If this is the first XML column you created for the table, DB2 implicitly creates a BIGINT node ID column on the base table

Given the following SQL statement:

GRANT DELETE ON TABLE customer TO user1;

Which of the following statements is TRUE?

A. User1 can only remove the customer table

B. User1 can only remove rows from the customer table

C. User1 can remove the customer table and grant the privilege to remove the customer table to other users

D. User1 can remove rows from the customer table and can grant the privilege to remove rows from the customer table to other users

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?

A. CLI

B. JDBC

C. DRDA

D. ODBC