Company Name Starts with ...
#  A  B  C  D  E   F  G  H  I  J   K  L  M  N  O   P  Q  R  S  T   U  V  W  X  Y  Z

CTS DB2 Interview Questions
Questions Answers Views Company eMail

select distinct(empid),distinct(dept),name from EMP will the above query work?

2 6598

I have two tables A and B. Both tables are connected with SSN number as foreign key. I want to retrieve a column data from B table. How will you write a query?

3 5887

While creating a table, by mistake you have given size of one field as 10. But as per requirement size should be 8. What is your next step?

4 7931

What does an outer join do?

1 6018

Post New CTS DB2 Interview Questions




CTS DB2 Interview Questions


Un-Answered Questions

How to Make relay co ordination chart for a Electrical power distribution of a plant

2727


What can go wrong if you have a balance sheet with a lot of debt? What can go wrong if there is negative owner's equity? What does a good cash flow statement look like and why?

1475


Explain what is cycle time?

22


What happens when a thread cannot acquire a lock on an object?

96


Explain what is the optimum temperature for catalyses?

63






What is xml format in excel?

54


how to calculate rate analysys of 1:6 plastering 10 sq m

1941


How do I check for lists against each other in excel?

1


What are the Steps for Creating a Blade Template Layout ?

184


What does change my default mean?

56


What are the advantages of redux?

8


A chkpt is the parameter coded for multi-volume qsam datasets in a dd statement. When a chkpt is coded as chkpt=eov, a checkpoint is written to the dataset specified in the sysckeov statement at the end of each volume of the input/output multi-volume dataset. State whether true or false?

122


What are the different elements of css box model?

10


How u r estimating the budget 4 the project?

1361


Introduction Mangalore Refinery and Petrochemicals Limited (MRPL) and Reliance Petroleum Limited (RPL) Table 1 : MRPL’s Income Statement and Balance Sheet (Rs. in mn) Particulars April 1999 – March 2000 April 2000 – March 2001 April 2001 – march 2002 Net Sales 30212.04 28891.50 53714.40 Other Income 701.37 524.50 439.90 Total Income 30913.41 29415.70 54154.30 Expenditure (30112.79) (27917.50) (51587.00) Interest (2369.59) (2378.30) (6722.90) Depreciation (1427.63) (1728.60) (3633.50) Tax (0.24) (0.30) 2864.30 Total Expenditure (33910.25) (32024.70) (61943.40) Profit after Tax (2996.84) (2609.00) (4924.80) Equity 7921.00 7921.00 7921.00 Reserves 1714.50 (1506.96) (4489.56) Debt 54082.97 50516.52 55356.94 . Table II : RPL’s Income statement and Balance Sheet Particulars April 2001 – March 2002 April 2000 – March 2001 Net Sales 331170.00 309630.00 Other Income 3550.00 2200.00 Total Income 334720.00 311830.00 Expenditure (299430.00) (279090.00) Interest (9550.00) (10320.00) Depreciation (8020.00) (6610.00) Tax (980.00) (1170.00) Total Expenditure (317980.00) (297190.30) Profit after Tax 16740.00 14640.00 Equity 52020.00 47488.10 Reserves - 34974.20 Debt - 74921.30 Table III : Quarterly Closing Prices (04/30/1996 to 09/30/2002) Date BSE-30 RPL MRPL 04/30/96 3376.64 14.75 32.50 06/28/96 3731.96 12.90 28.25 09/30/96 3519.42 10.25 19.35 12/24/96 2883.88 10.40 20.60 03/31/96 3360.89 12.70 17.65 06/30/97 4256.09 17.40 18.10 09/30/97 3902.03 19.00 21.60 12/31/97 3658.98 23.55 19.85 03/31/98 3892.75 20.50 19.25 06/30/98 3250.69 20.00 16.15 09/30/98 2812.49 17.60 13.90 12/31/98 3055.41 18.80 12.90 03/31/98 3739.96 18.70 10.30 06/30/99 4140.73 27.05 19.00 09/30/99 4764.92 46.90 21.00 12/30/99 5005.82 65.70 16.70 03/31/00 5001.28 60.04 12.35 06/30/00 4748.77 53.95 9.90 09/29/00 4090.38 56.75 8.80 12/29/00 3972.12 56.60 8.80 03/30/01 3604.39 48.55 7.70 06/29/01 3456.78 47.00 6.85 09/28/01 2811.66 29.75 6.30 12/31/01 3263.33 29.30 6.80 03/28/02 3469.35 25.85 6.80 06/28/02 3244.70 24.05 10.00 09/30/02 2930.51 23.10 7.65 Questions 1. Calculate the average return and risk on shares of RPL and MRPL during the period 1996-2002. divide the total risk on each of the stocks between systematic and unsystematic components. Calculate each of the components as a percentage of the total risk.

3329