Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Need answer to these questions... MCQ

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Mainframe Interview Questions
View previous topic :: :: View next topic  
Author Message
abhisinghal2002

New User


Joined: 02 Jul 2008
Posts: 12
Location: Delhi

PostPosted: Thu Jun 04, 2009 4:13 pm    Post subject: Need answer to these questions... MCQ
Reply with quote

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... icon_biggrin.gif (plz tell me the answer icon_exclaim.gif )
Back to top
View user's profile Send private message

sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Thu Jun 04, 2009 4:28 pm    Post subject:
Reply with quote

Abhi, what is MCQ ?

Sushanth
Back to top
View user's profile Send private message
abhisinghal2002

New User


Joined: 02 Jul 2008
Posts: 12
Location: Delhi

PostPosted: Thu Jun 04, 2009 4:29 pm    Post subject: Reply to: Need answer to these questions... MCQ
Reply with quote

Hi,

MCQ means Multiple Choice Question and Answer

Thanks for your prompt response
Back to top
View user's profile Send private message
sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Thu Jun 04, 2009 5:11 pm    Post subject:
Reply with quote

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
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6968
Location: porcelain throne

PostPosted: Thu Jun 04, 2009 5:39 pm    Post subject:
Reply with quote

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
View user's profile Send private message
abhisinghal2002

New User


Joined: 02 Jul 2008
Posts: 12
Location: Delhi

PostPosted: Fri Jun 05, 2009 2:42 pm    Post subject: Reply to: Need answer to these questions... MCQ
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Mainframe Interview Questions All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Mainframe Interview Questions CICS,CO... akshathan Mainframe Interview Questions 6 Thu Feb 09, 2017 6:38 pm
No new posts Viewing executing process in NDM .. q... Debb.Brant IBM Tools 0 Wed Dec 14, 2016 10:55 pm
No new posts INCLUDE condition questions van bui DFSORT/ICETOOL 1 Thu Jun 30, 2016 9:52 am
No new posts SAS Programming - Basic Questions Techelm All Other Mainframe Topics 3 Fri Mar 18, 2016 10:53 pm
No new posts Where can i find Interview questions ... Elixir Mainframe Interview Questions 4 Sat Feb 20, 2016 12:38 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us