Question - 1
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?
Columns and Alias
Table
Columns
Table and Alias
None of these
Answer- B
Question - 2
DB2 Certification:-
What is the purpose of the Design Advisor?
To present a graphical representation of a data access plan and recommend design changes that will improve performance
To replicate data between a DB2 database and another relational database
To analyze workloads and make recommendations for indexes and MQTs
To configure clients so they can access databases stored on remote servers
None of these
Answer- C
Question - 3
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 Workgroup Server Edition
DB2 Everyplace
DB2 Express Edition
DB2 Enterprise Server Edition
None of these
Answer- C
Question - 4
DB2 Certification:-
A user invoking a user-defined function requires which DB2 privilege?
REFERENCES
CALL
USAGE
EXECUTE
None of these
Answer- D
Question - 5
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?
Encrypt the table\'s data
Store AVG_SALARY data in a separate table and grant SELECT privilege for that table to the appropriate users
Create a view that does not contain the AVG_SALARY column
Revoke SELECT access for the AVG_SALARY column from users who should not see AVG_SALARY data
None of these
Answer- C
Question - 6
DB2 Certification:-
On which of the following database objects may the SELECT privilege be controlled?
Sequence
Schema
View
Group
None of these
Answer- C
Question - 7
DB2 Certification:-
Which of the following events will NOT cause a trigger to be activated?
An insert operation
An update operation
A select operation
A delete operation
None of these
Answer- C
Question - 8
DB2 Certification:-
Which of the following tools can be used to catalog a database?
Alert Center
Configuration Assistant
Visual Explain
Journal
None of these
Answer- C
Question - 9
DB2 Certification:-
Which of the following products is used to shred extensible markup language documents?
DB2 XML Extender
DB2 Spatial Extender
DB2 AVI Extender
DB2 Text Extender
None of these
Answer- A
Question - 10
DB2 Certification:-
Which of the following tools for DB2 V9 allows a user to create and debug a SQL stored procedure?
Development Center
Developer Workbench
Stored Procedure Builder
Control Center
None of these
Answer- B
Question - 11
DB2 Certification:-
Which of the following tools can make recommendations for indexes and/or MQTs to improve the performance of DB2 applications?
Configuration Assistant
Visual Explain
Performance Advisor
Design Advisor
None of these
Answer- D
Question - 12
DB2 Certification:-
Which of the following is used to create and debug user-defined functions?
SQL Assist
Command Editor
Developer Workbench
Control Center
None of these
Answer- C
Question - 13
DB2 Certification:-
Which of the following statements allows user USER1 to take the ability to create packages in a database named SAMPLE away from user USER2?
REVOKE CONNECT ON DATABASE FROM user2
REVOKE BINDADD ON DATABASE FROM user2
REVOKE CREATETAB ON DATABASE FROM user2
REVOKE BIND ON DATABASE FROM user2
None of these
Answer- B
Question - 14
DB2 Certification:-
Which of the following DB2 tools allows a user to execute an SQL statement and view a graphical representation of the access plan?
Task Center
Developer Workbench
Command Line Processor
Command Editor
None of these
Answer- D
Question - 15
DB2 Certification:-
For which of the following is a data warehouse optimized?
Backup and recovery
Queries
Transactions
Security
None of these
Answer- B
Question - 16
DB2 Certification:-
Which authority or privilege is granted by the DB2 Database Manager Configuration file?
CONTROL
SYSMAINT
EXECUTE
CONNECT
None of these
Answer- B
Question - 17
DB2 Certification:-
Which of the following tasks can NOT be performed using the Developer Workbench?
Develop and run XML queries
Develop and debug an SQL stored procedure
Develop and debug a user-defined function
Develop and debug a user-defined data type
None of these
Answer- D
Question - 18
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?
GRANT CONTROL ON INDEX empid_x TO user1
GRANT DELETE ON INDEX empid_x TO user1
GRANT INDEX ON TABLE employee TO user1
GRANT DROP ON INDEX empid_x TO user1
None of these
Answer- A
Question - 19
DB2 Certification:-
Which of the following describes the model used by the Geodetic Extender?
Round earth
3-D Square
Square
Flat earth
None of these
Answer- A
Question - 20
DB2 Certification:-
Which of the following are NOT stored in the system catalog tables?
SQL statements used to create triggers
SQL statements used to create views
SQL statements used to create constraints
Table names
None of these
Answer- B
Practice more set questions
