2023 2024 Student Forum > Management Forum > Main Forum

 
  #2  
22nd August 2014, 03:07 PM
Super Moderator
 
Join Date: Apr 2013
Re: Tips to crack DB2 Certification Exam

To crack DB2 Certification Exam you should start the preparation earlier. Here are some tips which will help in cracking the exam:

Be Positive & Confident
Stay Calm & Cool always
Time Management
Plan your Strategy - Professionally and Meticulously
No shortcuts please / Revise your lessons well
Don’t just Shoot
Never lose your heart
All myths are not true
Focus on the target
Balanced Preparation
Passion for Success
Positive Thinking
Think Big
Stay away from time-waster
Never quit half the way
Time and tide waits for none
Win Emotional Battle
Hope for the Best

Paper:
1. Which allows to access other DB2 servers, but cannot accept requests from other remote clients?

DB2 Personal Edition
DB2 Workgroup Server Edition
DB2 Enterprise Server Edition
DB2 Data Warehouse Edition

2. Which is the lowest cost DB2 product that can be legally installed on an HP-UX server?
DB2 Express-C
DB2 Express
DB2 Personal Edition
DB2 Enterprise Server Edition

3. Which is used to create and debug user-defined functions?
SQL Assist
Control Center
Command Editor
Developer Workbench

4. Which tool used to automate table reorganization operations?
Control Center
Command Center
Command Line Processor
Task Center

5. Major difference between relational data and XML data?
Relational data is self-describing; XML data is not
Relational data has inherent ordering; XML data does not
Relational data must be tabular; XML data does not have to be tabular
Relational data is comprised of entities; XML data is comprised of numbers, characters, and dates

6. In client-server environment, which two can be used to verify passwords?
System Catalog
User ID/password file
Client Operating System
Communications layer
Application Server

7. Which two authorities allow a user to create a new database?
SYSADMN
SYSCTRL
SYSMAINT
DBADM
CREATEDB

8. Which will allow user USER1 to change the comment associated with a table named TABLE1?
GRANT UPDATE ON TABLE table1 TO user1
GRANT CONTROL ON TABLE table1 TO user1
GRANT ALTER ON TABLE table1 TO user1
GRANT REFERENCES ON TABLE table1 TO user1

9. Which two database objects may the SELECT privilege be controlled?
Sequence
Nickname
Schema
View
Index

10. Which two privileges is required in order to use a package?
BINDADD
BIND
CONNECT
EXECUTE
USE

1.A
2.D
3.D
4.D
5.C
6.C and E
7.A and B
8.C
9.B and D
10.C and D


Tags
certification

Quick Reply
Your Username: Click here to log in

Message:
Options

Thread Tools Search this Thread



All times are GMT +5. The time now is 01:10 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
SEO by vBSEO 3.6.0 PL2

1 2 3 4