Online Access Free C2090-320 Practice Test

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

• A.SYSIBM.SYSVARIABLES
• B.SYSIBM.SYSPARMS
• C.SYSIBM.SYSROUTINES
• D.SYSIBM.SYSSTMT

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

• A.SYSIBM.SYSPACKAGE
• B.SYSIBM.SYSPACKAUTH
• C.SYSIBM.SYSPACKDEP
• D.SYSIBM.SYSPACKLIST

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

• A.SELECT EXTRACT(MONTH FROM CURRENT TIMESTAMP) FROM SYSIBM.SYSDUMMY1;
• B.SELECT LPAD(LTRIM(SUBSTR(CHAR(CURRENTTIMESTAMP(10))l6l2)t,0')l11l") FROM SYSIBM.SYSDUMMY1;
• C.SELECT TIMESTAMPDIFF(64. CHAR( CURRENT TIMESTAMP - TIMESTAMP('2016-01-01-00.00.00'))) FROM SYSIBM.SYSDUMMY1;
• D.SELECT MONTH (CURRENT TIMESTAMP) FROM SYSIBM.SYSDUMMY1;

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;

• A.CREATE TRIGGER...;
• B.CREATE TABLE... IN dbl.ts1;
• C.CREATE TABLESPACE... USING STOGROUP stogr1;
• D.CREATE DATABASE ... STOGROUP stogr1;

Given the following table:

Which of the following INSERT statements will be successful?

• A.INSERT INTO EMPSAMP ('Mary Smith', 35000.00. 11, 'Associate', 'existing705-06-2016');
• B.INSERT INTO EMPSAMP (empno.name, salary, deptno, level,hiretype. hiredate) VALUES(2,'Mary Smith', 35000.00, 11, 'Associate'. 'existing705-06-2016');
• C.INSERT INTO EMPSAMP VALUES(2,'Mary Smith', 35000.00, 11, 'Associate'. 'existing\'05-06-2016');
• D.INSERT INTO EMPSAMP (name, salary, deptno, level) VALUES('Mary Smith', 35000.00, 11, 'Associate'):