Sawaal
  • Home/
  • Searching for u

 Searching for "u"

Q:

Go command is a signal to execute the entire batch of SQL statements after previous Go

A) TRUE B) FALSE
Answer & Explanation Answer: A) TRUE

Explanation:
Report Error

View Answer Workspace Report Error Discuss

Subject: Oracle Certification
Job Role: Database Administration

Q:

The difference between Simple Interest and True Discount on a certain sum of money for 6 months at 1212% per annum is Rs 25. Find the sum.

A) Rs.6800 B) Rs.6500
C) Rs.6000 D) Rs.6200
 
Answer & Explanation Answer: A) Rs.6800

Explanation:

 

 

Report Error

View Answer Report Error Discuss

Filed Under: True Discount

Q:

Explain Data Control Language

Answer

Data Control Language (DCL):-statements to take care of the security and authorization.


Examples:



    1. GRANT

    2. REVOKE

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle Certification
Job Role: Database Administration

Q:

Explain Data Definition Language

Answer

Data Definition Language (DDL):- are the SQL statements that define the database structure.


Example:



  1.  CREATE

  2.  ALTER

  3.  DROP

  4.  TRUNCATE

  5.  COMMENT

  6.  RENAME

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle Certification
Job Role: Database Administration

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.

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) =1623 %

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:

ke

Report Error

View Answer Report Error Discuss

Filed Under: Calendar