EDS interview query

sivatechdrive · Posted: Mon Apr 25, 2005 10:56 am

Hi Friends

I was asked some tricky questions in an interview, please share your answers

On endevor:
One of your friends did a checkout for an element & went on leave ... how can you checkout (not copy) the same element?

On DB2
You have 5 SQL queries in a program, how can you know the efficiency of the queries using a plan table

On COBOL
Move Spaces to filler ----> will this work?

then I have one personal question on COBOL
A table whose data is contained in the DATA DIVISION is known as a(n)
____________ .
a. loaded table
b. key table
c. input-loaded table
d. linear table
e. hard-coded table

Regards
Siva

csreddy · New User Joined: 29 Apr 2005 Posts: 1

Cobol- Spaces should not be moved to FILLER

Ram_k · New User Joined: 28 Apr 2005 Posts: 5 Location: Chennai

Hi,

Reg your below ques

On DB2
You have 5 SQL queries in a program, how can you know the efficiency of the queries using a plan table

Ans: -

When you bind the program by specifying explain yes parameter you can view details of each sql in the plan table by using the query no..

The efficiency of each query can be determined by checking the following criterias in the plan table
1. Check the access path by inex or indexonly
Note: - some times table space scan is the best way to access the data..it depends on the vol of data...
2.Check whether the tables specified in your sql got loaded in the way you want it..this is another important factor which will affect the performance..
3.check for sorts (order by,group by)
...etc

Hope this gives you some idea..

mmwife · Super Moderator Joined: 30 May 2003 Posts: 1592

Hi Siva,

Think about moving spaces to a fillier. What one of the fillers? How do you tell the compiler which one you want? That was the trick to the ques.

Iwould guess the ans to the last one is "e", hard coded. Anything that's coded as a literal is "hard coded".

srividya.srinivasan · Posted: Thu May 05, 2005 3:08 pm

Hi Guyz,

Regarding Shiva's Question about moving Spaces to Filler.

You can never move spaces to soem thing i.e the filler that is not defined at all.

Hence even if u move it, u'll get an error stating Filler is not defined.

Vidya

David P · Posted: Fri May 06, 2005 12:43 pm

Hi Siva,
On Endavor.
If you want to check out some module which is already signout by someone else you need to override signout provided you have the previlage for the same or else you will have to contact the admin for it.

let me know in case of any concerns.
regards,
David.