Which DB2 command displays the status information about DB2 database MYDB and displays the status of all objects in this database?
A. -DISPLAY DATABASE(MYDB) OVERVIEW
B. -DISPLAY DATABASE(MYDB) SPACENAM(*)
C. -DISPLAY DATABASE(MYDB) SPACENAM(*) RES
D. -DISPLAY DATABASE(MYDB) SPACENAM(*) ACTIVE
You have created a new index. What is the command to potentially change the access path for a static package?
A. FREE
B. RESET
C. REBIND
D. REFRESH
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 INDEX AAA".
Which of the following statements must precede the DROP statement so that it drops the index?
A. SET CURRENT PATH = `DB2';
B. SET CURRENT RULES = `DB2';
C. No preceding statement is needed
D. SET CURRENT SCHEMA = `DB2';
Which two of the following functions are synonyms of one another? (Choose two.)
A. CLOB
B. VALUE
C. IFNULL
D. DBCLOB
E. COALESCE
Which catalog table would you query in order to determine the relevant statistics for an index?
A. SYSIBM.SYSKEYS
B. SYSIBM.SYSFIELDS
C. SYSIBM.SYSCOLUMNS
D. SYSIBM.SYSINDEXSTATS
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 three salaries for all employees from the EMP table.
A. SELECT empno, projno FROM empact ep WHERE ep.empno IN (SELECT em.empno FROM emp em ORDER BY salary DESC) FETCH FIRST 3 ROWS ONLY;
B. SELECT empno, projno FROM empact WHERE empno IN (SELECT empno FROM emp FETCH FIRST 3 ROWS ONLY);
C. SELECT ep.empno, projno FROM empact ep WHERE ep.empno IN (SELECT em.empno FROM emp em ORDER BY salary FETCH FIRST 3 ROWS ONLY);
D. SELECT ep.empno, projno FROM empact ep WHERE ep.empno IN (SELECT em.empno FROM emp em ORDER BY salary DESC FETCH FIRST 3 ROWS ONLY);
The PERIOD BUSINESS_TIME clause on a DDL statement is used in which of the following? (Choose two.)
A. A bitemporal table
B. A system-period temporal table
C. A created global temporary table
D. A declared global temporary table
E. An application-period temporal table
An array value CANNOT be specified using which of the following methods?
A. Invocation of an INSERT statement
B. Invocation of the ARRAY_AGG function
C. Invocation of the ARRAY_DELETE or TRIM_ARRAY built-in functions
D. A simple reference to an SQL variable, or SQL parameter that is a user-defined array type
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
Which of the following is NOT a valid lock size in DB2?
A. Table
B. Partition
C. Database
D. Table space
Nowadays, the certification exams become more and more important and required by more and more enterprises when applying for a job. But how to prepare for the exam effectively? How to prepare for the exam in a short time with less efforts? How to get a ideal result and how to find the most reliable resources? Here on Vcedump.com, you will find all the answers. Vcedump.com provide not only IBM exam questions, answers and explanations but also complete assistance on your exam preparation and certification application. If you are confused on your C2090-320 exam preparations and IBM certification application, do not hesitate to visit our Vcedump.com to find your solutions here.