What does an outer join do?
Answer / guest
Includes unmatched rows from both tables. If any column of
the result table does not have a value, that column has the
null value in the result table.
| Is This Answer Correct ? | 12 Yes | 1 No |
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
What is drop table?
What is the clustering index in the db2 database?
What is the physical storage length of the data types date, time, and timestamp?
What action db2 takes when a program aborts in the middle of a transaction?
Which isolation level provides highest data integrity?
What is db2 plan table?
What are the different methods of accessing db2 from tso? How is the connection established between TSO & DB2?
What is the syntax for FETCH in DB2 ?
What is the maximum number of tables that can be stored on a Partitioned Table Space ?
Differentiate between cs and rr isolation levels? Where do you specify them?
How do I create a table MANAGER (EMP-NO, MANAGER) where MANAGER is a foreign key which references to EMP-NO in the same table? Give the exact DDL.