i Search

Q:

What is the purpose of SQL Profiler in SQL server?

Answer

SQL profiler is a tool to monitor performance of various stored procedures. It is used to debug the queries and procedures. Based on performance, it identifies the slow executing queries. Capture any problems by capturing the events on production environment so that they can be solved.

Workspace

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle Certification
Job Role: Database Administration

Q:

The TrueDiscount on a certain sum of money due 3 years hence is Rs.250 and SimpeInterest on the same sum for same time and same rate is Rs375. Find sum and rate%?

A) (16 + 4/3)%	B) (16 +1/3)%
C) (16 + 5/3)%	D) (16 + 2/3)%

Answer & Explanation Answer: D) (16 + 2/3)%

Explanation:

sum = [(S.I x T.D)/(S.I-T.D)] = Rs. [(375 x 250)/(375-250)] = Rs.750

Rate = (100 x 375)/(750 x 3) = $16 \frac{2}{3}$ %

Report Error

View Answer Report Error Discuss

Filed Under: True Discount

Q:

The true discount on a bill due 9 months hence at 12% per annum is Rs 540. Find the amount of the bill and its present worth?

A) 1600	B) 7000
C) 6000	D) 6500

Answer & Explanation Answer: C) 6000

Explanation:

Let amount be Rs.x then,

[X * R * T] / [100 + (R * T)] = T.D

=> [x * 12 * (3/4)] / [100+(12 * 3/4)] =540

=> x = 6540

Amount = Rs.6540

P.W = Rs.(6540 -540) = Rs.6000

Report Error

View Answer Report Error Discuss

Filed Under: True Discount

Q:

On 8th Feb, 2005 it was Tuesday. What was the day of the week on 8th Feb, 2004?

A) Tuesday	B) Monday
C) Sunday	D) Wednesday

Answer & Explanation Answer: C) Sunday

Explanation:

Report Error

View Answer Report Error Discuss

Filed Under: Calendar

Q:

January 1, 2007 was Monday. What day of the week lies on Jan. 1, 2008?

A) Monday	B) Tuesday
C) Wednesday	D) Sunday

Answer & Explanation Answer: B) Tuesday

Explanation:

The year 2007 is an ordinary year. So, it has 1 odd day.

1st day of the year 2007 was Monday

1st day of the year 2008 will be 1 day beyond Monday

Hence, It will be Tuesday.

Report Error

View Answer Report Error Discuss

Filed Under: Calendar

Q:

Find the present worth of Rs.930 due 3 years hence at 8% per annum.Aso find the discount?

A) 186	B) 180
C) 185	D) 189

Answer & Explanation Answer: B) 180

Explanation:

P.W = [100 x Amount] / [100+(R x T)]

=[100 x 930] / [100+(8x3)] = Rs. 750

T.D = Amount - P.W = 930 - 750 = Rs.180

Report Error

View Answer Report Error Discuss

Filed Under: True Discount

Q:

What will be the day of the week 15th August, 2010?

A) Sunday	B) Monday
C) Tuesday	D) Friday

Answer & Explanation Answer: A) Sunday

Explanation:

Report Error

View Answer Report Error Discuss

Filed Under: Calendar

Q:

If 6th March, 2005 is Monday, what was the day of the week on 6th March, 2004?

A) Sunday	B) Saturday
C) Tuesday	D) Wednesday

Answer & Explanation Answer: A) Sunday

Explanation:

Report Error

View Answer Report Error Discuss

Filed Under: Calendar

Searching for "i"

Quick Links