in db2, already 10 columns arie der, and i want to insert 11th column. what parameters u wil consider for insertion and how will u insert
ALTER TABLENAME
ADD COLUMN <COLUMN NAME> <DATATYPE>(<SIZE>)
Is This Answer Correct ? | 1 Yes | 0 No |
What is load utility in db2?
Outputs of explain are with matchcols = 0. What does this signify?
Where to download IBM DB2 Certification Dumps for the below: C2090-311 : IBM DB2 10.5 DBA for LUW Upgrade from DB2 10.1 C2090-312 : IBM DB2 11 DBA for z/OS C2090-313 : DB2 11 Application Developer for z/OS C2090-317 : DB2 11 System Administrator for z/OS C2090-541 : DB2 9.7 DBA for Linux UNIX and Windows C2090-543 : DB2 9.7 Application Development C2090-544 : DB2 9.7 Advanced DBA for LUW C2090-545 : DB2 9.7 SQL Procedure Developer C2090-546 : DB2 9.7 Database Administrator for Linux UNIX or Windows Upgrade C2090-610 : DB2 10.1 Fundamentals C2090-611 : DB2 10.1 DBA for Linux, UNIX, and Windows C2090-612 : DB2 10 DBA for z/OS C2090-614 : DB2 10.1 Advanced DBA for Linux UNIX and Windows C2090-615 : DB2 10.5 Fundamentals for LUW C2090-617 : DB2 10 System Administrator for z/OS C2090-730 : DB2 9 Family Fundamentals C2090-733 : DB2 9 Application Developer C2090-735 : DB2 9.5 SQL Procedure Developer C2090-737 : DB2 9 System Administrator for z/OS Exam
How can deadlocks be resolved?
List out the buffer pools in db2
What is explain plan in db2?
Usually, which is more important for DB2 system performance - CPU processing or I/O access?
How does cobol compile db2 program?
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
In cursor program-1 can we create another cursor program-2 inside the cursor program-1.If yes how/no why ?
Can we able to find all the Table names under a Particular Plan?
What is DCLGEN?