IPL Cricket Match 2011 Schedule (Time Table)

Apr 08 8PM .        Chennai Super Kings vs Kolkata Knight Riders Chennai

Apr 09 4PM .        Deccan Chargers vs Rajasthan Royals Hyderabad
Apr 09 8PM .        Kochi v Royal Challengers Bangalore Kochi
Apr 10 4PM .        Delhi Daredevils vs Mumbai Indians Delhi
Apr 10 8PM .        Pune Warriors vs Kings XI Punjab Navi Mumbai
Apr 11 8PM .        Kolkata Knight Riders vs Deccan Chargers Kolkata
Apr 12 4PM .        Rajasthan Royals vs Delhi Daredevils Jaipur
Apr 12 8PM .        Royal Challengers Bangalore vs Mumbai Indians Bangalore
Apr 13 4PM .        Pune Warriors vs Kochi Navi Mumbai
Apr 13 8PM .        Kings XI Punjab vs Chennai Super Kings Mohali
Apr 14 8PM .        Deccan Chargers vs Royal Challengers Bangalore Hyderabad
Apr 15 4PM .        Mumbai Indians v Kochi Mumbai
Apr 15 8PM .        Delhi Daredevils v Kolkata Knight Riders Delhi
Apr 16 4PM .        Chennai Super Kings v Royal Challengers Bangalore Chennai
Apr 16 8PM .        Deccan Chargers v Kings XI Punjab Hyderabad
Apr 17 4PM .        Rajasthan v Kolkata Knight Riders Jaipur
Apr 17 8PM .        Pune Warriors v Delhi Daredevils Navi Mumbai
Apr 18 8PM .        Kochi v Chennai Super Kings Kochi
Apr 19 4PM .        Delhi Daredevils vs Deccan Chargers Delhi
Apr 19 8PM .        Royal Challengers Bangalore v Rajasthan Royals Bangalore

Apr 20 4PM .        Mumbai Indians v Pune Warriors Mumbai
Apr 20 8PM .        Kolkata Knight Riders v Kochi Kolkata
Apr 21 8PM .        Kings XI Punjab v Rajasthan Royals Mohali
Apr 22 8PM .        Mumbai Indians v Chennai Super Kings Mumbai
Apr 23 4PM .        Kolkata Knight Riders v Royal Challengers Bangalore Kolkata
Apr 23 8PM .        Delhi Daredevils v Kings XI Punjab Delhi
Apr 24 4PM .        Deccan Chargers v Mumbai Indians Hyderabad
Apr 24 8PM .        Rajasthan Royals v Kochi Jaipur
Apr 25 8PM .        Chennai Super Kings v Pune Warriors Chennai
Apr 26 8PM .        Delhi Daredevils v Royal Challengers Bangalore Delhi
Apr 27 4PM .        Pune Warriors v Chennai Super Kings Navi Mumbai
Apr 27 8PM .        Kochi v Deccan Chargers Kochi
Apr 28 4PM .        Kolkata Knight Riders v Kings XI Punjab Kolkata
Apr 28 8PM .        Rajasthan Royals v Mumbai Indians Jaipur
Apr 29 8PM .        Royal Challengers Bangalore v Pune Bangalore
Apr 30 4PM .        Kochi v Delhi Daredevils Kochi
Apr 30 8PM .        Mumbai Indians v Kings XI Punjab Mumbai
May 01 4PM .       Rajasthan Royals v Pune Warriors Jaipur
May 01 8PM .       Chennai Super Kings v Deccan Chargers Chennai
May 02 8PM .       Delhi Daredevils v Kochi Delhi
May 03 8PM .       Deccan Chargers v Kolkata Knight Riders Hyderabad
May 04 4PM .       Chennai Super Kings v Rajasthan Royals Chennai
May 04 8PM .       Pune Warriors v Mumbai Indians Navi Mumbai
May 05 4PM .       Kochi v Kolkata Knight Riders Kochi
May 05 8PM .       Deccan Chargers v Delhi Daredevils Hyderabad
May 06 8PM .       Royal Challengers Bangalore v Kings XI Punjab Bangalore
May 07 4PM .       Kolkata Knight Riders v Chennai Super Kings Kolkata
May 07 8PM .       Mumbai Indians v Delhi Daredevils Mumbai
May 08 4PM .       Royal Challengers Bangalore v Kochi Bangalore
May 08 8PM .       Kings XI Punjab v Pune Warriors Mohali
May 09 8PM .       Rajasthan Royals v Chennai Super Kings Jaipur
May 10 4PM .       Kings XI Punjab v Mumbai Indians Mohali
May 10 8PM .       Deccan Chargers v Pune Warriors Hyderabad
May 11 8PM .       Rajasthan Royals v Royal Challengers Bangalore Jaipur
May 12 8PM .       Chennai Super Kings v Delhi Daredevils Chennai
May 13 8PM .       Kochi v Kings XI Punjab Indore
May 14 4PM .       Mumbai Indians v Deccan Chargers Mumbai
May 14 8PM .       Royal Challengers Bangalore v Kolkata Knight Riders Bangalore
May 15 4PM .       Kings XI Punjab v Delhi Daredevils Dharamsala
May 15 8PM .       Kochi v Rajasthan Royals Indore
May 16 8PM .       Kolkata Knight Riders v Mumbai Indians Kolkata
May 17 8PM .       Pune Warriors v Deccan Chargers Pune
May 18 4PM .       Kings XI Punjab v Royal Challengers Bangalore Dharamsala
May 18 8PM .       Chennai Super Kings v Kochi Chennai
May 19 8PM .       Pune Warriors v Kolkata Knight Riders Pune
May 20 8PM .       Mumbai Indians v Rajasthan Royals Mumbai
May 21 4PM .       Kings XI Punjab v Deccan Chargers Dharamsala
May 21 8PM .       Delhi Daredevils v Pune Warriors Delhi
May 22 4PM .       Royal Challengers Bangalore v Chennai Super Kings Bangalore
May 22 8PM .       Kolkata Knight Riders v Rajasthan Royals Kolkata

May 24            8PM .              Qualifier 1 Mumbai
May 25            8PM .              Eliminator Mumbai
May 27            8PM .              Qualifier 2 Chennai

May          28 8PM .           Final Chennai

Websites for Online Earning by click on Ads

twodollarclick.com

neodollar.com

neobux.com

onbux.com

infinitybux.com

Coloursbux.com

TenAdsPlus.com

BirdyBux.com

IncraseBux.com

Top 10 interview question for Oracle PL/SQL ?

1.          How can delete duplicate rows from table ?

Delete from table_name where rowid not in( Select max(rowid) from table_name

Group by duplicate_value_fields)

2.          How can find Max 5^th Salary from Salary table ?

Select * From (Select Column1, Column2 from table_name

Order by Column_Name) Where rownum <=5)

3.          What is NVL function into Oracle ?

In Oracle PL/SQL, the NVL function lets us substitute a value when a null value is encountered.

The syntax of NVL function is:

NVL( str1, replaceWith )

str1 is the string to test for a null value.

replaceWith is the value returned if str1 is null.

4.          What is Triggers ?

Triggers are similar to procedures, in that they are named PL/SQL blocks with declarative, executable, and exception-handling sections. However, a procedure is executed explicitly from another block via a procedure call, with can also pass arguments. A trigger is executed implicitly whenever the triggering event happens, and a trigger doesn’t accept arguments. The act of executing a trigger is known as firing the trigger. The triggering event is a DML (INSERT, UPDATE, or DELETE) operation on database table.

Triggers can be used for many things, including

§ Maintaining complex integrity constraints not possible through declarative constraints enabled at table creation

§ Auditing information in a table by recording the changes made and who made them

§ Automatically signaling other programs that action needs to take place when changes are made to a table

5.       What is Synonyms ?

Table references can be complicated, especially if a schema and/or database link is included. In order to make maintenance easier, Oracle allows you to create a synonym for a complicated reference. The synonym essentially renames the table reference, similar to an alias for a select list item. However, a synonym is a data dictionary object and is created by the CREATE SYNONYM DDL statement:

            CREATE SYNONYM synonym_name FOR reference;

6.       What is Cursor ?

A cursor is a handle, or pointer, to the context area. Through the cursor, a PL/SQL program can control the context area and what happens to it as the statements is processed. Types of cursor

§     Explicit cursor (%Found, %NotFound, %RowCount & %IsOpen)

§     Implicit cursor (%Found, %NotFound, %RowCount & %IsOpen)

7.       What is Identifiers ?

Identifiers are used to name PL/SQL objects, such as variables, cursors, and subprograms. Identifiers consist of a letter optionally followed by any sequence of characters including letters, numbers, dollar signs, underscores, and pound signs. Other characters are illegal. The maximum length for an identifier is 30 characters, and all characters are significant. For example

X

V_studentId

TempVar

8.       What is View ?

A simple view can be thought of as a subset of a table. It can be used for retrieving data, as well as updating or deleting rows.

      Example

CREATE VIEW v_Emp

AS SELECT First_Name, Last_Name, Phone, Country

FROM Emp_Master

9.       What is Sign Function ?

Its’ check the numeric value and return followings:

                     1 – for Positive value

                     0 – for Zero

                   -1 – for Negative value

10.   Exceptions into PL/SQL ?

1.       Too_many_rows

2.       No_data_found

3.       Value_Error

4.       Zero_Error

5.       Others