InterviewUp is actively seeking partnerships. Inquire at business@interviewup.com

Questions 1 - 7 of 7
Close
Flag this interview question as inappropriate Inappropriate
See Answer
After the execution of one of the when clauses, the control is automatically passed on to the next sentence after the EVALUATE statement. There is no need of any extra code.
Create Date
:
Friday, May 09, 2008
Tags
:
Asked At
:
None
Job Positions
:
Click here to improve the Interview Question, Answer and other fields.
Comments (0) :
Goto add your comment on the Question 
Flag this interview question as inappropriate Inappropriate
See Answer
Sql clauses that support the link property are where, startwith and having.
Create Date
:
Thursday, March 06, 2008
Tags
:
Asked At
:
Job Positions
:
Click here to improve the Interview Question, Answer and other fields.
Comments (0) :
Goto add your comment on the Question 
Flag this interview question as inappropriate Inappropriate
See Answer
Sql clauses which are support the link property are where, startwith and having.
Create Date
:
Thursday, March 06, 2008
Tags
:
Asked At
:
None
Job Positions
:
Click here to improve the Interview Question, Answer and other fields.
Comments (0) :
Goto add your comment on the Question 
Flag this interview question as inappropriate Inappropriate
See Answer

If an organisation has to have third-party logistics providers then the organisation should not overlook the aspects stated below.

  • Loss of Control -This is the single biggest disadvantage. Where there may be a certain comfort level to servicing your customer when logistics is in-house, that feeling is gone when you outsource to a third-party.
  • Higher Exit Barriers -It is very difficult to reverse the decision to outsource once your organization has signed up with a third-party provider. Contracts are usually 2-5 years in length with penalty clauses for early termination.
  • Unexpected Fees -Unless explicitly stated in the contract, extra usage fees may apply. This is dependent on the type of contract that is used, open-book or closed book. In open book, all costs are visible to both parties and a management fee is applied for the 3PL service. In closed-book a cost per piece is charged, so as the volume handled increases, the cost increases.
Create Date
:
Saturday, October 13, 2007
Asked At
:
None
Job Positions
:
None
Click here to improve the Interview Question, Answer and other fields.
Comments (0) :
Goto add your comment on the Question 
Flag this interview question as inappropriate Inappropriate
See Answer
Yes. The proper order for SQL SELECT clauses is: SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY.  Only the SELECT and FROM clause are mandatory.
Create Date
:
Wednesday, September 12, 2007
Asked At
:
None
Job Positions
:
None
Click here to improve the Interview Question, Answer and other fields.
Comments (0) :
Goto add your comment on the Question 
Flag this interview question as inappropriate Inappropriate
See Answer
The clauses of the subselect are processed in the following sequence (DB2):
 FROM clause
WHERE clause
 GROUP BY clause
 HAVING clause
 SELECT clause
 ORDER BY clause
FETCH FIRST clause
Create Date
:
Wednesday, September 12, 2007
Asked At
:
None
Job Positions
:
None
Click here to improve the Interview Question, Answer and other fields.
Comments (0) :
Goto add your comment on the Question 
Flag this interview question as inappropriate Inappropriate
See Answer
The orders  used in ORDER BY clauses in are ASC, DESC
Create Date
:
Wednesday, September 12, 2007
Asked At
:
None
Job Positions
:
None
Click here to improve the Interview Question, Answer and other fields.
Comments (0) :
Goto add your comment on the Question 


Check out our newest job listings!

Post a Job! $49 for 60 days




InterviewUp is actively seeking partnerships. Inquire at business@interviewup.com

Suggestions & Comments




Share Your Interview Questions
Ask Interview Questions
View Unanswered Questions

















Advertise on this site