Free IBM C2090-320 Practice Test & Real Exam Questions
An external stored procedure is invoked using a CALL :hv (host variable). Which special register identifies the location of the procedure?
Correct Answer: D
Vote an answer
Which of the following are valid objects created using DDL? (Choose two)
Correct Answer: C,D
Vote an answer
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 ascending order by department?
and the highest salary (SALARY) for each department in a table
named EMPLOYEE and arrange the result set in ascending order by department?
Correct Answer: D
Vote an answer
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?
Correct Answer: D
Vote an answer
Given the following CREATE TABLE statement, and a unique index on column EMPID, which set of SQL statements is valid?
Correct Answer:
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 you ignore this message?
DSNJ110E - LAST COPY n ACTIVE LOG DATA SET IS nnn PERCENT FULL
What will happen if you ignore this message?
Correct Answer: C
Vote an answer
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;
GRANT ALL ON TABLE emp TO smith WITH GRANT OPTION;
Correct Answer: A
Vote an answer
