An index named EMPID_X exists for a table named EMPLOYEE. Which of the following will allow user USER1 to drop the EMPID_X index?
Question
DB2 Certification:-
An index named EMPID_X exists for a table named EMPLOYEE. Which of the following will allow user USER1 to drop the EMPID_X index?
DB2 Certification:-
A user utilizing an alias to update a subset of columns in a table must have UPDATE privileges on which of the following DB2 objects?
DB2 Certification:-
What is the purpose of the Design Advisor?
DB2 Certification:-
Which of the following is the lowest cost DB2 product that can be legally installed on a Windows server that has 2 CPUs?
DB2 Certification:-
A user invoking a user-defined function requires which DB2 privilege?
DB2 Certification:-
A table named DEPARTMENT has the following columns:
DEPT_ID
DEPT_NAME
MANAGER
AVG_SALARY
Which of the following is the best way to prevent most users from viewing AVG_SALARY data?
DB2 Certification:-
On which of the following database objects may the SELECT privilege be controlled?
DB2 Certification:-
Which of the following events will NOT cause a trigger to be activated?
DB2 Certification:-
Which of the following tools can be used to catalog a database?
DB2 Certification:-
Which of the following products is used to shred extensible markup language documents?
DB2 Certification:-
Which of the following tools for DB2 V9 allows a user to create and debug a SQL stored procedure?