Job Roles

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

Examples:

1. GRANT


2. REVOKE

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

XPath is an expressions to select a xml node in an XML document.

It allows the navigation on the XML document to the straight to the element where we need to reach and access the attributes.

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.

Amount = Rs. (30000 + 4347) = Rs. 34347.

Let the time be n years.

Then, 30000*(1+7/100)^n=34347

n= 2 years

 C.I. when interest compounded yearly

Rs.5000*1+4100*1+12*4100

 Rs.5000*2625*5150

=Rs.5034

C.I. when interest iscompounded half-yearly 

 Rs.5000*1+21003

= Rs. 5306.04

Difference = Rs. (5306.04 - 5304) = Rs. 2.04

Let P = Rs. 100. Then, S.I. Rs. 60 and T = 6 years.

R=100*60100*6 =10% p.a

Now, P = Rs. 12000. T = 3 years and R = 10% p.a.

C.I=Rs.12000*1+101003-1
       =Rs.3972