You attempt to query the data base with this command: SELECT name, salary FROM employee WHERE salary=(SELECT salary FROM employee WHERE last name='Wagner' OR dept no=233) Choose most appropriate option from the following: 1)Sub-queries are not allowed in the where clause. 2)a multiple row sub-query used with a single row comparison operator. 3)a single row query is used with a multiple row comparison operator.
10 17396write a function that takes an integer array as an input and finds the largest number in the array. You can not sort array or use any API or searching needs?
2 13406Post New Zycus Infotech OOPS Interview Questions
How to initialize nsmutabledictionary in objective c?
Is c the same as c++?
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.
What is cancer staging, and how do you determine the extent of disease progression in a cancer patient?
What is a json string?
What do you mean by trend analysis?
What is the relationship between servers and ports?
How to create RDD?
Do you know anyone who works with Ross Stores?
What are the advantages of devops int respect of technical and business perspective?
What is the difference between a css reset and normalize.css?
Is apache tapestry free/open source?
How do I select a table in mysql?
I want to ask that is there any relation between current denesity of copper and material purity. also is ther any standard which defines the standard current denesity of material.
what are the program that using a two dimensional array that list the odd numbers and even numbers separately in a given 10 inputs values