View previous topic :: View next topic
|
Author |
Message |
abhisinghal2002
New User
Joined: 02 Jul 2008 Posts: 12 Location: Delhi
|
|
|
|
1. which of these DB2 Command is executable ?
a) PLAN
b) PACKAGE
c) DBRMS
d) All of These
2. what is the output of the QMF query SELECT AVG(SALARY) FROM ABC.XYZ WHERE LAST_SAL = CURR_SAL , if the query returns zero rows.
a) -1
b) 0
c) NULL
d) Error
3. what is the root cause of -805 SQL error
a) PLAN
b) PACKAGE
c) BIND
d) None of these
4. what is the corret sequence of COBOL-DB2 program compilation
Don't remember the options... (plz tell me the answer ) |
|
Back to top |
|
|
sushanth bobby
Senior Member
Joined: 29 Jul 2008 Posts: 1020 Location: India
|
|
|
|
Abhi, what is MCQ ?
Sushanth |
|
Back to top |
|
|
abhisinghal2002
New User
Joined: 02 Jul 2008 Posts: 12 Location: Delhi
|
|
|
|
Hi,
MCQ means Multiple Choice Question and Answer
Thanks for your prompt response |
|
Back to top |
|
|
sushanth bobby
Senior Member
Joined: 29 Jul 2008 Posts: 1020 Location: India
|
|
|
|
Abhi,
I think Executable is a PLAN. & for the root cause of -805 it must be the BIND.
Let me know, if iam wrong.
Sushanth |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
Quote: |
which of these DB2 Command is executable ? |
none of the above, they are all db2 objects not commands.
very poorly phrased questions............ |
|
Back to top |
|
|
abhisinghal2002
New User
Joined: 02 Jul 2008 Posts: 12 Location: Delhi
|
|
|
|
Quote: |
none of the above, they are all db2 objects not commands.
very poorly phrased questions............
|
thanx a lot for the response...even i found it a bit confusing...as the option was not thr...
Quote: |
I think Executable is a PLAN. & for the root cause of -805 it must be the BIND.
|
even i thought so....that the root cause is BIND but the answer in the answer sheet was PLAN...
please correct me if i am wrong......and if possible plz give me the answer for 2 and 4th question also... |
|
Back to top |
|
|
|